SharePoint 2010 Business Intelligence



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.

Global Knowledge Exclusive!

Continue developing your skills after class with 24/7 access to our live remote labs for six months, providing you with valuable extra time for hands-on practice.


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

Learning Objectives

  • Business Intelligence Center
  • Data formats, building data marts and data warehouses, and ETL process
  • Business Connectivity Services (BCS)
  • Microsoft SQL Server Analysis Services (SSAS) and filtering Web Parts
  • Excel Services, PowerPivot, Reporting Services, Performance Point, Visio, and Access Services

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