This project is an E-commerce Data Analysis System built using Python and SQL.
It demonstrates how to load raw CSV data into a SQL database, perform complex queries, and analyze customer behavior, sales trends, and product performance.
The project includes:
- A Jupyter Notebook (
Project.ipynb) for step-by-step analysis - A Python script (
csv_to_sql.py) to import CSV files into SQL - A set of SQL/business questions (
Questions.txt) to guide analysis
- Load CSV datasets into a SQL database using Python
- Run SQL queries for business-related questions
- Analyze sales, customers, and transactions
- Interactive analysis with Jupyter Notebook
- Modular design for scalability