|
|
|
graph TD
A[📊 Phase 1: Foundation & Excel<br/>4-6 weeks] --> B[🐍 Phase 2: Programming & SQL<br/>6-8 weeks]
B --> C[📊 Phase 3: Visualization & BI<br/>4-6 weeks]
C --> D[🚀 Phase 4: Advanced Analytics<br/>4-6 weeks]
A1[📈 Statistics & Math] --> A
A2[📊 Excel Mastery] --> A
A3[📋 Data Fundamentals] --> A
B1[🐍 Python Basics] --> B
B2[🗄️ SQL Mastery] --> B
B3[🧹 Data Wrangling] --> B
C1[📊 Tableau] --> C
C2[💼 Power BI] --> C
C3[📖 Data Storytelling] --> C
D1[📊 Statistical Analysis] --> D
D2[🤖 Machine Learning] --> D
D3[💼 Career Prep] --> D
style A fill:#4CAF50,stroke:#2E7D32,color:#fff
style B fill:#2196F3,stroke:#1565C0,color:#fff
style C fill:#FF9800,stroke:#E65100,color:#fff
style D fill:#9C27B0,stroke:#6A1B9A,color:#fff
📊 Week 1-2: Mathematics & Statistics
|
📈 Descriptive Statistics
|
🎲 Probability Theory
|
🎯 Project: Analyzing Student Grades Dataset
📊 Week 3-4: Excel Mastery
|
📋 Basic Excel Functions
|
⚡ Advanced Excel
|
🎯 Project: Sales Analysis Dashboard in Excel
📋 Week 5-6: Data Fundamentals
- 📊 Data Types and Structures
- 🔍 Data Quality Assessment
- 🧹 Basic Data Cleaning Techniques
- 🗄️ Introduction to Databases
🎯 Project: Data Quality Assessment Report
🐍 Week 7-9: Python Fundamentals
|
🎯 Python Basics
|
📊 Data Analysis Libraries
|
🎯 Project: COVID-19 Data Analysis with Python
🗄️ Week 10-12: SQL Mastery
|
📊 SQL Fundamentals
|
⚡ Advanced SQL
|
🎯 Project: E-commerce Database Analysis
🧹 Week 13-14: Data Wrangling
- 🧹 Data Cleaning with Python
- 🕳️ Handling Missing Data
- 🔄 Data Transformation Techniques
- 🕷️ Web Scraping Basics
🎯 Project: Real Estate Data Cleaning Project
📊 Week 15-16: Tableau Mastery
|
📈 Tableau Fundamentals
|
⚡ Advanced Tableau
|
🎯 Project: Superstore Sales Dashboard
💼 Week 17-18: Power BI
|
⚡ Power BI Fundamentals
|
🚀 Power BI Advanced
|
🎯 Project: HR Analytics Dashboard
📖 Week 19-20: Data Storytelling
- 🎨 Visualization Best Practices
- 🌈 Color Theory and Design Principles
- 💼 Presenting to Stakeholders
- 📋 Creating Executive Summaries
🎯 Project: Business Performance Story
📊 Week 21-22: Statistical Analysis
|
🧪 Hypothesis Testing
|
🔬 A/B Testing
|
🎯 Project: Website A/B Test Analysis
🤖 Week 23-24: Machine Learning Basics
|
🧠 ML Introduction
|
⚙️ Common Algorithms
|
🎯 Project: Customer Segmentation with ML
💼 Week 25-26: Career Preparation
- 📁 Building Your Portfolio
- 📄 Resume Optimization
- 🎤 Interview Preparation
- 🤝 Networking Strategies
🎯 Final Project: End-to-End Business Analytics Project
| 🛠️ Tool | 📝 Purpose | 💰 Cost | 🔗 Download |
|---|---|---|---|
 Microsoft Excel |
Data analysis & visualization | Free (online) / Paid | Excel Online |
 Python (Anaconda) |
Programming & data analysis | Free | Anaconda |
 Tableau Public |
Data visualization | Free | Tableau Public |
 Power BI Desktop |
Business intelligence | Free | Power BI |
 MySQL |
Database management | Free | MySQL |
 Jupyter Notebook |
Interactive coding | Free | Included with Anaconda |
 VS Code Free code editor |
 Git Version control |
 Google Colab Cloud Jupyter |
|
1. 📊 Student Performance Analysis
|
|
6. 🏠 Real Estate Data Cleaning
|
7. 📊 Superstore Tableau Dashboard
|
|
9. 📖 Business Performance Story
10. 🧪 A/B Testing Analysis
|
11. 🎯 Customer Segmentation ML
12. 🚀 Capstone: End-to-End Analytics
|
| 🏫 Platform | 📚 Course | ⏰ Duration | 🏆 Certificate |
|---|---|---|---|
| Coursera | IBM Data Science Professional | 6-8 months | Free audit |
| edX | MIT Data Science | 6 weeks | Free audit |
| Kaggle Learn | Data Science Micro-Courses | Self-paced | Free |
| freeCodeCamp | Data Analysis with Python | 300 hours | Free |
 StatQuest Statistics explained simply |
 3Blue1Brown Math & statistics concepts |
 Corey Schafer Python tutorials |
 Ken Jee Data science career |
 Alex The Analyst Data analyst tutorials |
 Kaggle Datasets Real-world datasets |
 UCI ML Repository Classic ML datasets |
Google Dataset Search Find datasets across web |
 Government Data US government datasets |
|
Google Data Analytics 📅 3-6 months | 💰 Free audit 📊 Excel, SQL, R, Tableau |
 IBM Data Science 📅 6-10 months | 💰 Free audit 🐍 Python, SQL, ML |
 Azure Data Fundamentals 📅 2-3 months | 💰 $99 exam ☁️ Azure, Data concepts |
|
Kaggle Learn Python, SQL, ML |
Microsoft Learn Power BI, Excel, Azure |
Google Analytics Google Analytics |
 HubSpot Marketing analytics |
| 📊 Level | ⏰ Experience | 💵 Salary Range | 🛠️ Skills Required |
|---|---|---|---|
| 🌱 Entry Level | 0-2 years | $45,000 - $65,000 | Excel, SQL, Basic visualization |
| 📈 Mid Level | 2-5 years | $65,000 - $85,000 | Python/R, Advanced SQL, Tableau/Power BI |
| 🚀 Senior Level | 5+ years | $85,000 - $120,000 | Machine Learning, Leadership, Domain expertise |
| 👑 Lead/Manager | 7+ years | $100,000 - $150,000+ | Strategy, Team management, Business acumen |
|
Data Analyst |
Business Analyst |
Marketing Analyst |
 BI Analyst |
| 📅 Month | 🎯 Focus Area | 📋 Weekly Breakdown |
|---|---|---|
| Month 1 🏗️ Foundation |
📊 Excel & Stats |
Week 1: Statistics + Excel basics Week 2: Probability + Advanced Excel Week 3: Data concepts + Projects Week 4: Review + Portfolio project |
| Month 2 🐍 Programming |
Python Basics |
Week 5: Python fundamentals Week 6: NumPy + Pandas Week 7: Matplotlib visualization Week 8: Python project + SQL intro |
| Month 3 🗄️ Databases |
SQL & Wrangling |
Week 9: SQL fundamentals Week 10: Advanced SQL + Joins Week 11: Data cleaning with Python Week 12: SQL + Wrangling projects |
| Month 4 📊 Visualization |
Tableau & Power BI |
Week 13: Tableau fundamentals Week 14: Advanced Tableau + Dashboard Week 15: Power BI fundamentals Week 16: Power BI + Storytelling |
| Month 5 🧪 Analytics |
Stats & ML |
Week 17: Statistical testing + A/B Week 18: Machine learning basics Week 19: ML project + Analytics Week 20: Business case studies |
| Month 6 💼 Career |
Portfolio & Jobs |
Week 21: Portfolio development Week 22: Capstone project Week 23: Resume + Interview prep Week 24: Job applications + Networking |
|
📊 Month 1-3: Foundation
|
🚀 Month 4-6: Advanced
|
📊 Excel Skills Assessment
- ✅ Can create pivot tables and charts
- ✅ Comfortable with VLOOKUP and INDEX-MATCH
- ✅ Can clean and organize data effectively
- ✅ Understand statistical functions
- ✅ Can build interactive dashboards
🐍 Python Skills Assessment
- ✅ Can manipulate data with Pandas
- ✅ Create visualizations with Matplotlib/Seaborn
- ✅ Handle data cleaning and preprocessing
- ✅ Work with NumPy arrays
- ✅ Import and export different file formats
🗄️ SQL Skills Assessment
- ✅ Write complex SELECT statements
- ✅ Use JOINs to combine tables
- ✅ Apply window functions for analysis
- ✅ Create subqueries and CTEs
- ✅ Optimize query performance
📊 Visualization Skills Assessment
- ✅ Create interactive Tableau dashboards
- ✅ Build Power BI reports with DAX
- ✅ Tell compelling stories with data
- ✅ Apply design principles effectively
- ✅ Present insights to stakeholders
 Discord Server Connect with learners |
 Reddit Community Ask questions & share |
 LinkedIn Group Professional networking |
 Slack Workspace Real-time discussions |
|
FAQ Section Common Q&A |
Troubleshooting Technical issues |
Office Hours Weekly Q&A |
Mentorship Get paired with experts |
|
🏥 Specialization Tracks:
|
🚀 Advanced Career Paths:
|
|
Data Science ML, AI, Deep Learning |
Data Engineering ETL, Pipelines, Cloud |
Business Intelligence Enterprise BI, Architecture |
Analytics Consulting Strategy, Transformation |
Cybersecurity Student & AI Research Enthusiast
|
|
|
🎓 Background: Cybersecurity Student & AI Research Enthusiast
💼 Mission: Making data analytics education accessible to everyone
📍 Location: Based in India, Supporting learners globally
🌟 Goal: Empowering 10,000+ students to start their data analytics journey
If this roadmap helps you in your data analytics journey:
|
⭐ Star this repo |
🍴 Fork it |
📢 Share it |
💬 Join community |
 📝 Contribute |
📄 License: This project is licensed under the MIT License - see the LICENSE file for details.
@mrankitgupta for inspiration • Open-source community for tools • Educators & creators for content • Community members for feedback
|
|
|
Made with ❤️ by Devesh Punjabi
Last Updated: August 2025