Retail Coffee Sales Performance Dashboard

Built in Microsoft Excel to analyze customer spending patterns, coffee sales trends, and country performance using transactional sales data.

🧠 Problem

The goal of this project was to answer key business questions from a coffee sales dataset:

• Who are the top-paying customers?
• Which coffee types perform best over time?
• Which country generates the highest sales revenue?
• How do sales trends change across months and years?

📊 Dataset

The dataset used for this project was the Coffee Sales Orders dataset shared through a tutorial by Mo Chen.

Data Source:

Coffee Sales Dataset + Tutorial

⚙️ Process

1. Data Preparation

• Downloaded the coffee sales order dataset
• Structured and cleaned the data inside Microsoft Excel
• Verified consistency across customer and order information