This course includes sample data files and a step-by step walkthrough for how to make this dashboard in Power BI. We will make the model together, then create each visual using core Power BI visuals. Happy dashboarding!
🎓 COURSE
- DATA FILES Github Link: https://github.com/chpayton/BI-Files/blob/main/Data%20Files.zip
- Get the full course here (this link provides a 50% discount through 7/25!): https://www.udemy.com/course/design-for-microsoft-power-bi/?couponCode=LAUNCH14
🛠️ RESOURCES
- How to use Date Tables in Power BI:
https://youtu.be/iOl5epoYQMY
- SQLBI - Handling Header vs Detail in Star Schemas: https://www.sqlbi.com/articles/header-detail-vs-star-schema-models-in-tabular-and-power-bi/
- Use TMDL to auto-create measure descriptions:
https://youtu.be/7vIwgSE8qmQ
- Styling KPI Cards:
https://youtu.be/m4fBo2-f1Dc
🍀 CHAPTERS
0:00:00 - Intro
00:29:29 - Download data files
00:45:03 - Connect to data with Power Query
07:54:17 - Report development process
08:11:00 - Model the data
14:54:13 - Custom sorting
18:10:16 - Visuals
19:04:11 - Heatmap visual
22:40:05 - Concatenating in Power Query
24:21:00 - Field parameters
25:26:18 - Bar chart with highlighted top bar
25:53:28 - Button slicer
31:04:00 - Alternate Top N DAX
32:50:15 - KPI card
44:10:05 - IBCS-style bar chart
50:07:00 - Wrap-up
CONNECT WITH ME
📩 Get new videos via email! - https://bi-ome.kit.com/youtube
📝 Blog - https://christine-payton.com/
🔗 LinkedIn - https://www.linkedin.com/in/christinehpayton/
💬 Questions? Drop them in the comments! Your question could help others too.
#dashboard #powerbi #sales #dataanalysis #datavisualization