Welcome to the Coffee Shop Sales Analysis project repository. This project focuses on analyzing sales data from a coffee shop to derive insights into its business operations. The analysis was performed using Microsoft Excel, leveraging data processing and visualization techniques. Key findings, trends and actionable recommendations are detailed in the accompanying documents to support data-driven decision-making and strategic planning.
✅Tool for Analysis: Microsoft Excel
The main objective of this project is to analyze retail sales data to gain actionable insights that will enhance the performance of the coffee shop.
1. How do sales vary by day of the week and hour of the day?
2. Are there any peak times for sales activity?
3. What is the total sales revenue for each month?
4. How do sales vary across different store locations?
5. What is the average price/order per person? I have noted the text. Thank you for providing the details.
6. Which products are the best selling in terms of quantity and revenue?
7. How do sales vary by product category and type?
🔸Cleaning Data - Clean and extract data set
🔸Formatting - To make it easier to read, understand and Analyze
🔸Using Pivot Tables to analyze data
🔸Creating a Dashboard - To Visualize
1. Collect and Understand the Dataset
2. Determine Key Performance Indicators(KPIs) essential for business decision-making.
3. Inspect the data and clean and extract the insights.
4. Replace the missing category and check data types and null values.
5. Use Pivot tables and various charts to create different visualizations and analyze sales across different product categories, types and store locations.
6. Plot sales trends over weekdays and hours for deeper insights.
7. Calculate important KPIs such as total sales, no.of transactions and total quantity ordered.
8. Overall review the visualization and apply domain knowledge to draw conclusions from a sales perspective.
✅Sales Focus:
🔸Morning(7am to 10am) - Increase staff and resouces to handle higher customer volume.
🔸Coffee, Tea and Bakery - Prioritize these high selling categories with staff and marketing efforts.
🔸Tuesdays, Saturdays and Sundays - Reduce staff and resources due to lower sales.
✅Product Analysis:
🔸Focus on Coffee Beans and Branded items - Explore price adjustments or promotions to improve sales despite higher unit prices.
✅Overall Sales Growth:
🔸Considering the steady increase in sales and transaction volume, optimize staff allocaton and marketing strategies for continued growth.