hirecept

Data Analyst: Interview questions: SQL, statistics, Excel, BI and cases

Data analyst interviews usually test four things: statistics basics, hands-on SQL and Excel, a BI tool such as Power BI or Tableau, and a business case where you reason aloud. This kit works for any employer and covers fresher and early-career roles.

19 questions · 4 rounds · updated Nov 2026

How the interview works

  1. Screening: Resume, projects, tools and basic statistics.
  2. Technical round: SQL queries, Excel or Python tasks, data cleaning scenarios.
  3. Case and business round: Metric definition, diagnosing a drop, A/B testing, communicating a result.
  4. HR round: Motivation, communication, salary expectations.

Sample questions

  • 01

    You receive a customer dataset with missing values, duplicates and inconsistent city names. What steps do you take?

    MediumData cleaning

    Model answer

    What the interviewer checks

    A reproducible process and judgement about how to treat missing data.

    How to answer

    1. Profile first: row count, data types, nulls per column, distinct values, min and max. Notice problems such as an age of 240 or dates in 1900. 2. Duplicates: decide the business key (email or phone, normalised to lower case with spaces trimmed), remove exact duplicates, and review near-duplicates. 3. Standardise: trim and fix case, map variants to one value ("Bangalore", "Bengaluru", "BLR" → Bengaluru) with a mapping table, and parse dates into one format. 4. Missing values: first ask why they're missing. Drop rows only if few are affected and the gaps are random. Fill numeric gaps with the median or a group median, use "Unknown" for categories, and add a flag column so the analysis can see what was filled. 5. Outliers: check whether they are errors (fix or drop them) or real (keep them, maybe cap them for modelling). 6. Document every rule and do it in a script (SQL or Python), not by hand, so it can be rerun on next month's file.

  • 02

    Ice cream sales and drowning incidents are strongly correlated. What is the most likely explanation?

    MediumStatistics

  • 03

    List the highest-paid employee in each department, with the department name. Include ties.

    MediumWindow functions

    Approach and solution

    Approach

    Rank inside each department with a window function, then keep rank 1. RANK keeps ties; ROW_NUMBER would pick one arbitrarily.

    SELECT d.name AS department, e.name, e.salary
    FROM (
      SELECT e.*, RANK() OVER (PARTITION BY dept_id ORDER BY salary DESC) AS rnk
      FROM employees e
    ) e
    JOIN departments d ON d.id = e.dept_id
    WHERE e.rnk = 1;

    Complexity: One sort per partition.

16 more questions, members only

  • Analytics fundamentals5
  • SQL for analysts8
  • Tools: Excel, Python and BI3
  • Case and business questions3

Members also get how to answer each question and a preparation plan for this company.

See plans from ₹399

Every question and answer is written by Hirecept and the code is run before it is published. How a company runs its process comes from candidate reports and public pages, and companies change it, so treat that part as a guide, not a promise.