Coffee Shop Analysis

Coffee Shop Sales Analysis – Data Analytics Project

Dataset: Coffee Shop Sales

Tools: Microsoft Excel

Project Goal:

Analyze coffee shop sales data to understand product performance, sales trends, and customer purchasing patterns.

What I Did:

Cleaned and prepared the dataset using Excel

Analyzed sales performance by product and time

Calculated key metrics such as total revenue and average order value

Built an interactive dashboard in Microsoft Excel

Key Insights

A small number of products generated a large portion of revenue

Sales peaked during morning hours

Some items had high order frequency but lower revenue contribution