Maven Analytics on YouTube · Open on YouTube
Foundations: spreadsheets, data literacy and first SQL · Novice · Lesson 15 of 99 · 35 min video, then about 7 hours of practice
Guided build: an interactive spreadsheet dashboard
After this you have followed a complete small analysis from raw data to an interactive spreadsheet dashboard.
Why it matters
Follow one project video end to end, but on your own copy of the data, pausing to predict each step before you see it. Then change one thing the tutorial did not do, such as adding a new filter or a different breakdown, to prove to yourself you understand the mechanics. This is your GUIDED_BUILD evidence; it shows you can follow a process, not that you can design one, and you should not present it as a portfolio project.
How to use this resource
A full analyst portfolio-style Excel dashboard build with downloadable files and solutions.