Driving Retail Success with Data: Store Performance & Top Product Insights

This report presents a data-driven analysis of store performance and product trends using an interactive Tableau dashboard. The purpose of this analysis is to evaluate sales patterns, identify high-performing products, and inform operational and strategic retail decisions.

📊 Interactive Dashboard ↗️

I. Overview of Store Metrics

The analysis covers three store locations: Astoria, Hell’s Kitchen, and Lower Manhattan. Collectively, these locations recorded the following key performance indicators (KPIs):

Total Sales: $698,812.33

Sales Volume: 214,470 products

Total Transactions: 149,116

These indicators show that Brwr Coffee & Bread is performing strongly in terms of financial returns, volume, and customer activity. While specific metrics like foot traffic and conversion rates were not captured in this analysis, the consistently high transactions across all locations suggest healthy store engagement.

II. Sales Patterns by Time

Busy Days

Sales volume by day of the week indicates higher activity on weekdays:

Day	Sales Volume
Monday	31,231
Friday	31,207
Thursday	31,162
Wednesday	30,625
Tuesday	30,449
Sunday	30,182
Saturday	29,614

Insight: Mondays and Fridays have the highest customer activity. These days may require additional staffing and inventory restocking to meet elevated demand.

Peak Sales Hours

Hourly data reveals a sharp sales peak at 10:00 AM.

Implication: This time should be prioritized for maximum staff coverage, promotional activity, and customer service, as it represents the most critical window for customer engagement.

III. Monthly Sales Turning Point

The line chart displays a shift in sales volume beginning after February:

• Low Point: February

• Growth Phase: March to June

• Peak: June (52,942 products)

This indicates a positive trend in store performance, possibly linked to seasonal behavior, marketing campaigns, or adjustments in product strategy.

IV. Top Product Categories

The bubble chart highlights product categories based on performance, with Coffee and Tea products dominating:

Product	Sales Volume
Coffee	89,250
Tea	69,737

Insight: Coffee and tea are consistently high-performing and contribute significantly to overall sales. These products require close monitoring to avoid stockouts and ensure continued customer satisfaction.

V. Strategic Considerations

The dashboard reveals multiple actionable insights:

• Store Performance. Strong sales, volume, and transaction metrics confirm that Brwr Coffee & Bread is performing well overall.

• Product Monitoring. Coffee and tea are top-selling but may also be at risk of inventory pressure due to their volume. Stock levels and reorder points should be regularly reviewed.

• Peak Days. Mondays and Fridays require operational scaling (staffing, stock, marketing).

• Peak Hours. Focus on 10 AM for optimal impact through staffing, queue management, and high-visibility offers.

• Promotional Strategy. Leverage high-revenue items in bundles or early-day promotions.

  
  

VI. Conclusion

This analysis demonstrates the importance of using data visualization and analytics to guide decisions in retail operations. The Tableau dashboard reveals that:

• Brwr Coffee & Bread is achieving strong results across all KPIs.

• Coffee and tea require continuous inventory oversight due to their high demand.

• Mondays and Fridays are operationally intensive, requiring more staffing and support.

• 10 AM is the most critical hour for capturing customer sales.

By aligning business operations with these insights, Brwr Coffee & Bread can optimize performance, minimize stock disruptions, and enhance customer satisfaction. Ongoing monitoring and review of data will further support growth and strategic planning.