📊 Operations Dashboard: Weekly Business Review (WBR)

A centralized repository for tracking operational health, supply chain efficiency, and cross-functional performance metrics during the Weekly Business Review (WBR). This framework connects raw telemetry and warehouse logs into tactical dashboards to help teams identify bottlenecks, manage SLA breaches, and balance labor utilization.

---

📌 Core Tracking Vertices

• Fulfillment Metrics: Monitoring Order-to-Delivery (OTD) loops, Pick-and-Pack accuracy, and courier SLA compliance (e.g., quick-commerce vs. standard D2C).
• Inventory Health & Warehousing: Real-time visibility into SKU velocity, stockout risks, safety stock flags, and warehouse spatial capacity utilization.
• Customer Experience (CX) Operations: Tracking First Response Time (FRT), ticket resolution cycles, and refund/return logistics processing times.
• Unit Economics (Ops-Level): Evaluating dynamic cost-per-delivery, packaging overhead variations, and return-to-origin (RTO) financial waste.

---

📁 Repository Structure

├── pipelines/          # ETL scripts extracting data from warehouse & logistics APIs
├── sql-queries/        # Production-ready SQL for weekly cohort & cohort SLA analysis
├── dynamic-sheets/     # Weekly template models for manual input reconciliation
└── README.md           # Dashboard operational manual