DAX / Power BI - Customer and Sales Analysis Deep Dive

Improve your DAX / Power BI customer and sales analysis skills in this deep dive course

4.10 (32 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
266
students
4.5 hours
content
Jul 2021
last update
$44.99
regular price

What you will learn

Techniques for performing customer, sales and purchase analysis

Cohort analysis

Customer segmentation

Cluster analysis

Ranking sales on multiple columns

Cross-selling analysis

Tracking trends in sales

Description

Power BI and DAX provide some impressive capabilities which allows us to perform many types of sales / purchase analysis and customer analysis. We will see much of that in this course.

Basically, a sales analysis is a detailed report, or set of reports, that shows a business's sales performance, as well as customer data and generated revenue, profits, and profit margins. The report defines the strengths and weaknesses of products and sales efforts by referencing historical and current metrics to detect emerging trends that are most relevant to a company.

Sales and customer analysis provides critical values from which analysts can make important business decisions. This enables management to make data-driven decisions rather than relying on guesswork. With insights into various sales channels, companies can discover where their most-profitable customers lie, where additional promotions are needed, and which products need quicker turnover or retirement.

A suite of customer and sales reports gives businesses the ability to pinpoint performance weaknesses and make effective improvements to promote sales, revenue, and profits.

There are at many types of customers, sales, and purchase analysis methods. Power BI and DAX have the breadth and depth of functionality to allow us to perform analysis such as:

· Sales Trend Analysis

· Sales Performance Analysis

· Predictive Sales Analysis

· Product Sales Analysis

· Customer churn (retention)

· Cluster Analysis

· Cohort Analysis

· Segmentation Analysis

· Pareto Analysis

In this course you will learn how to perform all of these types of analyses and much more. And you will get to work on a fun project at the end of the course.

Content

Introduction

Introduction
Datasets used in the course
A chance to practice along the way

New, existing and lost customer analysis

New customers
Total, new, returning and lost customer counts
Another new way of looking at new customer sales
Cohort analysis
More cohort analysis

Customer purchase analysis

Customers making multiple purchases
More customers making multiple purchases
Which product did customers first purchase and how is this useful?
Determining top customers for each product category
Customer unique products purchase analysis
Analyzing customer purchase averages
Customer segmentation

Sales Analysis

Profit margin analysis
Tracking trends in sales revenue and profit margins
Displaying top N sales people
Ranking sales on multiple columns
Forecasting sales using time series analysis
The Pareto Principal - How useful, and accurate, is it in analyzing sales?
Cross-selling analysis
Simple clustering analysis
Top sales per...

End of course project

Description of project
Project solution

Screenshots

DAX / Power BI - Customer and Sales Analysis Deep Dive - Screenshot_01DAX / Power BI - Customer and Sales Analysis Deep Dive - Screenshot_02DAX / Power BI - Customer and Sales Analysis Deep Dive - Screenshot_03DAX / Power BI - Customer and Sales Analysis Deep Dive - Screenshot_04

Reviews

Hape
February 21, 2023
This course certainly not for beginners, having a working knowledge of DAX would be helpful. It has allowed me to have a comprehension understanding of DAX and its applications, and lecturer is very engaging.
Hitesh
March 8, 2022
you didnt explained the patterns and you should have created dax from scratch to demonstrate the idea behind dax. if i have to study like i can do youtube or go to website

Charts

Price

DAX / Power BI - Customer and Sales Analysis Deep Dive - Price chart

Rating

DAX / Power BI - Customer and Sales Analysis Deep Dive - Ratings chart

Enrollment distribution

DAX / Power BI - Customer and Sales Analysis Deep Dive - Distribution chart

Related Topics

4160980
udemy ID
7/2/2021
course created date
7/11/2021
course indexed date
Bot
course submited by