Book Appointment Now
Excel Interactive Dashboard: Coffee Shop Sales Analysis Report
Coffee Shop Sales Analysis Report
Overview
This project showcases my ability to analyze and present data in a clear, interactive, and actionable format. Using sales data from a coffee shop chain, I developed a dashboard that simplifies complex datasets into meaningful insights. This allows users to explore revenue trends, customer behavior, and product performance across multiple locations with ease.
Key Insights
- Astoria Location: Revenue displays a growing trend over months, with Mondays and Thursdays leading in transactions. Mornings are the busiest times, and coffee is the dominant product.
- Hell’s Kitchen Location: A similar revenue trend is observed, with Tuesdays and Saturdays showing the highest sales. Morning transactions remain the highest, with coffee as the preferred product.
- Lower Manhattan Location: Revenue trends are consistent across months, but Mondays dominate in sales. Transactions peak during morning hours, with coffee leading in popularity.
Conclusion
This project reflects my dedication to transforming data into actionable insights and highlights my learning journey in data visualization. I welcome your feedback, input, or suggestions for improvement to continue refining my skills and delivering impactful projects.
Data rights @Maven Analytics