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.

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

Who Needs to Attend

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

Follow-On Courses

There are no follow-ons for this course.

Course 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

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 and 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