Data Analytics Internship Roadmap: What to Learn Before You Apply
By K. Boopathikumar, CEO & Founder · 16 November 2026 · 6 min read
Data analytics suits students from any branch who like solving problems with numbers. Plan about three to four months.
Stage 1: Excel (3 weeks)
- Formulas and lookups.
- Pivot tables and charts.
- Data cleaning.
- Build: a sales summary from a public dataset.
Stage 2: SQL (4 weeks)
- SELECT, WHERE and ORDER BY.
- Joins and GROUP BY.
- Subqueries and window functions.
- Build: answer 20 business questions on a sample database.
Stage 3: Statistics (2 weeks)
- Mean, median and spread.
- Distributions.
- Correlation and simple tests.
- Build: a short report on a dataset with clear caveats.
Stage 4: Power BI or Tableau (3 weeks)
- Data modelling.
- Measures.
- Dashboard design.
- Build: an interactive dashboard.
Stage 5: Python and portfolio (3 weeks)
- pandas basics.
- Charts.
- Case question practice.
- Build: three projects with a question, analysis and recommendation.
You are ready to apply when you can
- Write joins and GROUP BY quickly.
- Explain a dashboard's purpose.
- Talk through a case question.
- Show three analyses.
Next steps
- Study the free Data Analytics learning path and take its module quizzes for a free certificate.
- Follow the Data Analytics skill track from basic to advanced.
- Do real, reviewed work in a Data Analytics internship and keep every project in your own GitHub.