Consulting Training Blog Careers About Us Contact Us
All Classes Will Be Held Virtually – Live Online Intertech's Training Division has been successfully instructing professionals through virtual live online training since the advent of the smartboard. It is a proven form and offers the convenience of live questions, group interaction, and labs with an instructor looking over your shoulder. Because of this, we will continue all classes live but virtually, including Agile and Scrum instruction, so businesses and individual’s seeking professional development can keep moving forward during these unexpected times.

SharePoint 2016 Business Intelligence Training

Upcoming Classes

Click the Get Notified button for priority notification when a class is next scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us


This course covers the services and features in SharePoint that offer support for Business Intelligence scenarios.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Learning Objectives

•Learn to configure SharePoint sites for business intelligence
•Learn to configure and use SharePoint Excel Services
•Learn to configure and use SharePoint Visio Services
•Learn to configure and use the PowerPivot add-on for SharePoint
•Learn to configure and use Power View in SharePoint
•Lean to configure and use the PowerPivot add-on for SharePoint
•Learn to configure and use the Reporting Services add-on for SharePoint
•Learn to configure and use PerformancePoint in SharePoint
•Learn the basics of Power BI and how it fits with SharePoint


This course is intended for information workers and business intelligence analysists who have a minimum of three months experience using SharePoint sites, lists, and libraries and have basic Web navigation skills.

Course Outline

1 - Overview of SharePoint Business Intelligence Services and Features

  • SharePoint BI Services
  • SharePoint BI Features

2 - Configuring SharePoint Sites for Business Intelligence

  • SharePoint Business Intelligence Site Template
  • Configuring an Existing SharePoint Team Site for Business Intelligence
  • Lab 1: Configuring SharePoint Team Site for Business Intelligence

3 - Excel Services in SharePoint 

  • Viewing Excel Spreadsheets with SharePoint Excel Services
  • Using SharePoint Excel Services Web Part
  • Basic Excel Services Farm Configuration Options
  • Refreshing Data Sources with SharePoint Excel Services
  • Lab 1: Configuring Excel Services Farm Options
  • Lab 2: Refreshing Data with Excel Services

4 - Visio Services in SharePoint

  • Configuring Visio Services Farm Settings
  • View Visio Drawings with SharePoint Visio Services
  • Attaching Data to Visio Drawings
  • Lab 1: Using SharePoint Visio Services

5 - SharePoint PowerPivot Add-on

  • Overview of PowerPivot Data Models
  • Configuring PowerPivot Farm Settings
  • Creating a PowerPivot Gallery
  • PowerPivot Data Refresh Options
  • Lab 1: Configuring PowerPivot for SharePoint
  • Lab 2: Refreshing Data from a PowerPivot Gallery

6 - SharePoint Power View Feature

  • Overview of Power View in SharePoint
  • Configuring Data Sources for Power View Reports
  • Creating Power View Reports
  • Lab 1: Creating a Report with Power View

7 - SQL Reporting Services Add-on for SharePoint

  • Configuring Reporting Services Farm Settings
  • Configuring a SharePoint Library for Reporting Services Reports
  • Reporting Services Subscriptions and Alerts
  • Report Viewer Web Part
  • Lab 1: Adding Reporting Services Reports to a SharePoint Library
  • Lab 2: Configuring Subscriptions and Alerts to Reports

8 - SharePoint PerformancePoint Services

  • Overview of PerformancePoint Services
  • Configuring SharePoint Lists and Libraries for PerformancePoint
  • Creating a Data Source
  • Creating a Score Card and KPI
  • Creating PerformancePoint Charts and Graphs
  • Creating PerformancePoint Dashboards
  • Lab 1: Configuring a SharePoint Site for PerformancePoint
  • Lab 2: Create a PerformancePoint Dashboard

9 - Power BI

  • Overview of Power BI
  • How Power BI fits with SharePoint
  • Lab 1: Working with Power BI
Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Free Resources from Intertech

.NET Technology Guide for Business Applications

Free Whitepaper: Explore SharePoint 2013

Free Guide: SharePoint 2013 Deployment