Category: Uncategorized

The pareto rule can be applied to almost all areas of life. Here, we are going to explore how we can calculate it in DAX, efficiently. Starting with the source calculation, which is adapted from the Dynamic – ABC Classification from the guys of SQLBI.com. With the addition of variables in DAX some calculations can…

Would you like to be able to turn raw data in from an Excel, CSV file, or a database into a nice looking dashboards. For example, a dashboard like the one above? Or, would you like to migrate your existing excel dashboards like the one below to a an analytical tool (like Power BI)? Well,…

Today, I am going to talk about large Power BI data models. A lot of times I explain my people about the scalability of the in-memory DAX engine that is responsible for holding and compressing the data in a Power BI model, I get the question what is the limit. What is like a maximum…

For BI reporting the financial general ledger in (i.e.) Dynamics NAV you have the G_L Entry table as a fact table and GL Account which is a dimension table linked. No problem with this. However … there is always a however… However, there are the so called totalling accounts, which as the name suggests are…

Sometimes in Customer Analysis we need to calculate the projected customer number. And the projected customer churn. In the demo dataset we have the given number of new customers and the retention factor for every year that customers stay with the company (by buying items, renewing subscriptions, etc.). The retention factor is the percent of…