Roles guide
Six professions, explained without jargon: what they do on a normal day, which tools they work with and what you can practice here to get closer to each one.
Quick quiz · 3 questions
What appeals to you most?
Question 1 of 3
Turns business questions into queries and answers into decisions.
🦉 Practice explaining every result in one sentence: the “so what?” is as important as the query.
Builds the reports and dashboards the team looks at every week.
🦉 Learn to design a good dashboard: few numbers, well chosen, with context.
Organizes data into clean, reliable tables so others can analyze it.
🦉 Master JOINs and CTEs (WITH): they are the bread and butter of this role.
Builds the pipelines that move data from one system to another.
🦉 After SQL, learn Python: it's the second essential tool of the role.
Uses statistics and models to predict, classify and experiment.
🦉 Basic statistics (means, spread, correlation) will give you an edge from the start.
Lives in the spreadsheet: budgets, forecasts and cost control.
🦉 Combine Excel with some SQL: pulling the data yourself will make you much faster.