HomeData ScienceAI Studio

SQL Analytics Case Study

2026-09-01Planned

A business-question-driven SQL project — schema exploration, progressively complex queries, and a summary of what the data says.

sql analytics window functions

Planned — write-up coming

This write-up will be completed as the project is finished. The sections below show the problem and intended approach; results only get added once they’re real.

Problem

SQL screens are where a lot of data science interviews are actually won or lost, and the skill they test isn't syntax — it's translating a vague business question into precise queries against an imperfect schema. This project works through a realistic database the way an analyst would, with every query readable, commented, and tied to the question it answers. [PLACEHOLDER: name the schema/dataset once chosen.]

Approach

Start by understanding the tables and their grain, then answer progressively harder business questions — from simple aggregations up to window functions and cohort-style queries. The write-up pairs each query with the business question and what the answer actually implies.

Intended workflow: understand the schema, frame the business question as precise SQL, sanity-check every result — each answer raising the next question — then summarize what the data actually says.
intended workflow

Result

Results will be published when the project is complete. No metrics appear here until they’re real.

demo video

a short recorded walkthrough goes here once the project is complete

What I'd do differently

Filled in honestly once the project is done — including what didn’t work and what I’d change with hindsight.

repo and notebook links will be added when the project is published