Excel dashboard for analyzing a coffee shop chain's sales performance, footfall, and customer patterns. Features include Pivot Tables, KPI Cards, and Dynamic Slicers. The dashboard replaced manual tracking with a unified reporting system for three NYC locations.
From the README
☕ Coffee Shop Sales Dashboard 📊 Overview Interactive Excel dashboard built to analyze a Coffee Shop chain's sales performance, identify peak hours, compare store locations, and understand customer ordering patterns across months and weekdays. --- 🎯 Problem Statement The business needed a single-view dashboard to monitor sales, footfall and product trends across 3 NYC store locations — replacing manual tracking with no unified reporting system. --- 🛠️ Tech Stack --- 🔍 What I Did • 🟩 Cleaned and structured raw transaction data using Excel • 🟩 Built Pivot Tables for dynamic KPI calculation • 🟩 Designed 6-visual interactive dashboard with Month & Day slicers • 🟩 Analyzed hourly...
