🛒 E-commerce Sales Analytics Dashboard

An end-to-end Data Analytics project that analyzes e-commerce sales data and delivers business insights through an interactive dashboard.

---

🚀 Live Demo

🔗 https://ecommerce-sales-analytics-da.streamlit.app/

📌 Project Overview

This project simulates a real-world e-commerce analytics system. It includes data generation, SQL analysis, Python processing, and a live dashboard.

The goal is to answer key business questions like:

• Which products generate the most revenue?
• What are the top-performing categories?
• How do sales trends change over time?
• What is the profit distribution?
• When does peak sales activity occur?

---

🛠️ Tech Stack

• Python
• Pandas
• Plotly
• Matplotlib & Seaborn
• Streamlit
• PostgreSQL (for local analysis)

---

📊 Features

📈 Analytics Dashboard

• Interactive KPI cards (Revenue, Orders, Customers, AOV)
• Revenue trend visualization
• Category-wise performance
• Top products analysis

🎛 Filters

• Date range filter
• Category filter

💰 Business Insights

• Profit analysis
• AI-generated insights section

🔥 Advanced Visualizations

• Sales heatmap (dark theme)
• Interactive charts using Plotly

⬇️ Reports

• Download data as CSV
• Export summary as PDF

🔄 Live Features

• Auto-refresh dashboard

Author

Ansh