Advance Sales Analytics for Decision Making with Power BI
4.4 (81 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,046 students enrolled

Advance Sales Analytics for Decision Making with Power BI

Learn to discover meaningful insights from your data to boost sales especially designed for Non-IT Professionals
4.4 (81 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,046 students enrolled
Created by Muhammad Kashif
Last updated 4/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 19 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build professional quality ADVANCE SALES ANALYTICS reports from ground up
  • Blend and transform raw data into beautiful INTERACTIVE DASHBOARDS
  • Showcase your skills with full scale course projects with SIX SPECIALIZED sales analytics dashboard (step by step solutions)
  • ARTIFICIAL INTELLIGENCE of Power BI to extract insights
  • Work comfortably with Microsoft Power BI
  • Work with large amount of data WITHOUT difficulty
  • Learn to use FILTERS and SLICERS to ask the MEANINGFUL questions of your data
  • Learn to create POWERFUL tables and matrix's of reporting data
  • Learn to use CUSTOM Visualizations and Themes in Power BI
  • SAVE huge amount of time which was previous consumed to extract same results
  • DYNAMICALLY interact with your data
  • Find insights PREVIOUSLY IT professionals could discover
  • Master DAX formulas and concepts
  • DISCOVER important Power BI tips & techniques
  • Use of MEASURE BRANCHING
  • WHAT IF PARAMETER in Reports
  • GROUPING TECHNIQUES for more insightful reports
  • VIRTUAL relationship among tables
Requirements
  • Microsoft Power BI Desktop (free download)
  • Absolutely no prior experience in Power BI is required as we will start from scratch
Description

According to Mckinsey in their report on “Unlocking the Power of Data in Sales,” they have identified that over 53 % of the High Performing sales organizations are those who are effectively using their data analytical skills to boost sales. They have used techniques like cross-selling opportunities or new customer analytics during the process. And we will do exactly the same in this course.

The digital universe is expanding with the passage of every day and organizations or persons who have the ability to utilize data analytics skills will have a competitive advantage by responding to the business challenges more quickly, more rigorously, and more successfully than their competitors.

This course is a perfect one-stop-shop for those of you who like to peruse a career in data analytics, business analytics, or Financial analysis. You will acquire practical skills that will turn you into a highly skillful talent which will be invaluable for your future career. Get excited as you have come to the right place at the right time.

This is one of the few courses on this topic that will equip you for detailed insights into sales analytics where we will start from very basics like how to install Power BI getting data into Power BI, develop a relationship among tables. We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI for:

  • Specialized Sales Analytics Insights

  • Product Insights, Customers Insights and Salespersons Insights

  • Prepare Sales Budgets

  • Artificial Intelligence of Power BI to extract insights

  • Specialized scenarios related to sales and their respective solutions in Power BI.

  • Discover real-life situations like cross-selling opportunities and new customer analytics

  • Basic to Advanced DAX calculations

  • Measure Branching

  • What if Parameter in Reports

  • Grouping Techniques

  • The virtual relationship among tables

  • Use of variables in DAX

  • Harness the real analytical power behind Power BI

  • Develop high-quality reporting solutions

  • Produce comprehensive insights that really create value

  • Using Custom visualizations and themes

The course material includes:

  • 45 video lectures of more than 4 hours

  • 10 PBIX (Power BI) files

  • 7 PDF lectures

  • 1 PDF file of all DAX functions

  • 2 specialized txt codes

  • 1 Dataset in excel

  • 1 JSON files

Who this course is for:

  • Business, finance and sales professionals who want to extract insights from sales data

  • Students who want to pressure career as data analytics, business or financial analyst

  • Excel users who want to learn how to create professional reports in Power BI related to sales.

Who this course is for:
  • Sales professionals who want to extract insights from sales data for better decision making
  • Students who want to pressure career as data analytics, business or financial analyst
  • Data analytics, business or financial analyst who wants to learns sales analytics
  • Excel users who want to learn how to create professional reports in Power BI related to sales.
Course content
Expand all 44 lectures 04:03:01
+ Basic Sales Analytics Session
12 lectures 48:23
Develop Key Calculation Table and Calculate Total Sales
05:21
Develop Dates Table
03:26
Calculate Total Cost and Total Profits
03:05
Calculate Total Unit Sold, Total Products and Profit Margin Percentage
05:44
Dashboard - Page Background with Title and key cards
04:39
Dashboard - Slicer of Years and Quarter
03:18
Dashboard - Total Sales by Location, Dates and Salesperson
06:23
Dashboard - Product-wise Sales with Map and Review of Sales Performance
08:50
+ Intermediate Sales Analytics Session
16 lectures 01:28:05
Product Insight - Calculate Top 5 Products
05:34
Product Insight - Calculate Year on Year (YoY) Sales Growth
07:17
Product Insight - Calculate Product Group Table and place it accordingly
05:58
Product Insight - Create Scatter Chart with Product Growth Groups
04:42
Product Insight Dashboard - Product Table Visualization
05:52
Product Insight Dashboard - Scatter Chart and Top Products
04:22
Product Insight Dashboard - Final Visualization and Product Review
06:24
Customer Insight - Calculate Top 5 Customers
03:32
Customer Insight - Time Intelligence Calculations
05:35
Customer Insight - Customer Ranking in the Scatter Chart
08:25
Customer Insight Dashboard - Final Visualization and Customer Review
04:59
Sales Summary Dashboard - Final Visualization and Sales Review
09:51
Sales Budget - Overview and Utilization of Time Intelligence Technique
03:57
Sales Budget - Budget Formula and Final Visualization
09:53
+ Advance Sales Analytics Session
11 lectures 01:19:00
Scenario 1 - Find out the Basket of Products
04:29
Scenario 2 - Find customers purchasing products more than one time
07:59
Scenario 3 - Find New Customers
14:35
Scenario 4 - Find cross selling opportunities 1 of 2
04:02
Scenario 4 - Find cross selling opportunities 2 of 2
12:56
Scenario 5 - Find the Customer Group with more YoY Sales Growth
11:00
Scenario 6 - Find the Product sales trends overtime
04:51
Scenario 7 - Find Salespersons which are growing their Profits Margin
06:35
AI Visual - Decomposition Tree
06:58
AI Visual - Key Influencer
04:36
+ Introduction to Power BI and DAX
2 lectures 10:09
Introduction about Power BI and How it is Installed
04:25
Bird-eye view of Data Analysis Expression (DAX)
05:44
+ Bonus Lecture
1 lecture 06:37
Advance Visualization Technique
06:37