The 5 Levels of Data Analytics

13 Jul 2026 · 1 min

Watch on YouTube

1:21

In this instructional video, the presenter outlines a five‑step roadmap for becoming a data analyst. Level 1 covers Excel fundamentals—pivot tables, VLOOKUP, conditional formatting, and basic formulas—as the foundation for analytical thinking, with a free Microsoft training series recommended. Level 2 moves to SQL basics, teaching how to query, filter, join, and aggregate data using Mode Analytics’ free tutorial. Level 3 focuses on data visualization, turning query results into understandable dashboards via Tableau Public’s free training. Level 4 introduces Python for data analysis, emphasizing automation and large‑scale data handling with the Pandas library. Level 5 stresses domain specialization, urging learners to pair technical skills with industry knowledge (e.g., healthcare, finance, marketing). The speaker cites a projected 23 % growth in analyst demand, argues that prior problem‑solving experience transfers directly, and dismisses the need for a computer‑science degree or additional master’s. The video concludes with a call to action: viewers who comment “data” will receive a free, detailed roadmap.

Chapters

There's exactly 5 levels of mastering data analytics. Most people skip level 1 and wonder why they never get hired. So level 1 is Excel fundamentals. Learn pivot tables, VLOOKUPs, conditional formatting, and basic formulas. This is where you build your analytical thinking. Microsoft offers a free Excel training series that covers everything that you need A to Z. All right, level 2 is SQL basics. You're learning how to query databases, filter data, join tables, and aggregate results. Mode Analytics has a free SQL tutorial that teaches you everything with real datasets. Level 3, data visualization. Now you're taking those query results and turning them into dashboards people actually understand. Tableau Public is completely free and includes built-in training videos. Level 4 is Python for data analysis. You're automating repetitive tasks and handling datasets too large for Excel, focusing primarily in the Pandas library. Level 5 is domain specialization. This is where you combine these technical skills with industry knowledge in healthcare, finance, marketing, or any industry. The demand of data analyst roles is projected to grow 23%, and your problem-solving skills from any previous jobs transfer directly into analytics work. So no, you don't need a computer science degree. You don't need another master's degree. You just need these 5 levels in order. I've taught thousands of career changers the exact way to do this, and if you're interested in learning how, comment data and I will send you my free roadmap.