SQL for Data Analysis: Work as an Analyst
Join freeFree first lesson · Zafari Academy
- Free
- About 24 hours
- 117 lessons
Step 1 of 7
Your first request
Step 1 · Read · 3 minStep 1 · 3 min
Welcome to Quillon
Your first day
Lena Okafor founded Quillon Home, an online shop for homeware and desk gear. In 2025 it took 281 orders, but little money was left each month. She has hired you as her first data analyst.
She writes: "I see lots of orders and not much money. Where does it go? I need answers I can trust, in plain words."
Who will ask you questions
- Lena Okafor, founder and CEO: the big questions.
- Tomás Reyes, marketing lead: campaigns and ads.
- Priya Nair, finance: costs, margins and refunds.
- Sam, customer service: returns and complaints.
Three case files
- Case file A: Quillon Home. Where does the money go?
- Case file B: Kestova, a subscription fitness app. Mei Tan, head of product, and Jonah in finance ask who stays, and whether a change worked.
- Case file C: Marrowby City Services, a city's service desk. Ade Bello, the operations manager, and a councillor ask if the city keeps its promise on response times.
What you will build
Each case file ends in a portfolio project: checked SQL, a chart and a one-page memo. Then come interview drills and a timed skills test on new data.
How the work goes
Every request follows four steps:
- Question: what exactly is being asked?
- Query: write the SQL.
- Check: does the result make sense?
- Say: give the answer in one sentence.
Each part has a brief, a worked query, a lab with hints, cards and an assessment you can retry.
Carry on with SQL for Data Analysis: Work as an Analyst
Your progress and certificate are kept.