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
![](https://s2.save4k.ru/pic/ooJO7NW4uJU/maxresdefault.jpg)