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: https://app.powerbi.com/view?r=eyJrIjoiNWJiNDQ4YTQtNWIxNi00NmE5LTk1MWEtNmNkZGUyM2U4ZmEwIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9
Github link: https://github.com/chandoo-org/Power-BI/blob/main/ac-sample-data.xlsx
Mirror link: https://chandoo.org/wp/wp-content/uploads/2024/07/ac-sample-data.xlsx
Icons & Files: https://github.com/chandoo-org/Power-BI/
? 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/power-bi-course/
⏱ 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) - https://youtu.be/i3AR0gt9SHA
Beginner to PRO lesson on Power BI (45 mins) - https://youtu.be/uwe8C7K8fXY
HR Dashboard with Power BI (30 mins) - https://youtu.be/5KaIU-9EF-0
Dashboard re-design in Power BI - https://youtu.be/XadqG2SrVSc
Netflix EDA with Power BI - https://youtu.be/iGUqad1eNtQ
SQL + Power BI - https://youtube.com/live/UQJAHUUFK-o?feature=share
? DAX:
How to use Calculated Groups in Power BI - https://youtu.be/WnLtC3udzSQ
Beginner to PRO class on DAX - https://youtu.be/PQ5lALdFHCU
? Power Query:
How to make a calendar table - https://youtu.be/wN1ok8JDzrI
Power Query in 15 mins - https://youtu.be/UAFExySaSPY
Power Query masterclass (90 mins) - https://youtu.be/PiFAa_jjaEI
? Power BI Concepts:
Dynamic Top 10 chart - https://youtu.be/uQV5MP_THfA
When and how to use various Power BI charts - https://youtu.be/5jrsrSDEMxE
Power BI Free vs. Pro vs. Premium - https://youtu.be/6tTJkA3Cv_w
How to create tooltips in Power BI - https://youtu.be/npaQ42K1sTs
How to use Field Parameters in Power BI - https://youtu.be/IR62y8Q_k-o
Star Schema in Power BI (explanation) - https://youtu.be/1CgG0t59WcM
How to use Small Multiples in Power BI - https://youtu.be/Jzu2wfyYF9I
How to make a slicer panel - https://youtu.be/luVczt-NQ6M
What-if analysis with Power BI - https://youtube.com/live/jjT_yor0NuA?feature=share
? Full course:
10 hours Power BI course - https://chandoo.org/wp/power-bi-course/
~
#powerbi #course