Free, no signup · printable
Cheat sheets, interview questions and a glossary that sit next to the levels. Every snippet runs on the same Harbor & Pine data you play with, and every topic links to the level that teaches it.
Grouped by the task in front of you (filter rows, group and count, join two tables, dates) rather than by keyword. Each prints on two or three A4 pages.
12 tasks · 47 snippets
Every query runs on DuckDB against the store tables.
Look at a table, pick columns · Filter rows · Handle missing values (NULL) · Sort, top N, pages · Group and count · Conditions · Join two tables · Dates · Clean text, find duplicates · Subqueries and CTEs · Window functions · Common business metrics
Open the SQL sheet12 tasks · 49 snippets
Every snippet runs on pandas 2.3 against the store tables.
First look at a table · Select columns and rows · Filter rows · Sort and top N · New columns · Group and count · Join two tables (merge) · Handle missing values (NaN) · Clean text, find duplicates · Dates · Rank, running totals, change · Common business metrics
Open the pandas sheet8 tasks · 38 formulas
Every formula checked in our spreadsheet engine against the store tables.
Formulas, references, fill down · Summarise a range · Decisions · Group and count · Join two tables · Clean and split text · Dates · Missing values, errors, duplicates
Open the Excel sheet30 or 45 minutes · scored by topic
A timed session that mixes live SQL, pandas and Excel tasks with quiz and spoken questions, then scores you by topic.
Start a mock interview64 questions · SQL, pandas, Excel, Power BI, statistics, case
Questions from real analyst interviews, each with a model answer, the answer that loses points and a level to practise it.
Practise the questions161 terms, A to Z
The words analysts, managers and interviewers use, from SQL and pandas to Excel, Power BI and statistics, each in one plain sentence.
Browse the glossary4 guides · public datasets
Four projects on public data, each with a business question, steps linked to levels, and what to put on GitHub, LinkedIn and your CV.
See the projectsExcel, Power BI, SQL, pandas, statistics
Start a level and try the ticket on your own. Stuck on syntax? The cheat sheet shows the pattern; the level's hints cover the thinking. Pick any track: SQL, Python or Excel.
Print the sheet for the track you are on, or keep it in a second tab. Each task group links back to the levels that teach it, so a pattern you only half know is one click from practice.
Answer each interview question out loud before opening it, then replay the linked level. Use the glossary for any term you could not define in one sentence.
