Neha G's Work | ContraWork by Neha GNeha G
Data & BI Analyst specializing in custom Power BI dashboard
Zepto Operations & Delivery Analytics Dashboard
In the quick-commerce industry, delivery speed and SLA compliance drive customer satisfaction. To give operations teams clear visibility into delivery bottlenecks, category margins, and dark store performance, I built this end-to-end operational dashboard in Power BI.
Check out the short video demo to see the interactive visuals in action.
Key Features Demonstrated:
Executive KPI Suite: Real-time visibility into Total Revenue, Total Profit, Average Delivery Time, and High-Risk Order Flags.
Dark Store & Category Performance: Evaluating profit drivers (Meat & Seafood vs. Fresh Produce) paired with dark store comparison tables formatted with embedded teal data bars.
AI-Powered Root Cause Diagnostics: Interactive Decomposition Tree with dynamic color gradients to drill down into delivery delays (Late <5m, Severely Delayed) across product categories, dark store IDs (DS_BLR_01, DS_MUM_02), and delivery distances.
Tech Stack & Analytical Skills:
Tool: Power BI Desktop
Data & Modeling: DAX (Custom Measures & KPI Logic), Power Query, Data Modeling
Design & UX: Interactive Root Cause Analysis, Custom Palette (Zepto Brand Theme), Conditional Formatting Gradients
Business Impact: Helps regional operations managers proactively reallocate delivery fleets and optimize dark store packing workflows during peak demand hours. 
