Sharepoint 2013 Business Intelligence

Unlock the full potential of SharePoint 2013 with our comprehensive Business Intelligence course designed for IT professionals, power users, and developers seeking to enhance their BI solutions and drive data-driven decision-making.

Course Thumbnail

Essential Skills Gained

Checkmark

Explore and configure SharePoint 2013 BI services such as Excel Services, PerformancePoint, and Visio Services.

Checkmark

Create, manage, and deploy interactive dashboards using SharePoint 2013 tools.

Checkmark

Integrate PowerPivot with Excel to handle and analyze large datasets efficiently.

Checkmark

Design and implement secure external content types and lists using Business Connectivity Services.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Power Users
  • Business Intelligence Developers
  • IT Professionals
  • Data Analysts

Description

This three-day instructor-led course provides students with the necessary knowledge to work with all the associated SharePoint business intelligence services including PerformancePoint Service, Excel Services, Business Connectivity Services, and Visio Services. The new and improved Business Intelligence Center is explored, and all the exciting new features within the SharePoint 2013 release are covered. The focus of this course is on the SharePoint 2013 business intelligence platform and not on the SQL business intelligence services. As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Course Overview

  1. Introduction

  2. Course Materials

  3. Facilities

  4. Prerequisites

  5. What We'll Be Discussing

Module 2: The Business Intelligence Stack

  1. Business Intelligence in Three Ways

  2. SQL 2012 Business Intelligence

  3. New 2013 SharePoint Business Intelligence Features

  4. New 2013 PowerPivot in Excel Features

Module 3: SharePoint 2013 Business Intelligence Center

  1. New 2013 SharePoint Central Administration

  2. New 2013 Business Intelligence Center

  3. Permissions and Roles

  4. Included Document Library and List Apps

Module 4: SharePoint 2013 Excel Services

  1. New 2013 Excel Services Features

  2. Core Components

  3. Excel Web Access (EWA)

  4. Differences in the Browser vs. Desktop

  5. Power View Add-in for Excel

  6. The Save and Share Process

Module 5: SharePoint 2013 PerformancePoint 2013

  1. New 2013 Overview of PerformancePoint Services

  2. Dashboard Designer

  3. Data Sources

  4. Indicators

  5. KPIs

  6. Visual Reports

  7. Filters

  8. Scorecards

  9. Dashboards

Module 6: SharePoint 2013 Visio Services

  1. New 2013 Visio Services Features

  2. Visio Graphics Service

  3. Visio Drawings in the Browser

  4. Visio Web Access Web Part

  5. Visio Drawings with Data Connections

Module 7: PowerPivot

  1. New 2013 PowerPivot Features

  2. PowerPivot and Excel

  3. PowerPivot and SharePoint

  4. Importing Data

  5. Enriching Data

  6. SharePoint Sharing

Module 8: SharePoint 2013 Business Connectivity Services

  1. New 2013 Business Connectivity Service Features

  2. What is Business Connectivity Services?

  3. BCS Terminology

  4. BCS Security

  5. Using SharePoint Designer 2013 with BCS

Module 9: Dashboards

  1. Dashboard Migration

  2. Three Types of Dashboards

  3. Successful Dashboards

  4. Types of Graphs

  5. Key Performance Indicators

  6. Microsoft Report Builder 3.0

  7. SharePoint Web Apps

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.