Course 55158-A: SharePoint 2013 Business Intelligence

Microsoft

Course 55158-A: SharePoint 2013 Business Intelligence

Share This Learning Path

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

Audience Profile

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.

Prerequisites

Course outline

Module 1: Overview of SharePoint Business Intelligence Services and Features

Module Overview

This module provides an overview of SharePoint Business Intelligence Services and features.

Lessons

SharePoint BI Services
SharePoint BI Features

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand what services and features are offered.

Module 2: Configuring SharePoint Sites for Business Intelligence

Module Overview

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 Sessions

Configuring SharePoint Team Site for Business Intelligence

Lab Lessons

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

Module Overview

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 Sessions

Configuring Excel Services Farm Options
Refreshing Data with Excel Services

Lab Lessons

Configuring Excel Services Farm Options
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

Module Overview

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 Sessions

Using SharePoint Visio Services

Lab Lessons

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

Module Overview

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 Sessions

Configuring PowerPivot for SharePoint
Refreshing Data from a PowerPivot Gallery

Lab Lessons

Configuring PowerPivot for SharePoint
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

Module Overview

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 Sessions

Creating a Report with Power View

Lab Lessons

Creating a Report with Power View

After completing this module, students will be able to:

Configure data sources.
Create Power View reports.

Module 7: SQL Reporting Services Add-on for SharePoint

Module Overview

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 Sessions

Adding Reporting Services Reports to a SharePoint Library
Configuring Subscriptions and Alerts to Reports

Lab Lessons

Adding Reporting Services Reports to a SharePoint Library
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

Module Overview

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 Sessions

Configuring a SharePoint Site for PerformancePoint
Create a PerformancePoint Dashboard

Lab Lessons

Configuring a SharePoint Site for PerformancePoint
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

Module Overview

This module explains how work with Power BI.

Lessons

Overview of Power BI
How Power BI fits with SharePoint

Lab Sessions

Working with Power BI

Lab Lessons

Working with Power BI

After completing this module, students will be able to:

Work with Power BI.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center