LateStartHours => ComplianceDisclaimer => OnDemand =>

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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Aug 9 - 11 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Sep 20 - 22 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Oct 25 - 27 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Nov 7 - 9 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Dec 13 - 15 Washington, DC Enroll Now

How would you like to attend?

In-Class

Dec 13 - 15 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Jan 17 - 19 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Mar 7 - 9 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Apr 4 - 6 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

May 9 - 11 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2650

Government

$2355

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

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

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

Please Choose a Language

Canada - English

Canada - Français