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.

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.

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.

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.

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.

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.

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.

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.

A: In this training, you will learn how to use SharePoint 2016 to implement business intelligence solutions. You will understand the key components of SharePoint Business Intelligence, such as Power Pivot, Power View, and PerformancePoint Services. You will learn how to create interactive reports, dashboards, and scorecards, and how to integrate data from various sources for analysis.

A: It is recommended to have a basic understanding of SharePoint and its features. Familiarity with business intelligence concepts and tools will be beneficial but not required.

A: Yes, you will receive comprehensive course materials, including manuals, exercises, and other resources to support your learning throughout the training.

A: Yes, this training includes hands-on exercises and practical activities that will allow you to apply the concepts and techniques learned during the training. You will have the opportunity to work with SharePoint 2016 and its business intelligence features.

A: Yes, this training focuses specifically on SharePoint 2016 and its business intelligence capabilities. If you are interested in training for other versions of SharePoint, there may be separate courses available.

A: This training is not specifically tied to a certification. However, the knowledge and skills gained from this training will contribute to your expertise in implementing business intelligence solutions with SharePoint, which can be valuable for your professional development.

A: The training content is generally standardized, We can discuss your organization’s specific needs to explore customization possibilities.

A: To enroll in this training, visit the training provider’s website or contact their customer support. They will provide you with the necessary information on registration, schedule, and payment options.

A: The duration of the training may vary depending on the training provider. It is typically conducted over several days, with each day consisting of a specified number of training hours. The exact schedule will be provided by the training provider.