13th October, 2024

Tools Used: PowerBI

PROJECT OVERVIEW

Evaluated sales performance and customer behavior for a coffee business. Analyzed temporal sales patterns, payment methods, and product preferences to identify opportunities for optimization and promotional strategies. Tools used: Power BI, Excel.

OBJECTIVES

Purpose of Analysis:

• Evaluate overall sales performance and customer behavior.
• Understand temporal sales patterns (daily, weekly, monthly).
• Analyze payment methods and product preferences.
• Identify areas for business optimization and promotional opportunities.

DATA OVERVIEW

• Dataset Size: 2,623 transactions (customer IDs).
• Variables: Date, Time, Month, Payment Method, Price, Coffee Name, Time Range.
• Summary: Insights generated using Power BI visualizations and formulas.

KEY INSIGHT

General Sales Performance:

1. Total sales value: $83.6k, driven by weekday mornings, especially Tuesdays.
2. Most purchased coffees: Latte and Americano with Milk.
3. Average spend per customer: $31.89.

Payment Methods: