The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

SharePoint 2016 Business Intelligence

  • Tuition USD $2,066 Save $230
  • Reviews star_rate star_rate star_rate star_rate star_half 572 Ratings
  • Course Code 55157
  • Duration 3 days
  • Available Formats Classroom

This course covers the services and features in SharePoint that offer support for Business Intelligence scenarios.

Skills Gained

  • 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
  • Lean 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

Who Can Benefit

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.

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 Details

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
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:
  • Work with Power BI.

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Very prompt during an issue that occurred, and accidentally contacted an individual on their vacation, but they quickly pointed me to another individual who got my issue resolved.

The format and presentation using the iMVP software worked as well.

Informative class with great instructure who was able to walk through the course material, answer all questions, and give great examples.

Well organized course, supporting materials, and instructor. Good intro to AWS for various levels of participants - managers to developers.

Great resourses were available for us. The instructer was good and knowledgeable in this field.

Good course content and had mixed reviews with the instructors. Some were poor, some were really great.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward