Training Trains logo

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

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides