Project Roadmap

Phase What it covers Status
Business Context & Problem Scope Analytics Project Charter, NCG Order Lifecycle Complete
KPI Framework Tier 1 KPIs, Tier 2 KPIs, KPI Catalog Register, KPI definitions, data sources and fields Complete
Data Architecture Operational data model, KPI fact table design, Dimension tables Complete
Data Generation Mock data design, SQL table creation Complete
KPI SQL Logic Spine builds, OTIF derivation, cost and lead time In Progress
Diagnostic Analysis Python, variance analysis Upcoming
Executive Reporting KPI views, Power BI dashboard Upcoming

Phase 1: Problem Framing & KPI Design

1.1. Analytics Project Charter

Business Context, Operating Model, Scope Boundaries, and my Analytical Mandate

1.2. NCG Order Lifecycle (Downstream Execution)

Order Created → ATP → Order Confirmed → Order Released → Order Shipped → Order Delivered

1.3. Key Business Decisions This Analysis Must Support

  1. Which downstream operational area is the primary driver of OTIF reduction?
  2. Is the increase in logistics cost driven by downstream execution, and which function contributes most?
  3. Is declining OTIF/service level materially impacting profit margins, and by how much?

Phase 2: KPI Framework

2.1. Tier-1 Executive KPIs

1. OTIF (On-Time In-Full)

Measures the percentage of customer orders delivered on time and in full against the committed promise date - (customer centric)

Answers → Whether downstream execution is failing customers and where service is breaking down

Component Included Reason
Released On Time No Internal warehouse SLA. Late release that still delivers on time does not impact the customer. Diagnostic value captured in Release spine separately.
Released In Full Yes release_qty = 0 means the line never ships. Customer cannot receive full quantity. Root cause of downstream In Full failures.
Shipped On Time No Internal execution risk. If shipment arrives on time despite late ship date, customer is not impacted. Diagnostic value captured in Shipment spine separately.
Shipped In Full Yes Pick/pack shortfall flows directly to customer. Delivered In Full captures loss and damage but not quantity shortfalls from picking.
Delivered On Time Yes Core customer-facing OTIF component.
Delivered In Full Yes Core customer-facing OTIF component.