Maven Roaster's Sales Dashboard

The transactional data I'm using here is from Maven Roasters, a coffee shop chain with three locations in New York City from Jan-Jun 2023.

The Objective :

1. Profile and prepare the raw data for analysis

2. Explore the data with Excel PivotTables

3. Build a dynamic dashboard

Prepare the data for analysis: Explored the coffee shop dataset, conducted basic data QA and profiling, and added calculated date and time fields to prepare the data for analysis.

Explored the coffee shop data using Excel PivotTables: Performed slicing and dicing to create views that analyze time series and product-level trends.

Build a dynamic dashboard: Visualized the data using Pivot Charts, designed an interactive dashboard, and identified insights and recommendations for the coffee shop. And to visualize patterns and trends that franchise owners can use to identify patterns, trends and opportunities for the business.

Insights:

Lower Manhattan:

• Monday consistently demonstrates the highest footfall throughout the week.
• Peak hours are observed from 7 am to 10 am, with significantly reduced customer traffic after 7 pm.
• Top-selling products include Barista Espresso and Gourmet Brewed Coffee.
• Packaged chocolate registers the lowest sales volume.

Astoria:

• The busiest days are Monday, Wednesday, Thursday, and Friday.
• Sales remain stable throughout operational hours.
• Top-selling products include Brewed Chai tea and Gourmet brewed coffee.
• Packaged chocolate has the lowest sales volume.

Hell's Kitchen:

• Peak hours are observed from 8 am to 10 am and significant reduced customer traffic at 8pm.
• Top-selling products include Barista Espresso and Brewed Chai tea.
• Branded coffee and Packaged chocolate has the lowest sales volume.

Recommendations:

• Consider discontinuing Loose Tea, Branded, and Packaged Chocolate due to their low sales.
• In Lower Manhattan, the period after 7 pm experiences lower customer traffic. Consider reducing operational hours or introducing evening promotions.
• Increase staffing during morning hours until 11 am, which is the rush period for all three centers, to improve customer service.