Finishing up

Even though Pam has finished building her report, she still needs to test the report and clean up some loose ends.

In the following subsections, we will perform some final testing and cleanup on the report to ensure that everything works correctly and that the report is ready for business users to consume.

Testing

Pam decides to work through an example scenario to see how the report performs. To perform this test, do the following:

1. Start on the Executive Summary page. Here, we can see that the overall utilization is good and above our goal. All of the branches are above our target utilization. However, one Division, in particular, is noticeably below the average. This is the 3001 Management division. Let's investigate this Division further to see what is driving down utilization.
2. In the % Utilization by Division visual, right-click on the 3001 Management bar and choose Drill through and then Division Management. Checking the green dynamic title...