Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-800-268-7737 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


SharePoint 2013 Business Intelligence (M55042)

Learn the new services of SharePoint 2013 Business Intelligence.

GK# 6559 Vendor# M55042

Course Overview


In this course, you will learn the new SharePoint 2013 Business Intelligence platform and how its associated services—PerformancePoint, Excel, Business Connectivity Services (BCS), and Visio—can assist you in designing, developing, and maintaining SharePoint 2013 Business Intelligence solutions.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • Browse data using SQL Server Management Studio and Visual Studio 2013
  • Settings and options within the SharePoint 2013 Central Administration
  • Create a new web application and business intelligence site
  • Create a SharePoint library containing Excel workbooks, explore trusted site locations
  • Excel Web Access and how to add Web Apps to a webpage
  • Overview of the new features of PerformancePoint 2013
  • Explore the Dashboard Designer interface to create and configure a data source
  • Create and configure a standard and leaf key performance indicator (KPI) along with a scorecard for each
  • Create and configure analytic charts and grids
  • Create and filter a time intelligence data connection
  • Create, configure, and deploy the objective scorecard
  • Overview of the new 2013 Visio Services features including data connected drawings and viewing drawings within a browser
  • PowerPivot add-in new 2013 features and the relationship with Excel and SharePoint
  • Create and configure in SharePoint 2013 BCS
  • Create and configure the different content types of SharePoint 2013
  • Dashboards and how to connect SharePoint Web Apps


Viewing outline for:

Virtual Classroom Live Outline

1. The Business Intelligence Stack

  • SQL 2012 Business Intelligence
  • New features of SharePoint 2013 Business Intelligence and PowerPivot 2013 in Excel

2. SharePoint 2013 Business Intelligence Center

  • SharePoint 2013 Central Administration
  • Permissions, roles, document library, and list apps

3. SharePoint 2013 Excel Services

  • Excel Web Access and Web Apps
  • SharePoint Library Workbooks storage
  • Power View add-in for Excel

4. SharePoint 2013 PerformancePoint 2013

  • Dashboard Designer
  • Create and configure KPIs, visual reports, filters, and scorecards

5. SharePoint 2013 Visio Services

  • Visio drawing in the browser
  • Visio Web Access web part
  • Visio drawings with data connections

6. PowerPivot 2013 Add-in

  • PowerPivot and Excel, SharePoint
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence and PowerPivot

7. SharePoint 2013 Business Connectivity Services (BCS)

  • BCS terminology and security
  • BCS and SharePoint Designer 2013

8. Dashboard Monitoring, Analyzing, and Managing

  • Types of dashboards
  • Dashboard migrations
  • Tables, graphs, and charts
  • KPI
  • Microsoft Report Builder 3.0
  • Datasets
  • SharePoint Web Apps


Viewing labs for:

Virtual Classroom Live Labs

Lab 1: The Business Intelligence Stack

  • SQL 2012 Multidimensional and Tabular Model Basics

Lab 2: SharePoint 2013 Central Administration and BI Center

Lab 3: SharePoint 2013 Excel Services

  • Create a library storage for Excel Workbooks
  • Power View add-in for Excel
  • Add an Excel Web App to a Webpage

Lab 4: SharePoint 2013 PerformancePoint 2013

  • KPIs, Visual Reports
  • PerformancePoint filters (cascading and time intelligence)
  • Scorecard Settings and filters
  • PerformancePoint Dashboards

Lab 5: SharePoint 2013 Visio Services

Lab 6: PowerPivot

Lab 7: SharePoint 2013 Business Connectivity Services (BCS)

  • Content types

Lab 8: Dashboards

  • Report Builder 3.0
  • Dashboard Web Apps

Who Should Attend

  • Power users of SharePoint 2013 Business Intelligence solutions
  • Business Intelligence developers and IT professionals who design, develop, and maintain SharePoint 2013 Business Intelligence solutions
Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Course Retakes
  • Digital courseware
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 4 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 4 day

Request this course in a different delivery format.