Sales Data Analysis

Overview

This project analyzes customer orders, products, and customer behavior stored in a MySQL database.
The analysis is performed using Python in a Jupyter Notebook environment, with SQL used to extract relevant data from the database.

Structure

ShopMart_E_Commerce_Company/

• analysis.ipynb: Contains the main Jupyter Notebook for data analysis
• key.env: Contains my DB credentials
• db.py: Reusable database connector
• requirements.txt: Python packages list
• seed_db.py: Schema + Simulated data generator
• schema.sql: SQL schema (reference only)

Requirements

To install the necessary Python libraries, run:

pip install -r requirements.txt