E-commerce sales analysis of products across Nigeria (electronics, fashion, and home utensils). Includes customer behavior, regional trends, delivery performance, and sales insights, analyzed using Excel.
# E-commerce-Sales-Analysis-
# π E-Commerce Data Analysis Report
---
## 1. INTRODUCTION
This e-commerce dataset brings together information on products from **three main categories**:
- Electronics
- Fashion
- Home Utensils
Within these categories, subcategories include **accessories, clothing, appliances, audio, kitchen, and power**, each containing products that reflect everyday shopping trends.
The dataset also covers customer activity across **four Nigerian locations**: Abuja, Oyo, Lagos, and Rivers β offering insights into regional e-commerce engagement.
By combining product and customer details, this dataset serves as a **useful resource** for research, development, and consumer insights. It provides a solid foundation for understanding **shopping patterns, market trends, and customer behaviour**.
> **Note**: This dataset was analyzed using **Excel**.
---
## 1.1 OBJECTIVES
I. **Analyze Sales Performance** β Evaluate category and subcategory performance across regions.
II. **Understand Customer Behaviour** β Study shopping patterns in Abuja, Oyo, Lagos, and Rivers.
III. **Identify Regional Market Trends** β Highlight region-specific product demands.
IV. **Measure Product Popularity** β Determine most frequently purchased products.
V. **Support Business Decision-Making** β Provide insights for inventory planning, marketing, and customer engagement.
---
## 1.2 SCOPE
I. **Product Coverage** β Electronics, fashion, and home utensils (subcategories: accessories, clothing, appliances, audio, kitchen, and power).
II. **Geographic Coverage** β Abuja, Oyo, Lagos, and Rivers.
III. **Customer Insights** β Shopping patterns, preferences, and demand differences.
IV. **Business Applications** β Support for sales strategy, marketing, and inventory planning.
V. **Research & Development** β Foundation for market studies and predictive modelling.
---
## 1.3 DATASET OVERVIEW
- **Data Source**: Extracted from a reliable e-commerce database.
- **Dataset Size**: 1112 β¦