55042: SharePoint 2013 Business Intelligence




    4 Day(s) Course


    Official Courseware


    Certified Trainer


    Exam Voucher


    1:1 Training Available on Demand


    Customize Your Batch

    Course Information

    The 55042 Microsoft SharePoint 2013 Business Intelligence is a four-day course that delivers the best knowledge of SharePoint business intelligence services that include PerformancePoint Service, Business Connectivity Services, Excel Services, and Visio Services.

    This course unveils the new and improved Business Intelligence Center along with the exciting new features within the SharePoint 2013 and focuses on the SharePoint 2013 business intelligence platform rather than the SQL business intelligence services.


    Module 1: Course Overview

    The module introduces course materials with additional administrative information and teaches how the class will be structured.


    • Introduction
    • Prerequisites
    • Course Materials
    • What We’ll Be Discussing

    Module 2: The Business Intelligence Stack

    This module describes the three different ways in which business intelligence can be viewed.


    • SQL 2012 Business Intelligence
    • Business Intelligence in Three Ways
    • New 2013 PowerPivot in Excel Features
    • New 2013 SharePoint Business Intelligence Features

    Module 3: SharePoint 2013 Business Intelligence Center

    This module discusses the new and improved 2013 SharePoint Central Administration site.


    • New 2013 SharePoint Central Administration
    • New 2013 Business Intelligence Center
    • Permissions and Roles
    • Included Document Library and List Apps

    Module 4: SharePoint 2013 Excel Services

    This module describes the overall new 2013 Excel Services features, and we will explore the core components of Excel Services.


    • Excel Web Access (EWA)
    • Differences in the Browser vs. Desktop
    • SharePoint Libraries to Store Workbooks
    • The Save and Share Process
    • New 2013 Excel Services Features
    • Excel Web App
    • Power View Add-in for Excel
    • Best Practices

    Module 5: SharePoint 2013 PerformancePoint 2013

    This module describes the new 2013 PerformancePoint Services features.


    • Visual Reports
    • Scorecards
    • Dashboard Designer
    • Data Sources
    • Indicators
    • New 2013 Overview of PerformancePoint Services

    Module 6: SharePoint 2013 Visio Services

    This module describes how Visio drawings can be extremely effective and in this module we cover the shared service that allows users to share and view them.


    • New 2013 Visio Services Features
    • Visio Graphics Service
    • Visio Drawings in the Browser
    • Visio Web Access Web Part
    • Visio Drawings with Data Connections

    Module 7: PowerPivot

    This module is intended as an overview of the PowerPivot and covers all the new features available in the 2013 release of the add-in.


    • New 2013 PowerPivot Features
    • PowerPivot and Excel
    • PowerPivot and SharePoint
    • Enterprise Business Intelligence and PowerPivot
    • Importing Data
    • Enriching Data
    • SharePoint Sharing

    Module 8: SharePoint 2013 Business Connectivity Services

    This module describes the new features available within SharePoint 2013 Business Connectivity Services, how to configure the security, and clarify the terminology.


    • What is Business Connectivity Services?
    • SharePoint Designer 2013 Use with BCS
    • New 2013 Business Connectivity Service Features
    • BCS Security & Terminology

    Module 9: Dashboards

    This module borrows content from the three-day Microsoft course on Dashboards number 50596A. We will discuss monitoring, analyzing, and managing dashboards along with details on how to use them most effectively.


    • Dashboard Migration
    • Three Types of Dashboards
    • Successful Dashboards
    • Tables or Graphs
    • Types of Graphs
    • Choosing a Chart Type
    • Key Performance Indicators
    • Pitfalls in Dashboard Design
    • Microsoft Report Builder 3.0
    • Plan Your Reports
    • Datasets
    • New 2013 SharePoint Designer Features
    • SharePoint Web Apps


    This Microsoft Course 55042a is intended for power users, business intelligence developers and IT professionals who are involved in designing, developing and maintaining the SharePoint 2013 business intelligence solutions.


    Before attending this course, candidates must have:

    • An understanding of the benefits of business intelligence.


    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.