coffe shop sales

Developed an interactive sales dashboard in Microsoft Excel to analyze coffee shop performance across multiple locations.

Performed data cleaning and preprocessing to ensure accurate sales and transaction analysis.

Analyzed monthly revenue trends to track business growth and identify seasonal patterns.

Evaluated top 15 products by transactions and revenue to determine best-selling items.

Analyzed transactions by hour of day to identify peak customer activity periods.

Examined sales performance by day of the week to understand customer purchasing behavior.

Conducted product category analysis to compare sales across coffee, tea, bakery, and other product groups.

Implemented interactive filters (slicers) to allow dynamic analysis by store location.

Designed a clear and visually structured dashboard to support business insights and decision-making.