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).*