Projects that move between tools
One company brief, worked through each tool in turn. Your own tables carry from one stage to the next, and you finish with a written readout. Every brief is free to read.
HearthlineProjectFree
Why is profit falling when sales are up?
Your first week as Hearthline's data analyst. Turn a messy order export into gross profit in Excel, roll it up in SQL, measure what each discount code costs in pandas, chart the margin in Power BI and tell your manager what to change.
Greenbasket MarketProject
Did the summer promotions pay?
Marketing ran eight promotions this summer and wants to plan the fall. Turn the offers into numbers, measure each one against the weeks before it, total the extra sales and write the memo.
Greenbasket MarketProject
The empty-shelf problem
Store managers say shelves keep running empty, but the shelf checks are messy. Mark every check, compare the stores fairly and show availability next to how much was checked.
Greenbasket MarketCase study
Why did September revenue drop?
The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.
Greenbasket MarketJourney
Your first 90 days as a data analyst
You've joined Greenbasket's two-person analytics team. Review the summer promotions, find the stores running out of stock, then explain a bad month to the CFO.
PennantProject
Who cancels in the first 90 days?
Pennant loses too many subscribers in their first three months. Build a churn table without peeking at the future, find who leaves, fit a first model and plan what the retention team should try.
PennantCase study
Is the annual offer result real?
A checkout test offered half the visitors an annual plan. The dashboard says it worked; count the test fairly and decide whether the difference is real before it ships.
TradewindProject
Should cheap listings pay a higher fee?
Tradewind takes a flat 12% on every sale. The marketplace lead wants tiered fees. Measure what sells in each price band, how far below the asking price it sells, and model what the tiers would earn.
Copperline FreightProject
Move the on-time report into the warehouse
Copperline's on-time report is a spreadsheet someone rebuilds every Monday. Rebuild it on the warehouse: one current row per shipment in Snowflake, a tested dbt model, and a Tableau view operations can trust.
Copperline FreightCase study
Two dashboards, two on-time numbers
Operations reports one on-time rate and finance reports a lower one, for the same month. Find out why, write the measure both teams agree on, and recommend which number goes to customers.
WayfriendCase study
The reminder question
Denver tested reminder notifications before planned meetups. Decide whether Wayfriend should send them in every city.
QuillfieldProject
Find the leads nobody is calling
Demo requests from the Central region have gone quiet since August. Fix the Salesforce rule that sends them to a rep who left, build the flow that tells each owner about a new lead, and report conversion by owner in Excel.
Projects and case studies in the Excel course
19 briefs inside the course, each a realistic task checked step by step in the tool.
See all 19 in the Excel course
Projects and case studies in the SQL course
12 briefs inside the course, each a realistic task checked step by step in the tool.
See all 12 in the SQL course
Projects and case studies in the Power BI course
11 briefs inside the course, each a realistic task checked step by step in the tool.
See all 11 in the Power BI course
Projects and case studies in the Tableau course
11 briefs inside the course, each a realistic task checked step by step in the tool.
See all 11 in the Tableau course
Projects and case studies in the pandas course
10 briefs inside the course, each a realistic task checked step by step in the tool.
See all 10 in the pandas course
What you can show at the end
A record with a verification code. Each project, case study and mock exam you finish gets a record that says what you did and when. Anyone you share the code with can check it.
A portfolio page. Your records collect on one page you can link from a CV or a LinkedIn profile. Check a record
Each project in the library starts with a brief from a fictional company: who is asking, what they want to decide and what data there is. You work through stages, each in its own tool, and the tables you produce in one stage are the tables the next stage starts from. Get a stage wrong and you find out then. Not three tools later.
Most projects end in a written readout: a short memo or recommendation that answers the question. It’s reviewed against what a good answer must cover, the same way the Interview Hub reviews a typed answer.
Starting points
Start small. If you are new to analysis, pick a case study inside one course, such as the ones from the Excel or SQL course below. If you have the basics, Your first 90 days as a data analyst strings three projects and case studies at one company into a journey.
There are separate pages for Excel projects, SQL projects and Power BI projects, and every course page lists its own. When you are ready to interview, the Interview Hub has spoken data analyst interviews, round by round.