The best way to learn Power BI is by doing an end-to-end 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: [ Ссылка ]

Github link: [ Ссылка ]
Mirror link: [ Ссылка ]
Icons & Files: [ Ссылка ]

📂 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:

👉 [ Ссылка ]


⏱ 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) - [ Ссылка ]
Beginner to PRO lesson on Power BI (45 mins) - [ Ссылка ]
HR Dashboard with Power BI (30 mins) - [ Ссылка ]
Dashboard re-design in Power BI - [ Ссылка ]
Netflix EDA with Power BI - [ Ссылка ]
SQL + Power BI - [ Ссылка ]


📘 DAX:
How to use Calculated Groups in Power BI - [ Ссылка ]
Beginner to PRO class on DAX - [ Ссылка ]


📗 Power Query:
How to make a calendar table - [ Ссылка ]
Power Query in 15 mins - [ Ссылка ]
Power Query masterclass (90 mins) - [ Ссылка ]


📙 Power BI Concepts:
Dynamic Top 10 chart - [ Ссылка ]
When and how to use various Power BI charts - [ Ссылка ]
Power BI Free vs. Pro vs. Premium - [ Ссылка ]
How to create tooltips in Power BI - [ Ссылка ]
How to use Field Parameters in Power BI - [ Ссылка ]
Star Schema in Power BI (explanation) - [ Ссылка ]
How to use Small Multiples in Power BI - [ Ссылка ]
How to make a slicer panel - [ Ссылка ]
What-if analysis with Power BI - [ Ссылка ]

💥 Full course:
10 hours Power BI course - [ Ссылка ]

~

#powerbi #course

свернуть