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.

Overview

  • 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

Target Audience

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

Prerequisites

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

Expected Duration

5 day

Course Objectives

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

Labs

SUBSCRIPTION COST


$2,995.00

 

NEED HELP OR NOT SURE?