Maven Roasters

This project analyzes transaction records for Maven Roasters, a fictional coffee shop with three NYC locations. The dataset includes transaction dates, timestamps, store locations, and product-level details. Using Excel, a dynamic dashboard was created to visualize sales trends, customer purchasing behavior, and store performance. The analysis also includes data-driven recommendations to help Maven Roasters increase revenue through strategies such as optimized pricing, targeted promotions, and inventory adjustments.

Recommended Analysis

1. How have Maven Roasters sales trended over time?

2. Which days of the week tend to be busiest, and why do you think that's the case?

3. Which products are sold most and least often? Which drives the most revenue for the business?

Files

Click here for the PDF and here for the Excel file.