Analytics

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 […]

                                                                      Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]

Diagnosis & Prescription are the terms often used in medical context. However today I want to walk you through how these terms are related to Data Analysis. There are mainly 4 types of Data Analysis: Focus of this blog is on Diagnostic & Prescriptive data analysis. Diagnostic Data Analysis: Diagnosis means identification of nature of […]

Have you ever wondered if it would ever be possible to time travel like in the old movies with a time machine? If we could go back in time and see the world, would we? If you asked me, I would have said yes! But not in the way that Hollywood portrays science fiction films. […]