55157 SharePoint 2016 Business Intelligence

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

Overview

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

Prerequisites

Participants who wish to attend this course should meet the following prerequisites:

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

Who Should Attend?

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

Course Outline

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

Lab: Configuring SharePoint Team Site for Business Intelligence

  • Viewing Excel Spreadsheets with SharePoint Excel Services
  • Using SharePoint Excel Services Web Part
  • Basic Excel Services Farm Configuration Options

Lab: Configuring Excel Services Farm Options
Lab: Refreshing Data with Excel Services

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

Lab: Using SharePoint Visio Services

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

Lab: Configuring PowerPivot for SharePoint
Lab: Refreshing Data from PowerPivot Gallery

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

Lab: Creating a Report with Power View

  • 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
Lab: Configuring Subscription and Alerts to Reports

  • 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
Lab: Create a PerformancePoint Dashboard

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

Lab: Working with Power BI

Get Pricing and Brochure

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Get in touch with our consultant