📊 E-Commerce Revenue & Customer Insights Dashboard
📌 Project Overview
This project focuses on analyzing e-commerce sales data to uncover valuable business insights related to customer behavior, product performance, and revenue trends.
An end-to-end data analytics workflow was implemented, starting from database design in SQL to building an interactive dashboard in Power BI.
📌 Problem Statement
Analyze e-commerce sales data to identify customer behavior patterns and generate actionable business insights.
- MySQL (Database design & SQL queries)
- Power BI (Data visualization & dashboard creation)
📊 Dashboard Highlights
- Top Customers by Revenue
- Product Performance Analysis
- Order Trends Over Time
- Category-wise Revenue Distribution
🔍 Key Insights
- Identified high-value customers contributing the majority of revenue
- Recognized best-selling products and categories
- Observed order patterns to understand sales trends
- Compared category-wise revenue to guide business decisions
📁 Project Files
ecommerce.sql → Database schema and queriesecommerce_dashboard.pbix → Power BI dashboard file
📥 How to Use
- Download the
.pbix file to interact with the dashboard in Power BI
- Review the SQL file to understand database structure and queries
🚀 Outcome
Developed a complete end-to-end data analytics project demonstrating skills in:
- Database design
- SQL querying
- Data analysis
- Dashboard creation
🔗 Project Link
https://rishabhbhardwaj086.github.io/ecommerce-sales-dashboard/
🙌 Connect
Feel free to connect and share feedback!