2 Hour Masterclass on Power BI - Create a Sales Analytics Dashboard (free files 📁)

The best way to learn Power BI is by doing an end-to-end portfolio project. In this video, we are going to do just that. Create a super awesome sales analytics dashboard and publish your work to GitHub. Right from data modelling to creating interactive dashboard, everything is clearly and neatly explained.

👩‍💻 What you will learn:
===================

1) How to design a dashboard in Power BI?
2) Data modelling with Power BI and star schema development
3) Identifying measures and KPIs for sales analytics
4) Creating measures and setting up a dedicated measure table
5) Time intelligence calculations in Power BI - MoM changes
6) Using the "new" card visual and reference labels
7) Fixing problems with DAX measures
8) Using Field parameters to create a dynamic trend chart
9) "Group" feature of Power BI to make histograms
10) Working with ZOOM SLIDER
11) Gauge chart to see Profit and LBS %
12) Table design in Power BI
13) Conditional formatting for tables
14) Bookmarks
15) Fixing problems with bookmarks - data / filter preservation
16) Setting up tooltips for country breakdown
17) Slicer panel set up in Power BI
18) Publishing the dashboard to Power BI service
19) Setting Github portfolio page


📁 DEMO +Sample data file:
========================

Live Demo: https://app.powerbi.com/view?r=eyJrIj...

Github link: https://github.com/chandoo-org/Power-...
Mirror link: https://chandoo.org/wp/wp-content/upl...

📂 Completed Power BI file + Video download
======================================

You can get the complete Power BI file, full HD video and more than 10 hours of Power BI lessons in my online Power BI course. Sign up here:

👉 https://chandoo.org/wp/power-bi-course/


⏱ Video Timestamps:
===================
0:00 - Introduction and what to expect
1:00 - Set up of our data and business situation
2:14 - Awesome Chocolates Data Model
3:00 - Data load to Power BI
5:43 - Star Schema creation in Power BI
6:40 - Defining the DAX measures
17:43 - Using the Calendar table to make "time intelligence" measures
27:22 - Wireframe design for our dashboard
31:55 - Dashboard page design and theme in Power BI
33:42 - KPI cards for the Power BI sales analytics dashboard
36:25 - Fixing the MoM calculation DAX
41:52 - Adding reference labels for the KPI cards
44:26 - Formatting the KPI section
48:56 - Profit % Gauge Chart
52:05 - Dynamic Trend Analysis Chart (with Field Parameters)
59:11 - Shipment Analysis (histogram + zoom slider)
1:05:45 - Sales Person Performance - Table design
1:23:30 - Product Performance Table
1:25:35 - Bookmark for Product vs. People view
1:34:27 - Filter panel design
1:39:28 - Tooltip design
1:44:16 - Final version (with two options!)
1:47:36 - Creating a portfolio on Github to share your project
1:53:58 - Congratulations on completing the Power BI project

~

📺 MORE POWER BI ⚡
===================

📚 Dashboards:

Finance Dashboard in Power BI (20 mins) -    • Make an Incredible Finance KPI Dashbo...  
Beginner to PRO lesson on Power BI (45 mins) -    • Beginner to PRO Data Analysis with Po...  
HR Dashboard with Power BI (30 mins) -    • HR Data Analytics & Awesome Dashboard...  
Dashboard re-design in Power BI -    • Power BI Dashboard Makeover - 5 Ideas  
Netflix EDA with Power BI -    • End to End Data Analysis Project with...  
SQL + Power BI - https://youtube.com/live/UQJAHUUFK-o?...


📘 DAX:
How to use Calculated Groups in Power BI -    • How to set up and use Calculation Gro...  
Beginner to PRO class on DAX -    • Learn Power Pivot & DAX for Power BI ...  


📗 Power Query:
How to make a calendar table -    • How to make the "perfect" CALENDAR TA...  
Power Query in 15 mins -    • Learn Power Query & Automate Boring D...  
Power Query masterclass (90 mins) -    • Power Query Tutorial - What is it, ho...  


📙 Power BI Concepts:
Dynamic Top 10 chart -    • How to make an interactive TOP 10 Cha...  
When and how to use various Power BI charts -    • How to pick the "perfect" chart for y...  
Power BI Free vs. Pro vs. Premium -    • Power BI: Free vs. Pro vs. Premium - ...  
How to create tooltips in Power BI -    • How to create Tooltip Pages in Power ...  
How to use Field Parameters in Power BI -    • Power BI Field Parameters - Why & how...  
Star Schema in Power BI (explanation) -    • How to setup a Star Schema Data Model...  
How to use Small Multiples in Power BI -    • How Jo uses Small Multiples to impres...  
How to make a slicer panel -    • How to make a Show / Hide SLICER PANE...  
What-if analysis with Power BI - https://youtube.com/live/jjT_yor0NuA?...

💥 Full course:
10 hours Power BI course - https://chandoo.org/wp/power-bi-course/

~

#powerbi #course