The best way to learn Power BI is by doing an endtoend portfolio project. In this video, we are going to do just that. Create a super awesome sales analytics dashboard and publish your work to GitHub. Right from data modelling to creating interactive dashboard, everything is clearly and neatly explained.
What you will learn:
===================
1) How to design a dashboard in Power BI?
2) Data modelling with Power BI and star schema development
3) Identifying measures and KPIs for sales analytics
4) Creating measures and setting up a dedicated measure table
5) Time intelligence calculations in Power BI MoM changes
6) Using the "new" card visual and reference labels
7) Fixing problems with DAX measures
8) Using Field parameters to create a dynamic trend chart
9) "Group" feature of Power BI to make histograms
10) Working with ZOOM SLIDER
11) Gauge chart to see Profit and LBS %
12) Table design in Power BI
13) Conditional formatting for tables
14) Bookmarks
15) Fixing problems with bookmarks data / filter preservation
16) Setting up tooltips for country breakdown
17) Slicer panel set up in Power BI
18) Publishing the dashboard to Power BI service
19) Setting Github portfolio page
DEMO +Sample data file:
========================
Live Demo: https://app.powerbi.com/view?r=eyJrIj...
Github link: https://github.com/chandooorg/Power...
Mirror link: https://chandoo.org/wp/wpcontent/upl...
Completed Power BI file + Video download
======================================
You can get the complete Power BI file, full HD video and more than 10 hours of Power BI lessons in my online Power BI course. Sign up here:
https://chandoo.org/wp/powerbicourse/'>https://chandoo.org/wp/powerbicourse/
⏱ Video Timestamps:
===================
0:00 Introduction and what to expect
1:00 Set up of our data and business situation
2:14 Awesome Chocolates Data Model
3:00 Data load to Power BI
5:43 Star Schema creation in Power BI
6:40 Defining the DAX measures
17:43 Using the Calendar table to make "time intelligence" measures
27:22 Wireframe design for our dashboard
31:55 Dashboard page design and theme in Power BI
33:42 KPI cards for the Power BI sales analytics dashboard
36:25 Fixing the MoM calculation DAX
41:52 Adding reference labels for the KPI cards
44:26 Formatting the KPI section
48:56 Profit % Gauge Chart
52:05 Dynamic Trend Analysis Chart (with Field Parameters)
59:11 Shipment Analysis (histogram + zoom slider)
1:05:45 Sales Person Performance Table design
1:23:30 Product Performance Table
1:25:35 Bookmark for Product vs. People view
1:34:27 Filter panel design
1:39:28 Tooltip design
1:44:16 Final version (with two options!)
1:47:36 Creating a portfolio on Github to share your project
1:53:58 Congratulations on completing the Power BI project
~
MORE POWER BI ⚡
===================
Dashboards:
Finance Dashboard in Power BI (20 mins) • Make an Incredible Finance KPI Dashbo...
Beginner to PRO lesson on Power BI (45 mins) • Beginner to PRO Data Analysis with Po...
HR Dashboard with Power BI (30 mins) • HR Data Analytics & Awesome Dashboard...
Dashboard redesign in Power BI • Power BI Dashboard Makeover 5 Ideas
Netflix EDA with Power BI • End to End Data Analysis Project with...
SQL + Power BI https://youtube.com/live/UQJAHUUFKo?...
DAX:
How to use Calculated Groups in Power BI • How to set up and use Calculation Gro...
Beginner to PRO class on DAX • Learn Power Pivot & DAX for Power BI ...
Power Query:
How to make a calendar table • How to make the "perfect" CALENDAR TA...
Power Query in 15 mins • Learn Power Query & Automate Boring D...
Power Query masterclass (90 mins) • Power Query Tutorial What is it, ho...
Power BI Concepts:
Dynamic Top 10 chart • How to make an interactive TOP 10 Cha...
When and how to use various Power BI charts • How to pick the "perfect" chart for y...
Power BI Free vs. Pro vs. Premium • Power BI: Free vs. Pro vs. Premium ...
How to create tooltips in Power BI • How to create Tooltip Pages in Power ...
How to use Field Parameters in Power BI • Power BI Field Parameters Why & how...
Star Schema in Power BI (explanation) • How to setup a Star Schema Data Model...
How to use Small Multiples in Power BI • How Jo uses Small Multiples to impres...
How to make a slicer panel • How to make a Show / Hide SLICER PANE...
Whatif analysis with Power BI https://youtube.com/live/jjT_yor0NuA?...
Full course:
10 hours Power BI course https://chandoo.org/wp/powerbicourse/'>https://chandoo.org/wp/powerbicourse/
~
#powerbi #course