Coffee Sales Dashboard

Overview

The Coffee Sales Dashboard is an Excel-based project that visualizes coffee sales data, providing insights into key metrics and trends. The project includes data cleaning processes, advanced Excel functionalities such as XLOOKUP and Pivot Tables, and an interactive dashboard.

Key Features

• Data Cleaning:
  • Removed duplicates and corrected data inconsistencies.
  • Standardized formatting for dates, sales figures, and customer details.
• Excel Functions:
  • Used XLOOKUP for efficient data retrieval and joining across multiple sheets.
  • Applied formulas for calculated fields, such as total revenue, sales per region, and average order size.
• Interactive Dashboard:
  • Includes charts and visuals for:
    • Total Revenue
    • Sales by Region
    • Top Performing Products
    • Monthly Sales Trends
• Pivot Tables:
  • Created dynamic pivot tables to summarize data and allow flexible analysis by category, region, and date.

Files Included

1. COFFEE SALES DASHBOARD.xlsx: The final dashboard with interactive visuals.
2. coffeeOrdersData.xlsx: The raw sales data used for analysis and dashboard creation.

How to Use

1. Open the COFFEE SALES DASHBOARD.xlsx file in Microsoft Excel.
2. Interact with the dashboard elements (e.g., slicers, pivot tables) to explore different dimensions of the data.
3. For data exploration, use the coffeeOrdersData.xlsx file to review the cleaned dataset and replicate the steps.

Insights

• Revenue Analysis:
  • Highlights the top-performing products and regions.
  • Tracks monthly revenue trends to identify peak sales periods.
• Customer Behavior:
  • Insights into order sizes and frequency.
  • Regional preferences for specific coffee products.
• Operational Metrics:
  • Evaluates performance against key KPIs like average sales per order.

Technologies Used

• Microsoft Excel:
  • Data cleaning, analysis, and dashboard creation.
  • Advanced formulas and pivot tables for data summarization.
  • Conditional formatting for visual emphasis.

Repository Structure

Coffee-Sales-Dashboard/ ├── COFFEE SALES DASHBOARD.xlsx # Final Excel dashboard ├── coffeeOrdersData.xlsx # Raw sales data └── README.md # Project documentation

About

This project demonstrates the use of Excel for end-to-end data analysis, from cleaning and preparation to visualization and reporting. It is designed to help businesses track and analyze their coffee sales effectively.

---