We now have a workable data model that contains all of the raw data that we will need to report on utilization. Recall that, at the beginning of Chapter 3, Connecting and Shaping Data, with the rollout of unlimited PTO, it is imperative that employee utilization be tracked closely.

Utilization in this context is a calculation that involves the ratio of billable time versus the total time (billable and non-billable). From experience, the organization knows that, in order to remain profitable, the target utilization must be 80%. Therefore, we must create this calculation.