Data Analytics Roadmap - Rohit
Step 1: Excel Master Karna (1-2 weeks)
- Basic Formulas: SUM, AVERAGE, IF, VLOOKUP, etc.
- Filters, Pivot Tables, Charts
- Practice Resources:
- [Link]
- [Link]
Step 2: Python for Data Analysis (2-3 weeks)
- Python Basics: variables, loops, functions
- Libraries: Pandas, NumPy (data handling), Matplotlib, Seaborn (visualization)
- Free Resources:
- [Link]
- YouTube: CodeWithHarry, Krish Naik
Step 3: SQL Seekhna
- Learn Basic Queries: SELECT, WHERE, JOIN, GROUP BY
- Practice Sites:
- [Link]
- [Link]
Step 4: Power BI or Tableau
- Visualization Tools (Power BI is FREE and widely used)
- Learn to create dashboards and basic projects
- YouTube Channels: Simplilearn, Great Learning, Codebasics
Step 5: Resume + Projects + Internships
Data Analytics Roadmap - Rohit
- Resume tailored for Data Analytics
- Project Ideas:
- Sales Analysis (Excel + Python)
- COVID Data Visualization (Power BI)
- Apply for internships:
- Internshala, LinkedIn, LetsIntern, Naukri
Daily Routine Suggestion
Time | Task
--------|---------------------------
30 min | Excel Practice
45 min | Python video + practice
30 min | SQL
Weekend | Power BI + Projects