Make an Incredible Finance KPI Dashboard with Power BI in 20 minutes

🏆 Participate in my Dashboard Competition 👉 https://bit.ly/3xgC1WB ~ Make an incredible Power BI Dashboard to visualize your finance KPI data in just 20 minutes. In this video, learn how to take raw business 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 Analysis 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