Sales Data Analysis

Project Overview

This project analyzes a retail sales dataset to uncover business insights that can support data-driven decision making. Using Python for data cleaning, exploration, and visualization, the analysis identifies sales patterns across regions, customer segments, product categories, and time.

Objectives

• Clean and prepare raw sales data
• Perform exploratory data analysis (EDA)
• Identify top-performing regions and categories
• Analyze customer purchasing patterns
• Discover high-value products
• Generate actionable business insights

Dataset features

Category	Variables
Order Information	Order ID, Order Date, Ship Date, Ship Mode
Customer Information	Customer ID, Customer Name, Segment
Geographic Information	Country, City, State, Postal Code, Region
Product Information	Product ID, Category, Sub-Category, Product Name
Sales Information	Sales

Tools and technologies

• Python
• Pandas
• NumPy
• Matplotlib
• Jupyter Notebook

Project Workflow

Data cleaning

• Checked missing values
• Removed duplicates
• Converted data types
• Prepared date columns for analysis

Exploratory Data Analysis

• Overall sales performance
• Sales by region
• Sales by category
• Sales by customer segment
• Product-level analysis
• Time-series sales trends

Visualizations

Sales by Region

Shows total sales generated across each region.

Sales by Category

Compares revenue generated by each product category.

Sales Trend

Illustrates changes in sales over time, highlighting seasonal trends.

Customer Segment

Displays sales contribution by customer segment.

Key findings

• West region generated the highest total sales.
• Technology products produces the highest revenue.
• Consumer customers contributed the largest share of sales.
• A relatively small number of products generated a significant portion of revenue.
• Sales trends suggest recurring seasonal patterns thoughout the year.

Business value

The insights from this project can help businesses:

• Improve inventory planning
• Prioritize high-performing product categories
• Optimize regional sales strategies
• Better understand customer purchasing behavior
• Support strategic business decisions using data

Files

File	Purpose
README.md	Project overview and documentation
Sales_Data_Analysis.ipynb	Complete notebook with analysis
Train.csv	Dataset used for analysis
requirements.txt	Python packages required
.gitignore	Excludes notebook checkpoints and cache files
LICENSE	MIT license for the project
images/	Exported charts used in the README

Author

Enoch Elijah