Microsoft considers SharePoint 2007 as key software for delivering enterprise level business solutions. In this module, students will learn various built-in components that are available for business users as part of the BI toolset.
- Overview of Sharepoint BI offering
- Create Report Center site
- Review of Report Center elements
- Create a dashboard page
Excel Services of SharePoint 2007 provides a powerful server side platform for business users to collaborate Excel workbooks. Students will learn how to use Excel Services to publish excel workbooks within their organization.
- Overview of Excel Services
- Creating an Office Data Connection (ODC) using Excel 2007
- Configuring a Data Connection Library (DCL)
- Setting up a trusted location for Excel workbooks
- Creating Graphical Dashboard using Excel Services
The Sharepoint 2007 report center template has a built-in list to host Key Performance Indicators (KPIs). In this module, students will learn how to build SharePoint based Key Performance Indicators (KPIs) based on various data sources like Excel and Analysis Service Cube.
- Building KPIs based on Excel Services workbook
- Building KPIs based on Analysis Services
- Building KPIs based on SharePoint list
- Using KPIs webpart to display KPIs on a dashboard page
Reporting Services, a key report authoring tool in Microsoft’s BI stack has a unique feature which allows business users to author reports based on report models created by IT departments. Students will learn how to user Report Builder to author reports based on reporting models in this module.
- Datawarehouse concepts (dimensions, measures and hierarchy)
- Overview of Report Builder
- Designing a table report
- Designing a matrix report
- Create parameters for report
- Adding multiple regions to reports
- Designing reports with charts
- Publishing reports to SharePoint Report Library
- Using published reports in a aashboard page
Student will learn in this module PerformancePoint Web Part and using the web part in dashboard pages as part of dashboard solution.
- Overview of Performancepoint features including KPI, Scorecard, Analytical Chart
- Review of Dashboard deployment and integration with SharePoint
- Adding PerformacePoint Web Part to Dashboard
- Adding PerformancePoint filter to Dashboard
This module covers built-in SharePoint filter web parts that can be used on the Dashboard page and how to connect them to other webparts on the page to build interactive dashboard solutions.
- Creating filter web parts based on Excel Services Workbook
- Creating filter web parts based on SharePoint List
- Creating filter web parts based on Analysis Server Cube
- Connecting filter web parts to other web parts on Dashboard