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