Welcome to ONLC Training Centers


Microsoft Project & Porfolio Management (PPM) 2013/2016/Online Advanced Reporting Course Outline

 (3 days)

Overview
This 3 day course is designed for SharePoint & Project Server/Online Administrators and Report Developers that have been tasked with setting up, creating and maintaining reports and dashboards in SharePoint & Project Server 2013, 2016 and Project Online. Ideally, students have attended our Project Server 2013/Online for Administrators course or have equivalent knowledge.

Audience
This course is intended for administrators, report developers, architects, SharePoint administrators and other IT resources who will be responsible for the setup, configuration and maintenance of SharePoint & Project Server 2013 reports and dashboards.

At Course Completion
After completing this course, students will learn about the following:
     Working with the BI Center
     Understanding Report Types
     Creating Reports with Excel Services
     Working with OLAP Cubes
     Working with Visio and Visio Services
     Working with SSRS
     Working with Performance Point Services

Course Outline

Module 1: Overview of SharePoint Business Intelligence Services and Features
This module provides an overview of SharePoint Business Intelligence Services and features.
Lessons
     SharePoint BI Services
     SharePoint BI Features
Lab 1: None
     None
After completing this module, students will be able to:
     Understand what services and features are offered

Module 2: Configuring SharePoint Sites for Business Intelligence
This module explains how to configure an existing team site for BI.
Lessons
     SharePoint Business Intelligence Site Template
     Configuring an Existing SharePoint Team Site for Business Intelligence
Lab 1: Configuring SharePoint Team Site for Business Intelligence
     Configuring SharePoint Team Site for Business Intelligence
After completing this module, students will be able to:
     Configure an existing SharePoint Team Site for Business Intelligence.

Module 3: Excel Services in SharePoint
This module explains how to use Excel Services.
Lessons
     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 1: Configuring Excel Services Farm Options
     Configuring Excel Services Farm Options
Lab 2: Refreshing Data with Excel Services
     Refreshing Data with Excel Services
After completing this module, students will be able to:
     View Excel sheet with SharePoint Excel Services.
     Use Excel Services Web Part.
     Configure basic Excel services.
     Refresh data sources.

Module 4: Visio Services in SharePoint
This module explains how to use Visio Services.
Lessons
     Configuring Visio Services Farm Settings
     View Visio Drawings with SharePoint Visio Services
     Attaching Data to Visio Drawings
Lab 1: Using SharePoint Visio Services
     Using SharePoint Visio Services
After completing this module, students will be able to:
     Configure Visio services.
     View Visio drawings.
     Attach data to drawings.

Module 5: SharePoint PowerPivot Add-on
This module explains how to work with PowerPivot Models, Farm Settings, and Gallery.
Lessons
     Overview of PowerPivot Data Models
     Configuring PowerPivot Farm Settings
     Creating a PowerPivot Gallery
     PowerPivot Data Refresh Options
Lab 1: Configuring PowerPivot for SharePoint
     Configuring PowerPivot for SharePoint
Lab 2: Refreshing Data from a PowerPivot Gallery
     Refreshing Data from a PowerPivot Gallery
After completing this module, students will be able to:
     Configure PowerPivot Farm settings.
     Create a PowerPivot Gallery.
     Use data refresh options.

Module 6: SharePoint Power View Feature
This module explains how to work with Power View.
Lessons
     Overview of Power View in SharePoint
     Configuring Data Sources for Power View Reports
     Creating Power View Reports
Lab 1: Creating a Report with Power View
     Creating a Report with Power View
Lab 2: Creating a Report with Power View
     Creating a Report with Power View
After completing this module, students will be able to:
     Configure data sources.
     Create Power View repots.

Module 7: SQL Reporting Services Add-on for SharePoint
This module explains how to work with Reporting Services for SharePoint
Lessons
     Configuring Reporting Services Farm Settings
     Configuring a SharePoint Library for Reporting Services Reports
     Reporting Services Subscriptions and Alerts
     Report Viewer Web Part
Lab 1: Adding Reporting Services Reports to a SharePoint Library
     Adding Reporting Services Reports to a SharePoint Library
Lab 2: Configuring Subscriptions and Alerts to Reports
     Configuring Subscriptions and Alerts to Reports
After completing this module, students will be able to:
     Configure Reporting Services Farm Settings.
     Configure a SharePoint Library.
     Work with subscriptions and alerts.
     Work with Viewer Web Part.

Module 8: SharePoint PerformancePoint Services
This module explains how to work with PerformancePoint Services
Lessons
     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 1: Configuring a SharePoint Site for PerformancePoint
     Configuring a SharePoint Site for PerformancePoint
Lab 2: Create a PerformancePoint Dashboard
     Create a PerformancePoint Dashboard
After completing this module, students will be able to:
     Configure lists and libraries for PerformancePoint.
     Create a data source.
     Create a score card and KPI.
     Create PerformancePoint charts and graphs.

Module 9: Power BI
This module explains how work with Power BI.
Lessons
     Overview of Power BI
     How Power BI fits with SharePoint
Lab 1: Working with Power BI
     Working with Power BI
After completing this module, students will be able to:
     Working with Power BI
View outline in Word

XMPR16

Attend hands-on, instructor-led Microsoft Project & Porfolio Management (PPM) 2013/2016/Online Advanced Reporting training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $1495

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com