🏆 Participate in my Dashboard Competition 👉 https://bit.ly/3xgC1WB
~
Make an incredible Power BI Dashboard to visualize your money management KPI data in just 20 minutes. In this video, learn how to take raw company data and turn it into useful insights by following these 4 steps:
1) Data Preparation – Connecting and transforming data using Power Query in Power BI
2) Data Modelling – Setting up a semantic model in Power BI with table relationships.
3) Calculations – Performing necessary number crunching using the DAX in Power Pivot
4) Dashboard Visuals & Interactions – Creating and customizing various visuals to generate our KPI dashboard.
Key topics / ideas you will learn are:
1) Power Query unpivot
2) Data Modelling with multiple fact tables
3) DAX calculations for YTD values
4) Using Emoji with DAX
5) Using FILTER function in DAX
6) Working with the “NEW” card visual and reference labels
7) Using custom data labels with graphs
8) Sparklines in table visual
9) Working with Power BI report themes
10) Smart narrative feature of Power BI
11) Table formatting for executive reporting
12) + plus many other useful tips and tricks
⏱ VIDEO CHAPTERS:
==================
0:00 – Step 1: Data Preparation for KPI Dashboard in Power BI
2:45 – Announcing Power BI Dashboard Competition 🏆
4:10 – Step 2: Data Modelling
5:26 – DAX Calculations
9:12 – Making the Dashboard
10:58 – Using Reference Label feature to add context to the KPI cards
12:01 – Win/loss chart in Power BI
13:02 – Enhancing variance Labels with Emoji
15:27 – Monthly Trend Graph
17:59 – Sales Person Performance Table
20:42 – Adding Smart Narrative with Power BI (AI generated commentary)
21:19 – Final version of the report (with bells and whistles)
📁 Download Sample Data
======================
For the competition – https://bit.ly/3xgC1WB
Just the dataset used in this video:
https://chandoo.org/wp/wp-content/uploads/2024/04/actual-vs-target-dataset.xlsx
📺 MORE DASHBOARDS + POWER BI
===============================
Power BI Beginner to PRO Masterclass – https://youtu.be/uwe8C7K8fXY
Sales Dashboard with Power BI – https://youtu.be/mXD0Peot4hY
HR Dashboard with Power BI – https://youtu.be/5KaIU-9EF-0
Data study with Power BI (live stream masterclass) – https://youtu.be/8tfcVnoEL0c
Dashboard Design in Power BI (5 tips) – https://youtu.be/XadqG2SrVSc
SQL + Power BI Dashboard – https://youtu.be/UQJAHUUFK-o
💥 POWER BI FULL COURSE:
========================
Join my Power BI full course and learn the technology the right way.
https://chandoo.org/wp/power-bi-course/
#powerbi
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.