Caffeine Analytics

Project Overview

The primary objective of this project is to understand customer purchase patterns and trends. This will be accomplished by analyzing January 2023 to June 2023 data that includes revenue and transaction counts, filtered location, days of the week, and hours of the day.

Project Task:

• Data collection, cleaning, and preparation
• Analyze monthly, daily, and hourly sales patterns with PivotTables.
• Determine high-performing days and times.
• Develop compelling reports and visualization
• Create an Interactive dashboard

Key Findings

• Total revenue:
  • May and June revenue account for 45% of total revenue ($323,313 of $698,812)
• Total count of transactions (Jan 2023 - Jun 2023)
  • 6am-10am account for 48% of total transaction per day
    • Peak time: 8am-10am accounts for 37% of total transactions per day
• Coffee & Tea
  • Coffee/tea account for 70% of total transactions
  • Barista espresso and gourmet brew account for 57% of total customer orders.
  • Tea: chai 38%
• Area of Improvement
  • Tuesday revenue concerns (Astoria)
    • 6% decrease in total revenue from Monday to Tuesday sales
      • largest percent decline in total revenue out of any other day (over 6 month period)
        • context: Friday to Saturday loss in revenue is about 4% (over 6 month period)
    • Possible driver of Tuesday revenue loss:
      • 20% decline in total revenue from Premium brewed coffee sales
• Recommendations
  • Astoria creates Tuesday promotion for premium brewed coffee during peak transaction times (7am-10am) to sustain momentum from Monday's spike in total revenue and transactions.
  • Speak with franchise owner of Hell's kitchen location to collaborate on ideas to improve Tuesday's revenue and transaction numbers.
    • Hell's kitchen Monday to Tuesday revenue increased by 5% over 6 month period.