Analysis of the expenses dashboard display
The Expenses dashboard is another four-quadrant dashboard with a Pivot Table on the upper right-hand side, surrounded by three graphs analyzing essentially the same data in different formats. The pivot table is organized by the Cost Center group and reports in thousands, as the title clearly states. It is well-organized with fairly standard income-expense statement section type columns. Therefore, we can see the 2011 expenses as compared to the budget and the previous year, with the variance in both dollars and percentages. The unfavorable variances are the positive numbers shown in red; those columns must be formatted in Properties so that the text for those numbers is set to red when the value is greater than zero. This is just the opposite of the setting used in the previous chapter covering the Order Details tab. My preference would be to only have the pivot table and to have more detailed information loaded so that we can drill-down on the...