☕ Coffee Shop Sales Analysis (Excel) 📊 Overview
This project presents a comprehensive sales analysis of a coffee shop using Microsoft Excel. It focuses on extracting actionable insights from transactional data to support business decision-making, improve operational efficiency, and identify revenue trends.
🎯 Objectives
Analyze overall sales performance
Identify top-selling products and categories
Evaluate peak sales hours and days
Understand customer purchasing behavior
Generate insights using Excel dashboards
🛠️ Tools & Technologies
Microsoft Excel
Pivot Tables
Pivot Charts
Data Cleaning
Dashboard Creation
Formulas & Functions (e.g., SUM, IF, VLOOKUP)
📌 Key Features
📈 Interactive dashboard for quick insights
🧹 Data cleaning and preprocessing
📊 Sales trends by:
Date
Product category
Time of day
🏆 Identification of best-selling items
💡 Business recommendations based on data
🔍 Analysis Highlights
Peak sales typically occur during morning hours
Certain beverage categories outperform others consistently
Seasonal or time-based demand variations observed