SharePoint









Preferred method of contact:

SharePoint 2016 Business Intelligence (55157)

COURSE TYPE

Practitioner

Course Number

8480

Duration

3 Days

View Schedule

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

You Will Learn How To

  • Configure SharePoint sites for business intelligence
  • Configure and use SharePoint Excel Services
  • Configure and use SharePoint Visio Services
  • Configure and use the PowerPivot add-on for SharePoint
  • Configure and use Power View in SharePoint
  • Configure and use the PowerPivot add-on for SharePoint
  • Configure and use the Reporting Services add-on for SharePoint
  • Configure and use PerformancePoint in SharePoint
  • Basics of Power BI and how it fits with SharePoint

Important Course Information

Requirements:

  • Basic knowledge of SharePoint navigation and functionality
  • Basic knowledge of data modeling would be helpful but not required for students in this course

Redeem Your Microsoft SATVs:

Course Outline

  • Module 1: Overview of SharePoint Business Intelligence Services and Features

This module provides an overview of SharePoint Business Intelligence Services and features.

Lessons

  • SharePoint BI Services
  • SharePoint BI Features

After completing this module, students will be able to:

  • Understand what services and features are offered
  • Module 2: Configuring SharePoint Sites for Business Intelligence

This module explains how to configure an existing team site for BI.

Lessons

  • SharePoint Business Intelligence Site Template
  • Configuring an Existing SharePoint Team Site for Business Intelligence

Lab : Configuring SharePoint Team Site for Business Intelligence

  • Configuring SharePoint Team Site for Business Intelligence

After completing this module, students will be able to:

  • Configure an existing SharePoint Team Site for Business Intelligence

  • Module 3: Excel Services in SharePoint

This module explains how to use Excel Services.

Lessons

  • 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 : Configuring Excel Services Farm Options

  • Configuring Excel Services Farm Options

Lab : Refreshing Data with Excel Services

  • Refreshing Data with Excel Services

After completing this module, students will be able to:

  • View Excel sheet with SharePoint Excel Services
  • Use Excel Services Web Part.
  • Configure basic Excel services
  • Refresh data sources
  • Module 4: Visio Services in SharePoint

This module explains how to use Visio Services.

Lessons

  • Configuring Visio Services Farm Settings
  • View Visio Drawings with SharePoint Visio Services
  • Attaching Data to Visio Drawings

Lab : Using SharePoint Visio Services

  • Using SharePoint Visio Services

After completing this module, students will be able to:

  • Configure Visio services
  • View Visio drawings
  • Attach data to drawings
  • Module 5: SharePoint PowerPivot Add-on

This module explains how to work with PowerPivot Models, Farm Settings, and Gallery.

Lessons

  • Overview of PowerPivot Data Models
  • Configuring PowerPivot Farm Settings
  • Creating a PowerPivot Gallery
  • PowerPivot Data Refresh Options

Lab : Configuring PowerPivot for SharePoint

  • Configuring PowerPivot for SharePoint

Lab : Refreshing Data from a PowerPivot Gallery

  • Refreshing Data from a PowerPivot Gallery

After completing this module, students will be able to:

  • Configure PowerPivot Farm settings
  • Create a PowerPivot Gallery
  • Use data refresh options
  • Module 6: SharePoint Power View Feature

This module explains how to work with Power View.

Lessons

  • Overview of Power View in SharePoint
  • Configuring Data Sources for Power View Reports
  • Creating Power View Reports

Lab : Creating a Report with Power View

  • Creating a Report with Power View

After completing this module, students will be able to:

  • Configure data sources
  • Create Power View reports
  • Module 7: SQL Reporting Services Add-on for SharePoint

This module explains how to work with Reporting Services for SharePoint.

Lessons

  • Configuring Reporting Services Farm Settings
  • Configuring a SharePoint Library for Reporting Services Reports
  • Reporting Services Subscriptions and Alerts
  • Report Viewer Web Part

Lab : Adding Reporting Services Reports to a SharePoint Library

  • Adding Reporting Services Reports to a SharePoint Library

Lab : Configuring Subscriptions and Alerts to Reports

  • Configuring Subscriptions and Alerts to Reports

After completing this module, students will be able to:

  • Configure Reporting Services Farm Settings
  • Configure a SharePoint Library
  • Work with subscriptions and alerts
  • Work with Viewer Web Part
  • Module 8: SharePoint PerformancePoint Services

This module explains how to work with PerformancePoint Services.

Lessons

  • 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 : Configuring a SharePoint Site for PerformancePoint

  • Configuring a SharePoint Site for PerformancePoint

Lab : Create a PerformancePoint Dashboard

  • Create a PerformancePoint Dashboard

After completing this module, students will be able to:

  • Configure lists and libraries for PerformancePoint
  • Create a data source.Create a score card and KPI
  • Create PerformancePoint charts and graphs
  • Module 9: Power BI

This module explains how to work with Power BI.

Lessons

  • Overview of Power BI
  • How Power BI fits with SharePoint

Lab : Working with Power BI

  • Working with Power BI

After completing this module, students will be able to:

  • Work with Power BI
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2650   Government: $2355

Aug 9 - 11 (3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 20 - 22 (3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Oct 25 - 27 (3 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Nov 7 - 9 (3 Days)
9:00 AM - 4:30 PM EST
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Dec 13 - 15 (3 Days)
9:00 AM - 4:30 PM EST
Washington, DC Washington, DC Reserve Your Seat

How would you like to attend?

In-Class

Dec 13 - 15 (3 Days)
9:00 AM - 4:30 PM EST
Alexandria, VA / Online (AnyWare) Alexandria, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jan 17 - 19 (3 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Mar 7 - 9 (3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Apr 4 - 6 (3 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

May 9 - 11 (3 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jun 13 - 15 (3 Days)
9:00 AM - 4:30 PM EDT
Washington, DC / Online (AnyWare) Washington, DC / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$2650

Government

$2355

Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français