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

Опубликовано: 16 Октябрь 2024
на канале: Chandoo
89,194
2k

🏆 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/upl...

📺 MORE DASHBOARDS + POWER BI
===============================

Power BI Beginner to PRO Masterclass -    • Beginner to PRO Data Analysis with Po...  
Sales Dashboard with Power BI -    • How to Make a Sales Dashboard in Powe...  
HR Dashboard with Power BI -    • HR Data Analytics & Awesome Dashboard...  
Data Analysis with Power BI (live stream masterclass) -    • Data Analysis with Power BI - from st...  
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-...  

💥 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