Рет қаралды 241,792
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: chandoo.org/wp/wp-content/upl...
URL for Targets: chandoo.org/wp/wp-content/upl...
Completed workbook - files.chandoo.org/pbix/live-s...
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 -...
Power BI Sales Dashboard in one hour - • How to Make a Sales Da...
Power BI Beginner to PRO Data analysis - • Beginner to PRO Data A...
How to write DAX - • Learn Power Pivot & DA...
10 Power BI Tips for better visuals - • 10 Power BI tips to ma...
💥 Want more? TRY my Power BI Course - chandoo.org/wp/power-bi-course
~~~
Have a beautiful day 😃
#POWERBI #DATAANALYTICS