Microsoft Learning Logo is a registered trademark of Microsoft. All rights reserved.

SharePoint 2016 Business Intelligence

Schedule

Start End Duration Location Details

Course Details

SharePoint 2016 Business Intelligence

Course code: 55157

Duration: 3 Days

Prerequisites: 

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

Course Description:

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

Intended Audience:

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 Outlines:

Module 1: Overview of SharePoint Business Intelligence Services and Features

•    SharePoint BI Services
•    SharePoint BI Features

Module 2: Configuring SharePoint Sites for Business Intelligence

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

Module 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

Module 4: Visio Services in SharePoint

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

Module 5: SharePoint PowerPivot Add-on
•    Overview of PowerPivot Data Models
•    Configuring PowerPivot Farm Settings
•    Creating a PowerPivot Gallery
•    PowerPivot Data Refresh Options

Module 6: SharePoint Power View Feature

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

    Module 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

Module 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

Module 9: Power BI

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