SharePoint 2013 Business Intelligence

Session Detail:    Classroom 3 Day

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

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 Can Benefit

This course is intended for information workers and business intelligence analysts who have a minimum of three months of experience using SharePoint sites, lists, and libraries and have basic Web navigation skills.

Session Outline

Class Outline

Module 1: Overview of SharePoint Business Intelligence Services and Features

  • Lesson 1: SharePoint BI Services
  • Lesson 2: SharePoint BI Features

After completing this module, students will be able to:

  • Understand what services and features are offered

Module 2: Configuring SharePoint Sites for Business Intelligence

  • Lesson 1: SharePoint Business Intelligence Site Template
  • Lesson 2: Configuring an Existing 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

  • Lesson 1: Viewing Excel Spreadsheets with SharePoint Excel Services
  • Lesson 2: Using SharePoint Excel Services Web Part
  • Lesson 3: Basic Excel Services Farm Configuration Options
  • Lesson 4: Refreshing Data Sources with SharePoint 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

  • Lesson 1: Configuring Visio Services Farm Settings
  • Lesson 2: View Visio Drawings with SharePoint Visio Services
  • Lesson 3: Attaching Data to Visio Drawings

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

  • Lesson 1: Overview of PowerPivot Data Models
  • Lesson 2: Configuring PowerPivot Farm Settings
  • Lesson 3: Creating a PowerPivot Gallery
  • Lesson 4: PowerPivot Data Refresh Options

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

  • Lesson 1: Overview of Power View in SharePoint
  • Lesson 2: Configuring Data Sources for Power View Reports
  • Lesson 3: Creating Power View Reports

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

  • Lesson 1: Configuring Reporting Services Farm Settings
  • Lesson 2: Configuring a SharePoint Library for Reporting Services Reports
  • Lesson 3: Reporting Services Subscriptions and Alerts
  • Lesson 4: Report Viewer Web Part

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

  • Lesson 1: Overview of PerformancePoint Services
  • Lesson 2: Configuring SharePoint Lists and Libraries for PerformancePoint
  • Lesson 3: Creating a Data Source
  • Lesson 4: Creating a Score Card and KPI
  • Lesson 5: Creating PerformancePoint Charts and Graphs
  • Lesson 6: Creating PerformancePoint Dashboards

After completing this module, students will be able to:

  • Configure lists and libraries for PerformancePoint
  • Create a data source
  • Create a scorecard and KPI
  • Create PerformancePoint charts and graphs

Module 9: Power BI

  • Lesson 1: Overview of Power BI
  • Lesson 2: How Power BI fits with SharePoint

After completing this module, students will be able to:

  • Working with Power BI

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

SharePoint 2013 Business Intelligence

3 Day
Classroom

$2,295.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now