Microsoft Office Tutorials and References
In Depth Information
Microsoft Office SharePoint Server
a regional sales manager can have a dashboard page that displays the latest sales numbers, current
customer support escalations, the target sales for the period, and a list of current leads.
Office SharePoint Server supports building such BI dashboards based on the core Web Part Pages
capabilities described earlier. In addition, it provides features that target common BI dashboard needs and
makes it easy to create such dashboards.
To create a BI dashboard, you use the dashboard page template, which guides you through a wizard-like
setup process. For example, you can choose the default parts to include in the dashboard and additional
customization options. When you are finished with the setup, you are presented with the dashboard page,
and can then continue to assemble it by configuring the content to display in the dashboard.
Another core feature of BI dashboards in Office SharePoint Server is a set of filters that enable you to
connect all the content on the dashboard. This is done by filtering the different elements of the
dashboard together. For example, the sales dashboard described earlier can include filters for the product
line and for the sales region. The sales manager viewing the dashboard can select a region and all the
various parts of the dashboard (such as the latest sales numbers or support escalations) will show the
data for only that region.
Office SharePoint Server includes several filters out-of-the-box, and more can be added
programmatically. The out-of-the-box filters include those that support filtering based on an authored list of values,
values that come from a database query, data based filtering, and others. Figure 1-10 shows an example
of such a dashboard.