How to build Excel Dashboards based on non-financial data.
🔻 DOWNLOAD the completed dashboard and supporting data here: https://www.myonlinetraininghub.com/non-financial-excel-dashboards
🎓 LEARN MORE: Take my comprehensive Excel Dashboard course: https://www.myonlinetraininghub.com/excel-dashboard-course
Dashboard Video Playlist:
https://www.youtube.com/watch?v=K74_FNnlIF8&list=PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s
Cross Filter and Highlight in Excel like in Power BI:
https://www.youtube.com/watch?v=qFpnUBNUcsM
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
0:00 Introduction
1:24 Overview of Dashboard
2:59 Get Data with Power Query
10:00 Model Data with Power Pivot
12:44 Headline Figures & Icons
26:32 Crew Count - Bar Chart
34:31 Map Chart
37:07 Flights by Vehicle Class - Column Chart
38:50 Crewed Missions - Column Chart
43:02 People in Space - Column Chart
48:36 Human Days in Space - Stacked Area Chart
51:32 Slicer Connections
52:12 File Download Link