55157 SharePoint 2016 Business Intelligence

Price
$1,785.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

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

Course 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 Learn 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

Who Should Attend?

This course is intended for information workers and business intelligence analysts who have a minimum of three months experience using SharePoint sites, lists, and libraries and have basic Web navigation skills.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

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

Agenda

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.

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.

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.

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.

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.

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.

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.

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.

9 - Power BI

  • This module explains how 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
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with New Horizons