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/wpcontent/upl...
URL for Targets: https://chandoo.org/wp/wpcontent/upl...
Completed workbook https://files.chandoo.org/pbix/lives...
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 • Power Query Tutorial What is it, ho...
Power BI Sales Dashboard in one hour • How to Make a Sales Dashboard in Powe...
Power BI Beginner to PRO Data analysis • Beginner to PRO Data Analysis with Po...
How to write DAX • Learn Power Pivot & DAX for Power BI ...
10 Power BI Tips for better visuals • 10 Power BI tips to make AMAZING Visu...
Want more? TRY my Power BI Course https://chandoo.org/wp/powerbicourse
~~~
Have a beautiful day
#POWERBI #DATAANALYTICS