- BI developer
- Junior
- 30 min
A channel revenue handoff
Build the regional sales handoff with channel as the only dimension and total order revenue as the measure. Keep only complete orders in the assigned region. The assigned region is North.
Skills and rubricA channel revenue handoff
- I group complete orders by channel and sum revenue within the assigned region because the handoff needs channel sales at that population. I check that the channel totals add back to the source revenue for the same region and status.
- I keep customer ID out of the grouping because one customer can place several orders and the requested output has only channel grain. I check that adding an extra dimension would split the channel totals, while order count would measure volume instead of revenue.
- I retain the source records, the saved work and the checked output because another analyst must be able to reproduce this result. I record the observation window and the unresolved limitation. The decision owner approves any exception before this result changes a business action.