Microsoft Office Tutorials and References
In Depth Information
Because you hooked up the filter Web Part to the same Date dimension in Analysis Services, the filter
part passes a fully qualified member name to the report filter in the workbook.
You now know how you can use Excel and Office SharePoint Server with Excel Services to create a
complete BI dashboard. By combining the various filter Web Parts that are shipped with Office SharePoint
Server together with different views into Excel workbooks on the same dashboard page, you can create
very powerful BI solutions.
Excel is often used as a BI tool. Excel Services and the rest of Office SharePoint Server’s functionality
enable you to extend your BI applications to the server, and provide report portals and dashboards that
contain reports and analysis authored in Excel. You can do this using the out-of-the-box BI portal template,
or by embedding the functionality directly within existing sites and Web applications built on Office
In this chapter, you learned about the following:
The Report Center
Building and using dashboards
Building BI solutions outside of the Report Center
Integrating with SQL Server Analysis Services
The next scenario you explore is using Excel Services to offload calculations from Excel client. Chapter 13
discusses how to set up the server and use it for this scenario.