SharePoint 2013 Business Intelligence Training (SBI2013)
Course Length: 3 days
Delivery Methods:
Available as private class only
Course Overview
This SharePoint 2013 Business Intelligence training class covers the services and features in SharePoint that offer support for Business Intelligence scenarios.
Course Benefits
- 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
Course Outline
- Overview of SharePoint Business Intelligence Services and Features
- SharePoint BI Services
- SharePoint BI Features
- Configuring SharePoint Sites for Business Intelligence
- SharePoint Business Intelligence Site Template
- Configuring an Existing SharePoint Team Site for Business Intelligence
- Lab: Configuring SharePoint Team Site for Business Intelligence
- 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
- Lab: Configuring Excel Services Farm Options
- Lab: Refreshing Data with Excel Services
- Visio Services in SharePoint
- Configuring Visio Services Farm Settings
- View Visio Drawings with SharePoint Visio Services
- Attaching Data to Visio Drawings
- Lab: Using SharePoint Visio Services
- SharePoint PowerPivot Add-on
- 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 a PowerPivot Gallery
- SharePoint Power View Feature
- Overview of Power View in SharePoint
- Configuring Data Sources for Power View Reports
- Creating Power View Reports
- Lab: Creating a Report with Power View
- 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
- Lab: Adding Reporting Services Reports to a SharePoint Library
- Lab: Configuring Subscriptions and Alerts to Reports
- 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
- Lab: Configuring a SharePoint Site for PerformancePoint
- Lab: Create a PerformancePoint Dashboard
- Power BI
- Overview of Power BI
- How Power BI fits with SharePoint
- Lab: Working with Power BI
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this Microsoft SharePoint class:
- 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.