Sign Up

Agent Ambo · Upskill

Data Analyst interview cheat sheet

The Data Analyst facts interviewers expect you to know cold. Ten minutes of revision the night before.

Start trainingSee how it works

Quick revision

SQL order of execution
FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT.
WHERE vs HAVING
WHERE filters rows; HAVING filters groups after aggregation.
Join types
INNER keeps matches; LEFT keeps all left rows; FULL keeps both.
RANK vs DENSE_RANK
RANK skips numbers after ties; DENSE_RANK does not.
Median over mean
Use the median for skewed data such as salaries.
Correlation ≠ causation
Two metrics moving together does not mean one causes the other.
p-value
Chance of a result at least this extreme if there were no real effect.
Pivot table
Summarise by rows and columns without formulas.
XLOOKUP
Looks up in any direction; replaces VLOOKUP's column-number limits.
Funnel conversion
Users at each step ÷ users at the previous step.

Must-know topics

SQL: joins, GROUP BY, window functions, CTEsExcel: pivot tables, XLOOKUP, conditional logicPower BI or Tableau dashboardsStatistics: mean vs median, distributions, A/B testingPython or R basics (pandas)Defining metrics and telling a story with data

Rehearse these out loud

  • Find the second-highest salary in each department.
  • What is the difference between WHERE and HAVING?
  • Sales dropped 20% last month. How would you investigate?

Go deeper

Answers to Data Analyst interview questionsData Analyst course with certificate

Revision is good. Practice is better.

  1. 1Ambo reads your resumeYour skills, projects, years and the role you want next.
  2. 2Then where you’re interviewingAnd how interviewers there question people like you.
  3. 3It maps every topic they could askMust-know first, your own projects included, built into short daily lessons.
  4. 4You practise, then get certifiedInterview Q&A after every lesson, then three proctored rounds ending in a voice interview with Ambo.

Questions, answered.

How should I use this Data Analyst cheat sheet?

Revise it the night before and the morning of your interview, then say each answer out loud. It covers SQL order of execution, WHERE vs HAVING and Join types and more.

Is a cheat sheet enough to clear the interview?

It helps you recall facts quickly, but interviewers test how you apply them and follow up on your answers. Practise answering, not just reading.

How is this different from a list of interview questions?

A list is the same for everyone. Ambo builds your course from your resume, your target role and where you're interviewing, then writes every lesson from the interviewer's point of view: what they'll ask, a strong answer, and the follow-up they'll use to test you.

What is the certification test?

Three camera-proctored rounds that unlock one after another: an objective round, a hands-on round (coding or practical tasks for your role) and a voice interview with Ambo, who asks live follow-ups on your answers. Pass all three within 14 days to become TickBig Certified for 12 months.

Keep exploring

Related cheat sheets

More

Revise it, then rehearse it.

Ambo interviews you on Data Analyst topics and follows up on what you say.

Start training