Interactive Coffee Sales Excel Dashboard

Project Overview: Interactive Coffee Sales Analysis & Dashboard (Excel)
In this project, I transformed raw sales data into an interactive, insight-driven Excel Dashboard to analyze retail coffee shop performance and optimize business decision-making.

Key Steps & Methodology:
Data Structuring & Cleaning (Transactions Sheet):

Processed detailed transaction records containing transaction ID, timestamp, store location, product categories, quantities sold, unit prices, and product specifics.

Data Aggregation & Analysis (Analysis & Pivot Table Sheets):

Built dynamic Pivot Tables to summarize high-level Key Performance Indicators (KPIs), including:

Total Orders & Quantities Sold

Total Revenue & Total Costs

Net Profit & Profit Margins (%)

Segmented metrics by product categories (e.g., Coffee, Bakery, Tea, Drinking Chocolate, Coffee Beans) and individual store locations.

Interactive Dashboard & Visualization (Dashboard Sheet):

Designed a comprehensive dashboard featuring key visual elements:

Bar Charts: Comparing Total Orders, Total Cost, Total Sales, and Net Profit across product categories.

Donut/Pie Charts: Showing quantity distribution by product type.

Dynamic Slicers: Enabled interactive filtering by Store Location (Astoria, Hell's Kitchen, Lower Manhattan) and Month (Jan – Jun), allowing users to drill down into specific performance metrics effortlessly.

Key Insights Derived:
Instant visibility into high-margin product categories vs. volume drivers.

Clear comparative analysis between store locations over time.

Data-backed foundation for inventory management, pricing strategies, and store-level optimization.

Tools Used: Microsoft Excel (Pivot Tables, Advanced Formulas, Slicers, Data Visualization, Dashboard Design).*