Make an Incredible Finance KPI Dashboard with Power BI in 20 minutes скачать в хорошем качестве

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

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 ====================== Just the dataset used in this video: https://chandoo.org/wp/wp-content/upl... 📺 MORE DASHBOARDS + POWER BI =============================== Power BI Beginner to PRO Masterclass -    • Beginner to PRO Data Analysis with Power B...   Sales Dashboard with Power BI -    • How to Make a Sales Dashboard in Power BI ...   HR Dashboard with Power BI -    • HR Data Analytics & Awesome Dashboard with...   Data Analysis with Power BI (live stream masterclass) -    • Data Analysis with Power BI - from start t...   Dashboard Design in Power BI (5 tips) -    • Power BI Dashboard Makeover - 5 Ideas   SQL + Power BI Dashboard -    • How to use SQL with Power BI 💡 ~ End-to-en...   💥 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