How to Become a Data Analyst in 2026
This roadmap is designed for Indian students with zero tech background. We have focused on affordable or free resources.
Step 1: Learn Excel (Weeks 1-4)
- Google Sheets basics (free)
- Excel functions: VLOOKUP, Pivot Tables, Charts
- Resource: Chandoo.org
Step 2: Learn SQL (Weeks 5-8)
- Free resource: Kaggle SQL
- Practice: LeetCode easy problems
Step 3: Learn Python Basics (Weeks 9-14)
- Free: Python.org tutorial
- Pandas & NumPy libraries
- Resource: W3Schools
Step 4: Data Visualization (Weeks 15-18)
- Tableau Public (free)
- Power BI (free for students)
Step 5: Build Portfolio (Weeks 19-24)
- Complete 3-5 real projects
- Upload to GitHub
- Create case study blog posts
Expected Timeline
6 months for complete beginners. Budget: Rs. 0 – 500/month