Join me for a live data analysis in Power BI class. We are going to understand how to load up, cleanse and analyse a bunch of financial data (budget vs. actual) with Power BI. Do bring your helmets as this one going to blow your minds 🤯🤯🤯
👉👉👉 Sample file & datasets:
==============================
Blank Data files:
URL for Actuals: https://chandoo.org/wp/wp-content/uploads/2022/09/actuals.csv
URL for Targets: https://chandoo.org/wp/wp-content/uploads/2022/09/targets.csv
Completed workbook - https://files.chandoo.org/pbix/live-stream-file.pbix
Important Timestamps:
===================
0:00 - Introduction
26:43 unpivot other columns
29:19 date format in target
39:00 right click query targets → reference (to duplicate queries, remove other columns, remove duplicates)
40:35 date format
55:43 measures
59:35 customize current theme
1:07:25 measure total target
1:12:46 be careful when selecting the salesperson to choose the one from table targets, otherwise you get in total tagets the sum of all targets and is just a big mess. Chandoo mentioned this as well
1:13:38 right click variance % data bars
1:16:22 click the three dots and sort
Additional videos you should watch on POWER BI:
========================================
Power Query INTRO - https://youtu.be/PiFAa_jjaEI
Power BI Sales Dashboard in one hour - https://youtu.be/mXD0Peot4hY
Power BI Beginner to PRO Data analysis - https://youtu.be/uwe8C7K8fXY
How to write DAX - https://youtu.be/PQ5lALdFHCU
10 Power BI Tips for better visuals - https://youtu.be/5TS2s6gXO1k
💥 Want more? TRY my Power BI Course - https://chandoo.org/wp/power-bi-course
~~~
Have a beautiful day 😃
#POWERBI #DATAANALYTICS
0 Comments