Sales Data Analysis in Excel

Project Overview

This project is an Excel sales analysis dashboard built from a sample sales dataset.
The goal was to analyze revenue by country, product line, and month, and present the results in a clear and interactive dashboard.

Dataset

The dataset includes sales transaction data with fields such as:

• Country
• Product Line
• Sales
• Order Number
• Month
• Year

Objectives

The main goals of this project were:

• identify the top-performing countries by revenue
• identify the best-performing product lines
• analyze monthly sales trends
• build an interactive dashboard in Excel

Tools and Excel Features Used

• Pivot Tables
• Pivot Charts
• Slicers
• Basic Excel formulas
• KPI cards
• Dashboard formatting and layout

Dashboard Preview

Key Insights

• USA generated the highest total revenue.
• Classic Cars was the top-performing product line.
• Sales peaked in November.
• Revenue varied significantly across countries.
• A small number of countries and product lines generated most of the sales.

Business Recommendations

• Focus more on high-performing markets such as the USA.
• Support strong product lines like Classic Cars with targeted promotions.
• Plan marketing campaigns before peak sales months.
• Review weaker months and lower-performing segments to identify growth opportunities.

File Structure

sales-data-analysis/
├── data/
│   └── sales_data_sample.csv
├── analysis/
│   └── data_set.xlsx
├── charts/
│   └── dashboard.png
└── README.md