Roadmap to Become a Data Analyst (April 2025 - September 2025)
Month 1: Python + Excel (April 29 - May 26)
• Weeks 1-2: Python basics (syntax, loops, functions); Excel formulas (SUM, IF, VLOOKUP)
• Weeks 3-4: Pandas basics & advanced (DataFrame, groupby); Excel Pivot Tables & Charts
• Mini Project: Sales Report Analysis (Excel) & CSV cleaning in Python
Month 2: SQL + Data Analysis (May 27 - June 23)
• Weeks 5-6: SQL SELECT, WHERE, GROUP BY; Python EDA & data cleaning
• Weeks 7-8: SQL JOINS; Python data visualization (bar, scatter)
• Mini Project: Mock DB queries & Python data cleaning project
Month 3: Stats + Critical Thinking (June 24 - July 21)
• Weeks 9-10: Descriptive Stats (mean, sd), Probability basics; Critical Thinking exercises
• Weeks 11-12: Hypothesis Testing (t-test, z-test); Data reasoning puzzles
• Mini Project: Statistical report on Kaggle dataset
Month 4: Data Visualization Tools (July 22 - August 18)
• Weeks 13-14: Matplotlib & Seaborn basics; Tableau Dashboards
• Weeks 15-16: Practice visualizing diverse datasets
• Mini Project: Dashboard on real-world data
Month 5: Machine Learning Basics (August 19 - September 15)
• Weeks 17-18: Supervised vs Unsupervised, Linear Regression, Decision Trees
• Weeks 19-20: Model evaluation metrics & final ML mini project
• Final Project: Build and visualize a simple ML model