📊 Dashboard Visuals
Full dashboard overview showing all KPIs and insights.
Subscription insights
Category sales breakdown
Revenue insights
📊 Key Insights (Business Impact)
💰 Clothing category generates the highest revenue, making it the primary revenue driver
⭐ Average rating (3.75) suggests scope for improving customer satisfaction
🔁 Only 27% customers are subscribed, highlighting a major growth opportunity
🚚 Shipping preferences vary, suggesting potential for personalized delivery strategies
📈 Dashboard Features
Interactive filters (Subscription Status, Gender, Category, Shipping Type)
Category-wise sales and revenue breakdown
Customer segmentation insights
KPI cards for quick business understanding
🔍 Data Workflow
🧹 Data Cleaning (Python)
Handled missing values (e.g., review ratings)
Replaced null values using median
Standardized column names
🔄 Feature Engineering
Created new features:
age_group
purchase_frequency_days
🗄️ SQL Analysis
Revenue by gender
Customer segmentation
High-spending customers
Product performance
🚀 Future Improvements
Integrate SQL pipeline directly with Power BI
Add machine learning models for prediction
Enhance dashboard interactivity and UX
📚 Key Learnings
End-to-end data analytics workflow
Data cleaning using Pandas
Writing optimized SQL queries
Building business-focused dashboards
⭐ Why This Project Stands Out
✔ End-to-end analytics pipeline
✔ Real-world business insights
✔ Strong dashboard design
✔ Focus on decision-making impact