Project: Online Retail Sales Analysis

Project Overview

The goal of this project is to analyze online retail sales data to gain insights into customer behavior, product performance, and sales trends.

Dataset

The dataset for this project is generated using the Python Faker library. It includes the following tables:

1. Customers: Contains information about the customers, such as customer ID, name, gender, age, country, and region.
2. Products: Contains information about the products, including product ID, name, price, and category.
3. Orders: Contains information about the orders, such as order ID, customer ID, order date, and delivery date.
4. OrderItems: Contains information about the items in each order, including order ID, product ID, and quantity ordered

Project Structure

The project is structured as follows:

• data_generation.py: Python script to generate the synthetic dataset using the Python Faker library.
• Sales Analysis.sql: SQL queries to perform various analyses on the generated dataset.

Getting Started

To use this project, follow the steps below:

1. Clone the project repository: https://github.com/devGeepee/SQL-Sales-Analysis
2. Install the required dependencies (Faker and Pandas)
3. Run the data_generation.py script to generate the dataset.
4. Import the generated dataset into your preferred database management system.
5. Execute the SQL queries in Sales Analysis.sql to perform the desired analyses.
6. Review the results and extract insights from the analysis.

Contact

For any questions or inquiries, please contact godspowerobielum@gmail.com