Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


SharePoint 2010 Business Intelligence

Discover how to build a business intelligence (BI) environment using the Microsoft BI Stack.

GK# 6274 Vendor# M50429

Course Overview


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.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • 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


Viewing outline for:

Virtual Classroom Live Outline

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


Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Business Intelligence Worksheet

Lab 2: Business Intelligence Center

  • Explore Business Intelligence Center
  • Explore Dashboard Designer

Lab 3A: Data and Data Formats

Lab 3B: Build a Data Warehouse

Lab 3C: Extract and Load

Lab 3D: Transform and Load

Lab 3E: Granularity

Lab 3F: Build a Data Mart

Lab 3G: SQL Server to SharePoint Lists

Lab 4A: BCS Basics

Lab 4B: BCS with Data Warehouse

Lab 4C: Office and BCS for BI

Lab 5A: Analysis Services

Lab 5B: Build an Analysis Services Database

Lab 6A: Filter Web Parts

Lab 6B: User Profiles and Filters

Lab 7A: Create an Excel Report

Lab 7B: Excel Services

Lab 7C: MDX

Lab 7D: Sparklines

Lab 7E: Filters and Excel Services

Lab 7F: REST and Web Services

Lab 8A: Install PowerPivot

Lab 8B: Use PowerPivot

Lab 9A: Install Reporting Services

Lab 9B: Build Reports with Reporting Services

Lab 9C: Create Advanced Reporting Services Report and Filter Web Parts and Reports

Lab 9D: Reporting Services and PowerPivot

Lab 10: Performance Point

Lab 11A: Visio Services

Lab 11B: Access Services

Lab 12A: GeoSpatial Data with SQL Server

Lab 12B: Bing Maps

Lab 12C: .NET Charts

Lab 12D: Google Maps


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

Who Should Attend


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

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.