1. Prompt

  • You are the business analyst on the Strategy and Operations team for the Adeline Shop Company. The company has physical shops in three cities in California, and customers place their orders via the app and pick up the orders in person.
  • The objective of Adeline Shop this year is to grow total sales revenue (please note that menu prices for the year have been set already). Based on the one week app data attached, please present your findings and provide a set of recommendations for growing total sales revenue. Feel free to make your own assumptions.

2. Data fields

  • Columns: 13
  • Rows: 1,049
Adeline - Case Study - Raw data

3. Metrics Definition

Column Name Metric Definition Type
user_id Unique identifier of a customer Dimension
store city City where the store is located Dimension
store_id Unique identifier of a store Dimension
placed order time Time when the customer placed the order (DAY-HOUR-MINUTE-SECOND, UTC) Dimension
finished prep time Time when the store finished prepping the order (HOUR-MINUTE-SECOND, UTC) Dimension
order picked up time Time when the customer picked up the order (HOUR-MINUTE-SECOND, UTC) Dimension
account created Year when the customer created the account on the app (YEAR) Dimension
order total Amount customer spent (in $USD) Measure
order size Number of drinks in the order Measure
refund total Amount refunded to the customer (in $USD) Measure
rating Rating the customer gives after picking up the order (from 1 to 5) Measure

4. Tools: Google Sheets, Google Slides.

BACK TO HOMEPAGE