Supply chain constraints and logistics efficiency emerged at the forefront of conversations a few years ago, following the pandemic and its aftermath. Suddenly, the items we desired were either out of stock, or e-commerce deliveries were delayed or expensive. Geopolitical tensions, high energy prices, and the growing use of technology are expected to reshape the […]
Rising energy and food prices, geopolitical tensions, growing use of multiple currencies for global trade settlements, and disruptive technology define our present. How can organizations forecast and plan for the future and contingencies? Business intelligence, derived from data collection and management, is one way of becoming future-ready. Data analytics and governance are among the top […]
Macroeconomic events over the past few years have unfolded at a dizzying pace, creating uncertainty for many businesses. In the backdrop of this transformational change, businesses are now looking at ways to ensure the efficiency of operations, achieve customer satisfaction, and stay relevant and competitive. And data becomes the central thread across all these areas. […]
People and organizations are using an ever increasing number of devices and applications, resulting in the generation of large data volumes. According to one estimation, 2025 will see the creation of 175 trillion gigabytes (175 zettabytes) of data! These vast amounts of unstructured data or data overload, whether it’s stored on-premises, on the cloud, or […]
Creating a Power BI data model from a flat file source hosted on SharePoint or Azure Data Lake Store can be cumbersome. I recently found this out trying to create a simple data model for a demo, which involved files sized over 3 gigabytes. Every time I performed a transformation in Power Query and hit Close […]
Obviously, T-SQL and DAX are two different query languages and they serve entirely different purposes. However, as someone from a database development background, when I learnt DAX initially, I started thinking SQL and tried to achieve the same thing from DAX. The reason for that thinking process is that it is always easy to learn something new when we […]
It was only a matter of time till the complete Microsoft on-premise Business Intelligence stack was moved to the Azure Paas service. With the introduction of Azure Data Factory (ADF) back in 2015 and the recent launch of ADF V2, which is in public preview for the moment, it is now possible to orchestrate complex […]
Dynamic row-level security enables report authors to filter data based on the user roles. This prevents developers from having to maintain separate security matrices. This also avoids the complexity of maintaining users under different security roles. Since most organizations have the required information about users in their databases, implementing dynamic-row level severity will be an […]
There are many ways to write DAX code to implement measures in the tabular model but writing improper DAX code may slow down the performance of the tabular model. I have encountered this problem during a recent tabular project implementation where, when you use conditional checking commands in DAX against a large number of rows, […]