All work
Business Intelligence
Bookings and Shipments Cancellation
A Power BI report analyzing bookings and shipments cancellations, built from scratch with a documented data model and DAX measures.
Business problem
Cancellations were recorded as individual events with no easy way to see volume, timing or causes across bookings and shipments.
Solution
- Built a Power BI report from scratch that breaks cancellations down by pattern, making recurring issues visible.
- Created the data model, DAX measures and business logic from scratch, and documented all of it.
Measurable impact
Patterns
Cancellation behavior measurable, not anecdotal
What changed for the team
- Cancellation volume, timing and causes became visible as patterns, not as isolated events.
- The team could identify which cancellations recurred and act on the biggest drivers instead of reacting case by case.
- Reviews of cancellations shifted from anecdote to evidence, because every number traced back to one documented model.
Technical implementation
- Power BI data model designed from scratch across bookings and shipments.
- DAX measures for cancellation volume and timing centralized in the model.
- Model, measures and logic fully documented.
- Power BI
- DAX
- Data Modeling
- Power Query
Source
Have a data problem that's taking too much time?
Whether it's a manual reporting process, disconnected data or an analytics bottleneck, I build systems that turn that complexity into something useful.