Network Fill Rate / YTD KPI Rebuild

Rebuilt KPI logic to correctly handle zero-activity and late-arriving data.

DAXPower BIDim Modeling

Problem

Working with distribution center shipment history, the challenge was to build a system that could rebuilt kpi logic to correctly handle zero-activity and late-arriving data while maintaining reliability and actionable insights for the team.

Approach

Model: Deterministic KPI logic with edge-case handling

System: Power BI semantic model

Results

Accurate reporting across all slices