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