Sign in Start free

Interview roadmap · free

Data Analyst interview roadmap

The 7 skills Data Analyst interviews test, in the order to prepare them: the 3 core skills first, then the supporting ones, then the HR round every job has. Each skill climbs three steps, from explaining the basics to handling a real situation.

  • 7 job skills
  • 3 core
  • 44 topics to know
  • 3 steps each
  • Fresher to 6 years
Take the free mock interview Check yourself

First interview free: 3 questions, about 10 minutes · No card needed

Check yourself as you read. Tap each topic you could explain in an interview today. It stays on this device, and it's only your own guess: a mock interview shows where you really stand.

  1. Stage 1: Core skills

    Asked in almost every interview for this job. Start here.

    1. SQL

      Queries and joins

      1. Fundamentals
      2. Applied
      3. Scenario

    2. Python for analysis

      pandas

      1. Fundamentals
      2. Applied
      3. Scenario

    3. Analytical thinking

      Metrics and KPIs

      1. Fundamentals
      2. Applied
      3. Scenario

  2. Stage 2: Supporting skills

    Asked often. They set strong candidates apart.

    1. Excel

      Pivots and charts

      1. Fundamentals
      2. Applied
      3. Scenario

    2. Python for analysis

      Data cleaning

      1. Fundamentals
      2. Applied
      3. Scenario

    3. Statistics

      Descriptive statistics

      1. Fundamentals
      2. Applied
      3. Scenario

    4. BI and visualisation

      Power BI / Tableau

      1. Fundamentals
      2. Applied
      3. Scenario

  3. Stage 3: HR and behavioral round

    Every job has this round. Communication is scored in every answer.

    1. Behavioral

      Ownership and impact

      1. Fundamentals
      2. Applied
      3. Scenario

    2. Behavioral

      Teamwork and conflict

      1. Fundamentals
      2. Applied
      3. Scenario

    3. Behavioral

      Learning and growth

      1. Fundamentals
      2. Applied
      3. Scenario

  4. Interview-ready

    The core skills answered strongly on applied questions, at least half of the job's skills assessed and none of the key ones weak. Then your readiness reads Interview-ready.

Free interview roadmaps and mock interviews: https://myskillgrid.com/roadmaps/data-analyst/

The three steps

How each skill is tested

Questions get harder as you get better at a skill. A step counts once you answer a question at that level well, in an interview or a practice session. Nobody ticks a step off: you show it.

  1. 1

    Fundamentals

    Explain the basics and the key terms in your own words.

  2. 2

    Applied

    Use it on a real task, the way the job does.

  3. 3

    Scenario

    Decide in a realistic situation and explain the trade-offs.

Freshers start at the fundamentals. With 1 to 6 years of experience, questions start at the applied step.

FAQ

Data Analyst interviews, answered

Something else? Send us a message.

What does a Data Analyst interview cover?

7 of the job's own skills: the core ones, Queries and joins, pandas and Metrics and KPIs, then Pivots and charts, Data cleaning, Descriptive statistics and Power BI / Tableau. Every interview also has the HR and behavioral round (Ownership and impact, Teamwork and conflict and Learning and growth).

Which skills should I prepare first for a Data Analyst interview?

Start with the core skills: Queries and joins, pandas and Metrics and KPIs. They come up in almost every Data Analyst interview. Then move on to Pivots and charts, Data cleaning, Descriptive statistics and Power BI / Tableau.

What kind of questions are asked in a Data Analyst interview?

The interview types are Mixed, Technical, Analytics case and Behavioral. Each skill is asked at three levels: Fundamentals (explain the basics and the key terms in your own words), Applied (use it on a real task, the way the job does), Scenario (decide in a realistic situation and explain the trade-offs).

Is this Data Analyst roadmap for freshers?

Yes. Freshers start at the fundamentals. With 1 to 6 years of experience, questions start at the applied step.

How do I know I'm ready for a Data Analyst interview?

When the core skills are answered strongly on applied questions, at least half of the job's skills are assessed and none of the key ones is weak. A mock interview measures this for you, skill by skill.

Is it free?

Reading the roadmap is free. Tracking your progress on it needs a free account, and your first mock interview (3 questions) is free, with no card needed.

See where you really stand

Your first Data Analyst interview is free: 3 questions, a score and feedback for each, and your first steps on this roadmap, in about 10 minutes.

Start free interview