Tag: Sales Analysis

Why You Need To Learn Dax – A DAX Overview

What Is DAX And Why Do You Need To Learn It

In this blog post, I’m going to go over why you need to learn DAX and provide an overview of what it is. I’m going to show you some examples of what we can achieve if we use DAX intelligently in Power BI. Let’s start. Sales Analysis In this example, we have a sales analysis

Continue reading

Showing Sales Growth In Power BI Reports

In this Power BI Showcase, we’ll go through reports showing the Sales Growth analysis of a large organization. These reports use large amounts of current and historical financial data to create analysis on the sources of Revenue. For this example, we also want to know where our Sales growth is coming from. Using the dynamic

Continue reading

Pareto Analysis: Who Are The Top 20% Customers

Hey everyone, have I got an interesting insight for you! In this article, I’m going to go over the Pareto analysis and help you identify your top 20% customers. Not only do we want to break out the top 20% versus the bottom 80%, we also want to delve deeper into that top 20% and

Continue reading

Break Out New Customer Sales – Advanced Power BI Insights

In this tutorial, I wanted to go over new customer sales and teach you how to calculate it using your Power BI model. When you’re working out who your new customers are, you first of all need to make sure you have a sound understanding of how you classify a new customer. The calculation and

Continue reading

Preventing Year To Date Results From Projecting Forward

Today, I’m going to go over a solution for a certain issue regarding Year to Date (YTD) calculations. This actually stemmed from a question in the Enterprise DNA Support Forum. I’ll leave a link below to the forum discussion if you’d want to review it. You can view this forum post here – YTD Showing

Continue reading