- End-to-End SQL Database Design
- Analytical SQL Views
- Executive KPI Dashboard
- Delivery Operations Analytics
- Inventory Intelligence Monitoring
- DAX Measures for Business KPIs
- Interactive Slicers and Filters
A complete business intelligence solution for quick-commerce operations in Coimbatore. This project simulates a dark-store based delivery network similar to Blinkit, Zepto, and Instamart using MySQL and Power BI.
The platform enables monitoring of:
- Revenue and Orders
- Delivery Performance
- Customer Satisfaction
- Inventory Health
- Store Performance
- Operational KPIs
- MySQL
- SQL
- Power BI
- DAX
- Areas
- Customers
- Orders
- Order Items
- Products
- Inventory
- Dark Stores
- Delivery Partners
- Deliveries
- Customer Ratings
- Traffic Conditions
- Weather Impact
- vw_order_summary
- vw_delivery_performance
- vw_inventory_status
- vw_customer_satisfaction
- vw_store_performance
Provides:
- Total Revenue
- Total Orders
- Average Order Value
- Customer Rating
- Revenue by Store
- Orders by Area
- Delivery Status Distribution
Provides:
- Average Delivery Time
- Total Deliveries
- Average Distance
- Active Delivery Partners
- Partner Performance
- Area Performance
- Delivery Status Analysis
Provides:
- Total Products
- Average Stock Available
- Critical Stock Items
- Inventory Health Distribution
- Inventory by Store
- Reorder Risk Analysis
QuickCommerce-Analytics/
│
├── database/
├── views/
├── dashboards/
├── screenshots/
└── documentation/
This solution helps:
- Monitor operational efficiency
- Track delivery performance
- Improve customer satisfaction
- Reduce stockout risks
- Support data-driven decision making
Kowsekhan K R