Coffee Shop Sales Analysis Project

Overview

Welcome to the Coffee Shop Sales Analysis Dashboard project! This project aims to provide a comprehensive analysis of sales data for a coffee shop using an interactive Excel dashboard. By leveraging data analytics techniques, we uncover valuable insights into sales trends, peak hours, popular products, and more, empowering stakeholders to make informed business decisions.

Features

• Hourly Trends: Discover peak order times throughout the day.
• Daily Sales Analysis: Gain insights into sales trends across different days of the week.
• Product Category Analysis: Explore sales patterns across various product categories.
• Size Distribution: Percentage breakdown of orders by size, guiding inventory management.
• Store Location Performance: Regional sales analysis to optimize store operations.
• Top Selling Products: Identify customer favorites driving revenue.
• Customer Behavior Analysis: Understand customer preferences and purchasing patterns.

Project Structure

• data/: Contains the raw sales data in CSV format.
• scripts/: Includes scripts for data cleaning, transformation, and analysis.
• dashboard/: Contains the Excel dashboard file for visualization and exploration of insights.
• README.md: The main documentation file providing an overview of the project.

Getting Started

To get started with this project, follow these steps:

1. Clone the repository to your local machine.
2. Navigate to the dashboard/ directory.
3. Open the Excel dashboard file (coffee_shop_sales_dashboard.xlsx).
4. Explore the different sheets and charts to analyze the sales data.

Dependencies

This project requires Microsoft Excel for data visualization and exploration. No additional libraries or packages are needed.