🛒 Shop Smarter — Data-Driven E-Commerce Insights

Overview

This project analyzes e-commerce data to provide actionable insights:

• Top product categories by revenue
• Best customers
• Peak sales periods
• Underperforming products

Tech Stack

• Python (pandas, SQLAlchemy)
• PostgreSQL (data storage)
• Power BI (dashboard visualization)

Folder Structure

data

sql

src

main.py

README.md

How to Run

1. Run main_file main.py else
2. Run cleaning: python src/01_data_cleaning.py
3. Run analysis: python src/02_data_analysis.py
4. Upload to PostgreSQL: python src/03_load_to_postgres.py
5. Open Power BI and connect to PostgreSQL for dashboards.

🧑‍💻 Author

Kavin Kishore
B.Tech Student, DTU
Developed as a real-time data analytics mini project using Python, PostgreSQL & Power BI.