Data Analyst Roadmap 2025 - Weekly
Study Plan (with Free Resources)
Week 1-2: SQL (Basics)
Goal: Learn SQL basics, including queries, data extraction, and data manipulation.
Topics Covered: SELECT, WHERE, GROUP BY, ORDER BY, joins.
YouTube Videos:
SQL for Beginners by FreeCodeCamp – https://www.youtube.com/watch?v=HXV3zeQKqGY
SQL Tutorial - Full Database Course for Beginners by Bro Code -
https://www.youtube.com/watch?v=5hzZtqCNQKk
Week 3: SQL (Advanced Queries)
Goal: Master advanced SQL concepts and work with complex datasets.
Topics Covered: Subqueries, nested queries, window functions.
YouTube Videos:
Advanced SQL Tutorial by Programming with Mosh -
https://www.youtube.com/watch?v=7S_tz1z_5bA&ab_channel=ProgrammingwithMosh
Week 4-5: Excel (Basics to Intermediate)
Goal: Understand Excel basics, formulas, data cleaning, and analysis.
Topics Covered: Basic functions, data validation, pivot tables, lookup functions, data
cleaning.
YouTube Videos:
Excel Beginner Tutorial by Lokesh Lalwani -
https://www.youtube.com/c/LearnwithLOKESHLALWANI
