Latest Blog/Articles

In this tutorial, I will teach you how to run a Basket Analysis in Power BI.  The Basket Analysis uncovers the products bought together by consumers. In the context of a grocery store, for example, this analysis might show that whipped cream and berries are frequently bought together.  Based on this result, you can:– place ...

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 ...

In this tutorial, I will walk you through creating your own Power BI News Dashboard, which visualizes news about any topic that might interest you. While most of us use Power BI to analyze our own data, the ‘Get Data from Web’ functionality makes it just as easy to analyze external data. The possibilities are ...

In this article, I will guide you through creating your own Power BI dashboard for tracking tickets. While seemingly mundane, tracking tickets is key to the success of the customer service and IT department and impacts the success of a company. If you are looking for an in-depth review of the KPIs for your customer ...

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. ...