Role Pack · Junior to Mid
Data Analyst Interview Pack
SQL, statistics, A/B testing, visualisation and the business-case questions.
Window functions, experiment design, and translating a business question into an analysis.
- Questions
- 360
- Topics
- 20
- Pages
- 286pages
- 360 questions, every one with a model answer
- SQL + stats cheat sheet
- A/B testing framework
- Case-study walkthroughs
Get the Data Analyst Interview Pack — $9
One-off. Delivered as a PDF by email the moment payment clears.
Prices shown are a USD base. Your local-market price is calculated at checkout in your own currency, plus any local sales tax.
What is inside
20 chapters, in the order the interviews tend to ask them:
- SQL fundamentals and the relational model
- Selection, filtering and projection
- Joins and relationship modelling
- Aggregation and GROUP BY
- Window functions and analytical queries
- Subqueries, CTEs and set operations
- Null semantics and data quality gates
- Data types, dates and time zones
- Query planning and indexes
- Schema design and constraints
- Transactions and concurrency
- Partitioning and large tables
- Star schemas and analytical modelling
- Incremental pipelines and idempotency
- Transformation tooling and dbt
- Testing data and pipeline observability
- Python for data analysis
- Statistical reasoning for analysts
- Experimentation and causal inference
- Communicating analysis and dashboards
How the answers are built
Each chapter opens with the checklist the question is really testing. A few from this pack:
- A relational table is a set of rows with named attributes, and SQL describes what you want rather than how to get it.
- WHERE filters rows before grouping and before projection, which is why you cannot select an aggregate there.
- An inner join returns intersection rows, a left join returns all left rows with nulls where unmatched.
- Grouping produces one row per distinct combination of the grouping expressions.
- A window function computes across a set of related rows without collapsing them, so detail is preserved.
- UNION removes duplicates, UNION ALL does not, and the choice can change result counts by orders of magnitude.
Questions this pack covers
- What does it mean that SQL is declarative rather than procedural?
- Why does SQL treat rows as a bag instead of a set?
- Why can a WHERE clause not reference an alias defined in the same SELECT list?
- What does three valued logic do to a negated predicate?
- Why does a many to many join multiply rows in both directions?
- What is the fan out trap, and how do you detect it?
- What happens when you aggregate a grouped query a second time?
- Why is COUNT(column) different from COUNT(*)?
Each one is answered in full in the pack, with the reasoning written out rather than a bullet list.
About this pack
- How many questions?
- 360, spread across 20 topics, written out in full across 286 pages.
- Do the answers just list keywords?
- No. Each answer is written as prose, because that is what you have to reproduce when someone asks you the question.
- How do I get it?
- Pay once and the PDF arrives by email immediately, with a signed download link.
- Can I get it refunded?
- Yes, if it is not what you expected. See the refund policy.
