Analytics

The truth is that being an analyst is all about balancing quality versus speed. This manifests itself in finding good tools which help make you more efficient. If there is one thing that analysts all agree upon, it is that no single tool does everything great. One piece of my advice to analysts is to […]

Showing the last refresh date and time in a Power BI report let you know how to refresh your report data, as sometimes the report viewer can not remember the last date and time when report data was refreshed. Just in case, when you never refresh the report, Power BI keeps showing existing data until […]

Images as a Filter As technology is evolving so, the reporting standards need to be in sync with the current trend. Nowadays, looking at the numbers is not only the purpose of the dashboard but how your dashboard looks in terms of the colour, graphs, filter position, etc. Also, users are leaner toward the interactive […]

Dynamic Data Source in Power BI Power BI is a very powerful tool, and we can do wonders with it, but when it comes to changing the source, most of us are afraid of it. This is because by doing so, we may need to make many changes related to a data model, DAX, visualizations, […]

The Challenge in Supply Chain Let’s face it. You and your suppliers are linked together and what they do affects you. So if your supplier data is fragmented across dozens or even hundreds of systems, it’s probably costing you. What is causing these supply chain leaks? Data stored in various places like supply chain management […]

Live Connection Mode: Power BI Live Connection is one of the connection modes to connect the data source into Power BI, just like Import and Direct Query. As of now, some of the cloud data sources we can connect through Power BI Live Connection are: Azure Analysis Services SQL Server Analysis Services Tabular  SQL Server […]

Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right building blocks is a crucial part of running a good business. This is where the dynamic duo of ETL and SQL comes into play. While you may […]

I had a bug in a TM1 application recently that was very difficult to track down, and it was because I didn’t understand the different ways that TM1 might respond to vague or incorrect MDX expressions.  MDX makes some unexpected assumptions. Take the following simplified example cube: Let’s say that I have an active form […]

Denodo Virtual DataPort tool can import data coming from different systems and with different structures or formats. To Retrieve Data from the source, views are created in Denodo. I will be using an Oracle 11g data source to fetch the data here and Denodo Web Design studio to create views. “To know more about connecting […]

What is the use of Denodo? It allows business users to examine the particular data mistreatment associated with an intuitive interface through the Denodo Platform.   Data sources supported by the Denodo Platform Denodo Platform supports many different data sources like Amazon Redshift, Apache Derby, Apache Spark SQL, Greenplum, Hadoop, Hive, Microsoft SQL Server, Netezza, […]

Have you ever wondered how wonderful it would be if things like switching on lights, opening the doors, email replies, etc. which we require in day-to-day life become automated? Life would become easier, and humans will be able to take out time for themselves. Well, this is now possible thanks to AI and IoT. So, […]

The Find Command I come from a systems background in Windows and Linux, maintaining operations and writing programs in C.  Since I bring that perspective to my TM1 work, I’m more comfortable with command line tools than some of my other teammates, so I thought I would share some tips. As an example, let’s look […]