Coffe Sales Analysis

🔹 Project Workflow:

• Data Cleaning using Power Query

• Handling missing values and duplicates

• Merging multiple datasets into a unified fact table

• Creating a Calendar Table for time-based analysis

• Building relationships and preparing the data model

• Performing Exploratory Data Analysis (EDA)

• Creating Pivot Tables and Interactive Dashboards

📊 Key Business Questions Answered:

✅ What are the top-selling coffee products?

✅ Which products generate the highest revenue?

✅ Which months perform best?

✅ Do customers prefer Cash or Card payments?

✅ How did sales performance change between 2024 and 2025?

🛠️ Tools Used:

• Microsoft Excel

• Power Query

• Power Pivot

• Pivot Tables & Charts