Projects/Greenbasket Market/Journey
Your first 90 days as a data analyst
You've joined Greenbasket Market, a fictional grocery chain with twelve stores, as its second data analyst. Each chapter is a request from a different part of the business, and each one uses the work you did before it.
Next: did the summer promotions pay?.
This is 90 days of a fictional role, not a 90-day deadline. Work at your own pace. Your checked tables and chapter progress carry forward.
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.
- 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
A fictional company. Its people and numbers are invented for practice.
Your chapters
- Days 1 to 30Project
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.
Excel → SQL → Power BI → Readout
Your first request: the category director wants to know which summer promotions paid before she books the fall calendar.
- Days 31 to 60Project
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.
Google Sheets → SQL → Tableau → Readout
Store operations hears about empty shelves from two managers and has budget for one round of fixes.
- Days 61 to 90Case 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.
SQL → Excel → Recommendation
The September report lands, and the CFO has a board meeting on Thursday.
- Days 91 to 120Project
A weekly trading dashboard
Turn the questions from your first quarter into one dashboard the leadership team reads every Monday.
SQL → Power BI
Leadership wants the answers without asking for them.
Coming soon
Your finish summary
Finish the chapters to make a summary of your work, the tools you practiced, and the decisions you supported.
Sharing is your choice. The summary describes practice at a fictional company.