Projects/Companies
The fictional companies behind every brief
Every project, case study and journey happens at one of these companies. Read about the business and the people who send the briefs before you open the data. All of them are invented for practice, and so are their numbers.
Greenbasket Market
Grocery retail
A grocery chain with twelve stores in four Ohio cities.
Greenbasket Market sells fresh food and everyday groceries in Columbus, Dayton, Cincinnati and Cleveland. Six of its stores are small neighborhood shops and six are larger superstores. The sales you work with cover five categories: produce, dairy, bakery, snacks and beverages. Much of the data is typed in by hand in the stores and in marketing, so it is rarely clean. Requests come from category management, store operations and finance, and you sit in a two-person analytics team at the head office.
Briefs at Greenbasket Market
- Did the summer promotions pay?Project · Excel → SQL → Power BI · 2 h 30 min
- The empty-shelf problemProject · Google Sheets → SQL → Tableau · 2 h 10 min
- Why did September revenue drop?Case study · SQL → Excel · 1 h
- Your first 90 days as a data analystJourney · Excel → SQL → Power BI → Google Sheets → Tableau · 5 h 40 min
- Founded
- 1998
- Head office
- Columbus, Ohio
- Stores
- 12 in four cities
- Employees
- About 1,300
Who writes the briefs
- Dana WhitfieldCategory Director
- Marcus BellHead of Store Operations
- Priya RamanCFO
Pennant
Fitness app
A fitness app with guided workouts, sold as a monthly or annual subscription in the UK.
Pennant gives people guided workouts and training plans they can follow at home or in the gym. Subscribers pay by the month or for a year up front, and they sign up through the app stores, a friend's referral or a paid social ad. They live all over the UK, including London, the Midlands, Scotland and Wales. About one in four new monthly subscribers cancels within three months. You work in the data team with two groups: retention, which tries to keep new subscribers training, and product, which runs tests in the checkout.
Briefs at Pennant
- Who cancels in the first 90 days?Project · SQL → pandas → Machine learning · 2 h 50 min
- Is the annual offer result real?Case study · SQL → pandas · 1 h
- Founded
- 2019
- Head office
- Manchester, UK
- Plans
- Monthly or annual
- Employees
- About 70
Who writes the briefs
- Hannah OkoroHead of Retention
- Tom AshbyProduct Lead
Tradewind
Online marketplace
An online marketplace for second-hand furniture in the Netherlands.
On Tradewind, private sellers and small dealers list used sofas, tables, chairs, storage and lighting, and buyers nearby make an offer. The marketplace runs in Amsterdam, Rotterdam, Utrecht, Eindhoven and Groningen. Tradewind earns a commission on every sale, a flat 12% today, and the marketplace team decides the fees. A small lamp costs as much to support as a sofa but earns a fraction of the commission. You work in the analytics team that answers the marketplace team's questions.
Briefs at Tradewind
- Should cheap listings pay a higher fee?Project · BigQuery → pandas → Google Sheets · 2 h 20 min
- Founded
- 2017
- Head office
- Utrecht, Netherlands
- Cities
- 5
- Employees
- About 45
Who writes the briefs
- Joost van DijkHead of Marketplace
Copperline Freight
Freight and logistics
A freight carrier that moves shared truckloads on six lanes between Canadian cities.
Copperline Freight carries less-than-truckload freight: pallets from businesses that ship too little to fill a truck, such as pharmacies, food suppliers and furniture makers. Its six lanes are Toronto to Montreal, Toronto to Ottawa, Calgary to Edmonton, Vancouver to Calgary, Winnipeg to Regina and Montreal to Halifax. Every shipment gets a promised delivery date, and on-time delivery is the number customers watch, yet it still lives in a spreadsheet that someone rebuilds by hand every Monday. You work with operations, which runs the trucks and the docks, and with finance.
Briefs at Copperline Freight
- Move the on-time report into the warehouseProject · Snowflake → dbt → Tableau · 2 h 40 min
- Two dashboards, two on-time numbersCase study · SQL → Power BI · 1 h
- Founded
- 1987
- Head office
- Toronto, Ontario
- Lanes
- 6, across nine cities
- Employees
- About 350
Who writes the briefs
- Luc BergeronDirector of Operations
- Aisha MensahChief Operating Officer
Wayfriend
Consumer app
An app for planning meetups with friends, live in Austin, Denver and Portland.
Wayfriend helps friends turn a plan into a meetup. One person sends an invite with a time and a place, friends accept, and anyone on the way can share their location. The app is live in three US cities and logs every invite and location ping in UTC, though phones drop pings and the data has gaps. You join a two-person data team that answers to the product lead and works closely with the growth team.
Briefs at Wayfriend
- From invites to meetupsProject · Databricks → dbt → SQL → Dagster · 3 h 30 min
- The reminder questionCase study · Databricks → SQL · 45 min
- Your first 90 days as a data engineerJourney · Databricks → dbt → SQL → Dagster · 8 h
- Founded
- 2023
- Head office
- Denver, Colorado
- Cities
- 3
- Employees
- About 30
Who writes the briefs
- Rosa ImaniProduct Lead
- Theo BlumGrowth Lead
Quillfield
Business software
Scheduling and invoicing software for plumbing, HVAC and electrical contractors in the US.
Quillfield sells a subscription app that small contractors use to book jobs, send technicians out and get paid. Most new customers start as a demo request on the website; a few come from trade events, referrals and partners. Three account executives each cover a region, East, West and Central, and a sales development rep picks up what falls between them. Leads live in Salesforce, which routes each one with an assignment rule, and the team works from email and a Teams channel. You work in sales operations, the small team that keeps the routing, the flows and the reports running.
Briefs at Quillfield
- Find the leads nobody is callingProject · Salesforce → Power Automate → Excel · 1 h 50 min
- Founded
- 2018
- Head office
- Columbus, Ohio
- Sales regions
- East, West and Central
- Employees
- About 85
Who writes the briefs
- Alicia GrantVP of Sales
- Luis OrtegaAccount Executive, Central
Velomint
Urban mobility
An app for renting e-bikes by the minute in Lisbon and Porto.
Riders find a Velomint e-bike in the app, unlock it with their phone and pay by the minute, with a small card hold at each unlock. Commuters ride most on weekday evenings. The app talks to rides-api, a Node.js service that handles unlocks, rides and payments; it runs as a Kubernetes Deployment behind an AWS load balancer, and alerts go to an SNS topic the on-call engineer subscribes to. Releases go out from the main branch of one shared Git repository. You work in the platform team, which owns the cluster, the releases and the alarms.
Briefs at Velomint
- Recover from a failed releaseProject · Git → Docker and Kubernetes → AWS · 2 h
- Founded
- 2021
- Head office
- Lisbon, Portugal
- Cities
- Lisbon and Porto
- Employees
- About 60
Who writes the briefs
- Tomás PereiraHead of Engineering
- Sofia RamosPlatform Engineer, on call on Friday
Marlow & Pike
Wholesale distribution
A wholesale distributor of commercial kitchen equipment for restaurants and hotels in Ohio and Michigan.
Marlow & Pike buys ovens, refrigeration, dishwashers and smallwares from manufacturers, keeps them in a warehouse in Toledo and delivers them with its own vans. It also installs larger equipment such as walk-in coolers. Customers range from single restaurants to hotel groups, and most pay on 30-day terms. Finance closes the books in the first week of each month, and the CFO compares cash with a monthly forecast. You work in the finance team as the analyst who prepares the month-end pack.
Briefs at Marlow & Pike
- Close October and explain the cashProject · Accounting → Excel → Power BI · 1 h 40 min
- Founded
- 1998
- Head office
- Toledo, Ohio
- Customer terms
- 30 days
- Employees
- About 40
Who writes the briefs
- Renata SilvaChief Financial Officer
Hearthline
Online retail
A small online shop for bedding, candles, cookware, lighting and rugs in the US.
Hearthline sells homewares from its own website and ships from one warehouse. It buys from a handful of suppliers, sets its own prices, and runs discount codes: WELCOME10 for first orders and seasonal codes such as SUMMER25. The shop platform exports every order line with its list price, the discount and the unit cost, and the team pulls that export into spreadsheets, a small database and a Power BI report. You have just joined as the first data analyst, reporting to the head of e-commerce.
Briefs at Hearthline
- Why is profit falling when sales are up?Project · Excel → SQL → pandas → Power BI · 2 h 30 min
- Founded
- 2021
- Head office
- Asheville, North Carolina
- Categories
- 5
- Employees
- About 8
Who writes the briefs
- Grace MorenoHead of E-commerce
Ashgrove Engineering
Engineering services
A civil and structural engineering consultancy that designs and inspects buildings and bridges in Colorado.
Ashgrove designs structures for developers and school districts and inspects bridges and parking structures for public owners. The Denver office has a structures team, an inspection team and a project lead; some engineers work part time. Clients pay by the hour, so every week each engineer's hours are planned in the resource planner against the jobs the firm has won, with leave taken off first. Operations decides who works on what and when to hire. You work in operations, planning people and reporting their load.
Briefs at Ashgrove Engineering
- Staff a new programme without burning anyone outProject · Resource planning → Excel · 1 h 15 min
- Founded
- 2009
- Head office
- Denver, Colorado
- Engineers in Denver
- 10
- Teams
- Structures and inspection
Who writes the briefs
- Diane MercerDirector of Operations
Orchard Row Dental
Healthcare
A group of six family dental clinics in Oregon, with an online portal for patients.
Orchard Row runs dental clinics in Salem, Eugene, Corvallis, Albany, Bend and Medford. Patients book appointments and open their invoices in a web portal that a small in-house team built and runs. Each invoice has a link with its number in it, and each patient signs in to see their own. Front desks pass on anything odd that patients report, and the compliance lead decides who must be told about a privacy incident. You are the security engineer in the IT team.
Briefs at Orchard Row Dental
- A patient saw someone else's invoiceProject · Linux → Application security · 1 h 20 min
- Founded
- 2004
- Head office
- Salem, Oregon
- Clinics
- 6
- Employees
- About 120
Who writes the briefs
- Monica FieldHead of IT
- Andre SilvaCompliance Lead