Modules

Module 1: SharePoint BI Services and Features

This module provides an overview of SharePoint Business Intelligence (BI) services and features.

Lessons
• SharePoint BI Services
• SharePoint BI Features

Lab 1: None
• None

After completing this module, students will be able to:
• Understand the available BI services and features in SharePoint.

Module 2: Configuring SharePoint Sites for Business Intelligence

This module explains how to set up an existing SharePoint team site for Business Intelligence.

Lessons
• SharePoint BI Site Template
• Setting Up a SharePoint Team Site for BI

Lab 1: Configuring SharePoint Team Site for BI
• Set up a SharePoint Team Site for Business Intelligence

After completing this module, students will be able to:
• Configure a SharePoint Team Site for Business Intelligence.

Module 3: Excel Services in SharePoint

This module covers how to use Excel Services in SharePoint.

Lessons
• Viewing Excel Workbooks with Excel Services
• Using the Excel Services Web Part
• Basic Excel Services Farm Configuration
• Refreshing Data Sources in Excel Services

Lab 1: Configuring Excel Services Farm Options
• Configure Excel Services Farm Settings

Lab 2: Refreshing Data with Excel Services
• Refresh Excel Data in SharePoint

After completing this module, students will be able to:
• View Excel workbooks using Excel Services
• Use the Excel Services Web Part
• Configure basic Excel Services settings
• Refresh data sources

Module 4: Visio Services in SharePoint

This module demonstrates how to use Visio Services in SharePoint.

Lessons
• Configuring Visio Services Farm Settings
• Viewing Visio Diagrams in SharePoint
• Linking Data to Visio Drawings

Lab 1: Using SharePoint Visio Services
• Use Visio Services in SharePoint

After completing this module, students will be able to:
• Configure Visio Services
• View Visio diagrams
• Link data to Visio drawings

Module 5: SharePoint PowerPivot Add-on

This module explains how to work with PowerPivot models, settings, and galleries.

Lessons
• Introduction to PowerPivot Data Models
• Configuring PowerPivot Farm Settings
• Creating a PowerPivot Gallery
• PowerPivot Data Refresh Options

Lab 1: Configuring PowerPivot for SharePoint
• Set up PowerPivot in SharePoint

Lab 2: Refreshing Data from a PowerPivot Gallery
• Refresh Data from the PowerPivot Gallery

After completing this module, students will be able to:
• Configure PowerPivot Farm settings
• Create a PowerPivot Gallery
• Use PowerPivot data refresh options

Module 6: SharePoint Power View Feature

This module explains how to use Power View within SharePoint.

Lessons
• Introduction to Power View in SharePoint
• Setting Up Data Sources for Power View Reports
• Creating Power View Reports

Lab 1: Creating a Report with Power View
• Build a Power View Report

After completing this module, students will be able to:
• Configure data sources for Power View
• Create Power View reports

Module 7: SQL Reporting Services Add-on for SharePoint

This module covers how to use Reporting Services within SharePoint.

Lessons
• Configuring Reporting Services Farm Settings
• Setting Up a SharePoint Library for Reports
• Using Subscriptions and Alerts
• Working with the Report Viewer Web Part

Lab 1: Adding Reports to a SharePoint Library
• Add Reporting Services Reports to a SharePoint Library

Lab 2: Configuring Subscriptions and Alerts
• Set up Subscriptions and Alerts for Reports

After completing this module, students will be able to:
• Configure Reporting Services Farm settings
• Configure a SharePoint library for reports
• Use subscriptions and alerts
• Work with the Report Viewer Web Part

Module 8: SharePoint PerformancePoint Services

This module introduces PerformancePoint Services in SharePoint.

Lessons
• Overview of PerformancePoint Services
• Preparing SharePoint Lists and Libraries for PerformancePoint
• Creating a Data Source
• Creating a Scorecard and KPI
• Building PerformancePoint Charts and Graphs
• Designing PerformancePoint Dashboards

Lab 1: Configuring a SharePoint Site for PerformancePoint
• Set up a SharePoint Site for PerformancePoint

Lab 2: Creating a PerformancePoint Dashboard
• Create a PerformancePoint Dashboard

After completing this module, students will be able to:
• Set up lists and libraries for PerformancePoint
• Create data sources
• Design scorecards and KPIs
• Build PerformancePoint charts and dashboards

Module 9: Power BI

This module introduces Power BI and its integration with SharePoint.

Lessons
• Overview of Power BI
• How Power BI Integrates with SharePoint

Lab 1: Working with Power BI
• Use Power BI with SharePoint

After completing this module, students will be able to:
• Work with Power BI in the context of SharePoint