Latest Blog/Articles
Popular Topics
Subscribe Newsletter
May 2, 2022
A recurring problem that Power BI users find is that of incorrect totals. Here is an example: I have a table with Salespeople and their monthly sales, based on that I want to calculate their sales incentive. The sales incentive is equal to 5% of the sales if they sell more than 80k$, otherwise it’s ...
Read More
May 2, 2022
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 ...
Read More
May 2, 2022
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 ...
Read More
May 2, 2022
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 ...
Read More
May 2, 2022
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 ...
Read More
March 22, 2020
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 ...
Read More
LN Consulting
Tired Of Building A Dashboard By Yourself?
November 6, 2019
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 ...
Read More
November 1, 2019
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 ...
Read More
October 29, 2019
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 ...
Read More
October 22, 2019
Today I’ll show you how to calculate employee turnover rate in Power BI. Unsurprisingly, employee Turnover is a key HR metric. A high employee turnover leads to multiple costs including finding and hiring employees, onboarding them, training them, and the time spent on those tasks. A detailed article on employee turnover is available here. This post ...
Read More
October 20, 2019
Welcome to this post on calculating employee count by month in Power BI. The starting point is an Employees table with the start and end date of each employee. For employees currently at the company, the end date is empty. An example is below. The goal is the obtain a Power BI chart with the ...
Read More
October 17, 2019
A question often asked is ’how can I do a custom sort in Power BI’. It’s a common need but its implementation is not straightforward in Power BI. In this post, I will walk you through it in the easiest possible way. As an example, I will start with a Sales table that has 3 ...
Read More
LN Consulting
Tired Of Building A Dashboard By Yourself?