DAX / Power BI – Customer and Sales Analysis Deep Dive

DAX / Power BI – Customer and Sales Analysis Deep Dive, available at $44.99, has an average rating of 4.35, with 26 lectures, based on 34 reviews, and has 281 subscribers.

You will learn about 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 This course is ideal for individuals who are DAX and Power BI developers needing to understand how to using DAX and Power BI to perform customer, sales and purchase analysis It is particularly useful for DAX and Power BI developers needing to understand how to using DAX and Power BI to perform customer, sales and purchase analysis.

Enroll now: DAX / Power BI – Customer and Sales Analysis Deep Dive

Summary

Title: DAX / Power BI – Customer and Sales Analysis Deep Dive

Price: $44.99

Average Rating: 4.35

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $24.99

Quality Status: approved

Status: Live

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

Who Should Attend

DAX and Power BI developers needing to understand how to using DAX and Power BI to perform customer, sales and purchase analysis

Target Audiences

DAX and Power BI developers needing to understand how to using DAX and Power BI to perform customer, sales and purchase analysis

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Datasets used in the course

Lecture 3: A chance to practice along the way

Chapter 2: New, existing and lost customer analysis

Lecture 1: New customers

Lecture 2: Total, new, returning and lost customer counts

Lecture 3: Another new way of looking at new customer sales

Lecture 4: Cohort analysis

Lecture 5: More cohort analysis

Chapter 3: Customer purchase analysis

Lecture 1: Customers making multiple purchases

Lecture 2: More customers making multiple purchases

Lecture 3: Which product did customers first purchase and how is this useful?

Lecture 4: Determining top customers for each product category

Lecture 5: Customer unique products purchase analysis

Lecture 6: Analyzing customer purchase averages

Lecture 7: Customer segmentation

Chapter 4: Sales Analysis

Lecture 1: Profit margin analysis

Lecture 2: Tracking trends in sales revenue and profit margins

Lecture 3: Displaying top N sales people

Lecture 4: Ranking sales on multiple columns

Lecture 5: Forecasting sales using time series analysis

Lecture 6: The Pareto Principal – How useful, and accurate, is it in analyzing sales?

Lecture 7: Cross-selling analysis

Lecture 8: Simple clustering analysis

Lecture 9: Top sales per…

Chapter 5: End of course project

Lecture 1: Description of project

Lecture 2: Project solution

Instructors

Randy Minder
Lead BI Developer / Power BI / Microsoft Fabric

Rating Distribution

1 stars: 2 votes
2 stars: 4 votes
3 stars: 2 votes
4 stars: 9 votes
5 stars: 17 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu