Continuing with the example scenario we introduced in Chapter 3, Connecting and Shaping Data, Pam takes a moment to contemplate the various groups of individuals within the company that the final Utilization report will serve.

The main groups include the following:

• C-level executives
• Division managers
• Branch managers

Each group is interested in Utilization but in slightly different ways. The C-level executives simply want a quick summary of the utilization numbers, whether it is meeting the desired goals, how utilization is trending, and so on. Division managers, on the other hand, will likely want to drill a little bit deeper and understand how utilization looks on individual projects and who the top and bottom individual contributors on those projects are. Branch managers will be interested in the same sort of information as division managers but only within their individual locations.

Pam decides that her final report will include six pages:

• Executive Summary: A page summarizing the information at a high level, including relevant trends
• Division Management: A summary page focused on division managers
• Branch Management: A summary page focused on branch managers
• Hours Detail: A page that includes a detailed hours breakdown
• Employee Details: A page focused on breaking down the utilization of particular employees
• Introduction: An introduction to the report and how to use it