SharePoint 2010 Business Intelligence Training

Module 1: Overview

Module 2: Business Intelligence

Lessons

- Business Intelligence

Lab : Business Intelligence Worksheet

- Answer Business Intelligence Questions

Module 3: Business Intelligence Center

Lessons

- Business Intelligence Center

Lab : Business Intelligence Center

- Explore SharePoint Business Intelligence Center

- Explore Dashboard Designer

Module 4: Data Mart and Data Warehouses

Lessons

- Understanding Data and Data Formats

- Building Data Marts and Data Warehouses

Lab : Data and Data Formats

- Explore Data Formats

Lab : Build A Data Warehouse

- Create a Simple Data Warehouse

Lab : Extract and Load

- Explore the Extract stage

Lab : Transform and Load

- Explore Transform and Load stages

- Realize the importance of primary/unique keys

Lab : Granularity

- Create Data Warehouse Granularity Levels

Lab : Build A Data Mart

- Create a Data Mart

Lab : SQL Server to SharePoint Lists

- Populate a SharePoint List with SQL Server data

After completing this module, students will be able to:

- Differentiate between multiple data formats

- Understand differences between data warehouse and data marts

- Be able to describe what happens in an Extract, Transform and Load (ETL) process

Module 5: Business Connectivity Services

Lessons

- Business Connectivity Services

Lab : BCS Basics

- Explore External Content Types

- Create a new External Content Type

- Create an External List

Lab : BCS With Data Warehouse

- Create an Large External List using ECTs

- Using Filters and External lists

- Creating and Configuring Entity Profile Pages

Lab : Office and BCS for BI

- Explore Office and BCS Integration

After completing this module, students will be able to:

- Understand how BCS works

- How to build new BCS applications

- How to Upgrade your older BDC applications

Module 6: Analysis Services

Lessons

- Analysis Services

Lab : Analysis Services

- Create Dimension and Fact tables with SSIS

Lab : Building An Analysis Services Database

- Create a Analysis Services Database

- Create a Cube

- Create Dimensions

- Create Fact Tables

- Create a KPI

After completing this module, students will be able to:

- Describe OLAP terms

- Understand how to navigate Analysis Services

- How to build a simple cube

- How to write simple MDX queries

- How to use data mining models

Module 7: Filter Web Parts

Lessons

- Filter Web Parts

Lab : Filter Web Parts

- Use each of the Filter Web Parts

Lab : UserProfiles and Filters

- Integrate User Profiles with Filters and Reports

After completing this module, students will be able to:

- Describe what Filter Web Parts are

- Work with Filter Web Parts

- Understand how to integrate Filter Web Parts into other BI technologies

Module 8: Excel Services

Lessons

- Excel Services

Lab : Create An Excel Report

- Create An Excel Report

Lab : Excel Services

- Learn to use Excel Services

- Create/Publish to Excel Services

- Configure Excel Services

- Shared Data Connections

Lab : MDX

- Explore Excel 2010 MDX features

- Create a Slicer

- Create an MDX Set

Lab : Sparklines

- Use Excel 2010 Sparklines

Lab : Filters and Excel Services

- Explore Filter Web Parts and Excel Services

Lab : REST and Web Services

- Explore REST features of Excel ServicesExplore the Excel Services Web Service

Module 9: PowerPivot

Lessons

- PowerPivot For SharePoint

- PowerPivot For Excel

Lab : Install Power Pivot

- Install PowerPivot for Excel

- Install PowerPivot for SharePoint 2010

- Configure PowerPivot for SharePoint

Lab : Use PowerPivot

- Explore PowerPivot Functions

- Use Basic PowerPivot

- Use PowerPivot with Large DataSets

- Create PowerPivot Linked Tables

- Publish to SharePoint

- Automating Data Refresh

- Analyzing Usage Data

Module 10: Reporting Services

Lessons

- Reporting Services

- Reports

Lab : Install Reporting Services

- Configure Reporting Services

- Create a Reporting Services Report

- Configure Reporting Services Web Part

Lab : Building Reports with Reporting Services

- Create Advanced Reporting Services report

- Filter Web Parts and Reports

Lab : Automating Reports with Reporting Services

- Create Report Part Gallery

- Create a Report Library

- Create Report Parts

- Create a Report using Report Parts

- Automated Report Delivery

Lab : Reporting Services and PowerPivot

- Setup Reporting Services RSS Feed

- Create and Use Data Feed Library

- Utilize Reporting Services data in PowerPivot

- Utilize PowerPivot data in Reporting Services

Module 11: Performance Point

Lessons

- Performance Point

Lab : Performance Point

- Explore Performance Service Application

- Explore the Dashboard Designer

- Create A Scorecard

- Create A PP KPI

- Explore Time Intelligence

- Create Performance Point Reports

- Create Filters

- Create A Dashboard

Module 12: Visio and Access Services

Lessons

- Visio Services

- Access Services

Lab : Visio Services

- Use Visio Services

- Publish a Visio to SharePoint

- Tie report process to Visio

Lab : Access Services

- Explore Access Services

- Publish Access Database To SharePoint

Module 13: GeoSpatial Data with Charts and Maps

Lessons

- Charts and Maps

- GeoSpatial Data

Lab : GeoSpatial Data with SQL Server

- Populate a SQL Server Database using Shape2SQL

- Utilize the new Spatial Data Types in SQL Server

- Create a Reporting Services Report using Geospatial Data

- Publish Geospatial Data to SharePoint 2010

Lab : Bing Maps

- Utilize Bing Maps API

- Create a Simple Map With Content Editor Web Part

- Create an Advanced Map with Data Views

- Explore Filters, Data Views and Bing Maps integration

- Integrate Geospatial Customer data into SharePoint Sites

Lab : NET Charts

- Utilize NET Charts