Data Analytics Internship Interview Questions for Freshers (with Answers)
By K. Boopathikumar, CEO & Founder · 16 November 2026 · 8 min read
A data analytics internship interview checks whether you can get the right numbers (SQL and Excel), trust them (cleaning and basic statistics) and explain them to someone who is not technical. Expect at least one SQL question and one 'what would you look at' case.
Excel and SQL
- VLOOKUP vs XLOOKUP vs INDEX-MATCH? All look up a value in a table. VLOOKUP only searches the first column to the right; INDEX-MATCH and XLOOKUP can look in any direction and do not break when columns are inserted.
- What is a pivot table used for? Summarising thousands of rows into totals, averages or counts by category, and changing the view by dragging fields.
- WHERE vs HAVING? WHERE filters rows before grouping; HAVING filters groups after GROUP BY, for example HAVING COUNT(*) > 5.
- INNER JOIN vs LEFT JOIN? INNER JOIN keeps only rows that match in both tables; LEFT JOIN keeps every row from the left table and fills missing matches with NULL.
- What is a window function? A calculation across related rows without collapsing them, such as ROW_NUMBER() or a running total with SUM() OVER (ORDER BY date).
Statistics and data quality
- Mean vs median: which do you report? The median when data is skewed or has outliers (such as incomes or delivery times); the mean when data is roughly symmetric.
- How do you handle missing values? First find out why they are missing. Then remove rows, fill with a sensible value (median, previous value) or flag them, and say which you did.
- What is an outlier and what do you do with one? A value far from the rest. Check whether it is an error or real; never delete it just because it is inconvenient.
- Correlation vs causation? Two things moving together does not mean one causes the other; a third factor may drive both. Experiments or careful comparisons are needed to claim cause.
Dashboards and communication
- What makes a good dashboard? It answers a few specific questions, puts the most important number first, uses consistent colours and lets the user filter without getting lost.
- Which chart for which job? Line for change over time, bar for comparing categories, scatter for relationships, and a table when people need exact values. Avoid pie charts with many slices.
- Sales dropped 20% last month. What do you check? Data errors first, then break the drop down by region, product, channel and customer type to find where it came from, and compare with seasonal patterns.
- How do you explain a finding to a manager? Lead with the answer and its impact in one sentence, show one clear chart, then the recommended action and any caveats.
How to answer well in the interview
- Practise SQL on real-looking data until joins and GROUP BY feel automatic.
- For case questions, think aloud: clarify the goal, list the data you need, then the steps.
- Show one dashboard you built, and be able to say who it is for and what decision it supports.
- Mention how you checked your numbers; accuracy is the first thing analysts are trusted for.
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.