Microsoft Office Tutorials and References
In Depth Information
the latest adventureWorks sample database from Codeplex has sales data from year 2005 to 2008. We will
use these date ranges in our examples.
The rest of the page is separated into zones, similar to the web part zones used in SharePoint pages.
The difference is that dashboard zones can be added, modified, and removed from a dashboard page after it is
created. These zones allow dashboard components—including filters, scorecards, and reports—to be stacked and
connected in the same way web parts can be manipulated on a web part page. Figure 6-4 highlights the zones and
direction (vertical vs. horizontal) of the default dashboard page layout.
Figure 6-4. Default dashboard zones
The BI components that make up the page are assembled, arranged, and connected using the Dashboard
Designer. When the dashboard is deployed to SharePoint, the various object definitions control the page’s behavior.
A common pattern, as shown in Figure 6-4 , is to place visible filters in the header zone of the page and then to fill the
other zones with scorecards and reports as needed.
The connections created between components allow them to act together. For example, when the user changes
the Date filter on the sample dashboard, each of the scorecards and reports on the page are updated to reflect data
only from those periods. When a row is selected in the scorecard shown on the left, the data on the reports in the right
column are filtered to match. We will be creating this dashboard and its connections later in this chapter.
Indicators and Key Performance Indicators
A Key Performance Indicator is a definition of business-relevant measurements (or “metrics”) used to display
easy-to-understand conditions as shown in Figure 6-5 .
Search JabSto ::

Custom Search