SharePoint 2010 Business Intelligence

Senior BI architects and consultants, senior business analysts, and those responsible for implementing BI with SharePoint


  • Knowledge of SharePoint 2010 user interface
  • Understanding of database reporting concepts
  • Familiarity with data marts and data warehouses

Expected Duration
5 day


In this course, you will learn how to build a BI environment from scratch to full interactive dashboards using the Microsoft BI stack. You will learn to implement BI strategies using SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point, and PowerPivot.

This course incorporates material from the Official Microsoft Learning Product 50429: Sharepoint 2010 Business Intelligence.


1. Business Intelligence

  • What P=R-C means to BI
  • Accept that empowering end users is a good thing
  • BI will only be as good as your data, tools, and processes

2. Business Intelligence Center

  • SharePoint Business Intelligence Center
  • Dashboard Designer

3. Data Mart and Data Warehouses

  • Data and data formats
  • Building data marts and data warehouses

4. Business Connectivity Services

5. Analysis Services

6. Filter Web Parts

7. Excel Services

8. PowerPivot for SharePoint and Excel

9. Reporting Services and Reports

10. Performance Point

11. Visio and Access Services

12. GeoSpatial Data with SQL Server

  • Charts and maps
  • GeoSpatial data



Select Course Options