FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“) @chandoo_
FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“)  @chandoo_
Uploaded July 2024 | Updated November 2026, 15 hours ago
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: app.powerbi.com/view?r=eyJrIjoiNWJiNDQ4YTQtNWIxNi00NmE5LTk1MWEtNmNkZGUyM2U4ZmEwIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9

Github link: github.com/chandoo-org/Power-BI/blob/main/ac-sample-data.xlsx
Mirror link: chandoo.org/wp/wp-content/uploads/2024/07/ac-sample-data.xlsx
Icons & Files: github.com/chandoo-org/Power-BI

πŸ“‚ 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:

πŸ‘‰ 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) - youtu.be/i3AR0gt9SHA
Beginner to PRO lesson on Power BI (45 mins) - youtu.be/uwe8C7K8fXY
HR Dashboard with Power BI (30 mins) - youtu.be/5KaIU-9EF-0
Dashboard re-design in Power BI - youtu.be/XadqG2SrVSc
Netflix EDA with Power BI - youtu.be/iGUqad1eNtQ
SQL + Power BI - youtube.com/live/UQJAHUUFK-o?feature=share


πŸ“˜ DAX:
How to use Calculated Groups in Power BI - youtu.be/WnLtC3udzSQ
Beginner to PRO class on DAX - youtu.be/PQ5lALdFHCU


πŸ“— Power Query:
How to make a calendar table - youtu.be/wN1ok8JDzrI
Power Query in 15 mins - youtu.be/UAFExySaSPY
Power Query masterclass (90 mins) - youtu.be/PiFAa_jjaEI


πŸ“™ Power BI Concepts:
Dynamic Top 10 chart - youtu.be/uQV5MP_THfA
When and how to use various Power BI charts - youtu.be/5jrsrSDEMxE
Power BI Free vs. Pro vs. Premium - youtu.be/6tTJkA3Cv_w
How to create tooltips in Power BI - youtu.be/npaQ42K1sTs
How to use Field Parameters in Power BI - youtu.be/IR62y8Q_k-o
Star Schema in Power BI (explanation) - youtu.be/1CgG0t59WcM
How to use Small Multiples in Power BI - youtu.be/Jzu2wfyYF9I
How to make a slicer panel - youtu.be/luVczt-NQ6M
What-if analysis with Power BI - youtube.com/live/jjT_yor0NuA?feature=share

πŸ’₯ Full course:
10 hours Power BI course - chandoo.org/wp/power-bi-course

~

#powerbi #course
FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“)Excel Drop Down Lists that Auto-Expand with Your Data - Easy Trick πŸ’‘Make a Gantt Chart in Excel with Just One Formula!Combine 2 Tables Quickly with this AMAZING Excel FormulaThis Simple VBA Trick Saved me Hours Today πŸ’‘How to make a Map Chart in Excel - Quick & Simple TutorialLearn Advance Excel Formulas in an Hour - FREE MasterclassPower BI Real-time Dashboard - Masterclass (with FREE sample file πŸ“)Power BI Visuals Masterclass – Make Charts That Actually Tell a StoryHow to create a Work Schedule (Roster) using ExcelFind the Longest Winning Streak in Excel #excel #tutorial #exceltipsLearn Tableau in 15 minutes and create your first report (FREE Sample Files)
Chandoo |

FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER