Overview
This 4-day instructor-led course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class you will also learn best practices and ‘what not to do’ as you watch live, interactive demonstrations and put theory into practice with hands-on exercises in SharePoint Online.
Prerequisites
Those who wish to take up 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 students in this course
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.
Course Outline
- SharePoint BI Services
- SharePoint BI Features
- 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
- Refreshing Data Sources with SharePoint Excel Services
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 a 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 Subscriptions 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