Latest Blog/Articles

In this post, I will teach you how to track new and repeat customers in Power BI. While new customers are key to a company’s growth, the cost of acquiring them is usually higher compared to repeat customers. It is therefore important to have a balanced growth between new and repeat customers. Below is the ...

In this article, you will learn how to run your Cohort Analysis in Power BI.  The cohort analysis is a powerful customer analysis: it segments customers based on when they first purchased a product. Specifically, it answers the questions: Are newer customers coming back more often than older customers? Are newer customers spending more than ...

In this post, I will teach you how to build a Pareto analysis dashboard in Power BI. Specifically, the Pareto principle states that 20% of the causes generate 80% of the effects, and vice-versa. We can apply this empirical principle to different topics, from work (20% of the efforts cause 80% of the results) to ...

Xero is an online accounting tool for small businesses. I have been working with it for the past few months and the richness of its features, along with its simplicity is impressive. You can check it out at www.xero.com. In this post, I will show you how to connect Xero to Power BI Desktop using ...

In this article, I will go through BOM explosion in Power BI. BOM is an acronym for Bill Of Material, the list of components included in a product. For example, a perfume box including a full-size perfume and a sample size perfume will have these two products listed in its BOM. “BOM explosion” is the ...

In this tutorial, I will show you how to create a sales variance dashboard in Power BI, which decomposes sales variance in quantity, price and mix variance. In particular, the variance dashboard highlights the main changes between budget and actual and allows you to drill-down on them: capitalize on positive variances and address negative variances. ...