55045A: Microsoft End To End Business Intelligence Boot Camp




    7 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    Microsoft End-to-End Business Intelligence Boot Camp is a seven-day course that provides core understanding of the Microsoft Business Intelligence environment. Through this course, participants get an understanding of SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services along with PerformancePoint Service, Business Connectivity Services, Excel Services, Visio Services and the Business Intelligence Center focusing on their interdependency.

    Module 1: Course Overview

    This module describes how the class will be structured and introduces course materials and additional administrative information.


    • Introduction
    • Course Materials
    • Facilities
    • Prerequisites
    • What We'll Be Discussing

    Module 2: The Business Intelligence Stack

    This module explains the three different ways in which business intelligence can be viewed. We will take a brief look at PowerPivot, examining the new features and their significance.


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

    Module 3: SQL Server Integration Services (SSIS) 2012

    This module explains ETL and discusses two approaches that should be considered prior to implementation.


    • What’s New?
    • Overview of Extract, Transform, and Load (ETL)
    • SSIS Tools
    • Change Data Capture
    • SQL Server Integration Services Scripting
    • Variables, Parameters, and Expressions
    • Package Deployment

    Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

    This module explains the basics of using multidimensional mode and the tools available.


    • The Data Warehouse/Data Mart
    • The Tools
    • Key Concepts
    • Data Sources
    • Data Views
    • Cubes
    • Data Profiler
    • Proactive Cache
    • Wizards

    Module 5: Microsoft Multidimensional Expressions

    This module explains key concepts in multidimensional space and browses some basic MDX statements with specific coverage on navigating hierarchies and working with time.


    • Concepts in Multidimensional Space
    • Basic MDX Statements
    • SQL Server Management Studio MDX Query Editor
    • Navigating Hierarchies
    • Working with Time
    • Microsoft Multidimensional Expressions

    Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

    This module explains the basics of using tabular mode and the tools available.


    • The Tabular Model
    • Data Analytic Expressions (DAX)
    • The Editor
    • Data Connections
    • Creating a Tabular Project
    • Relationships
    • Measures and Calculated Columns
    • Hierarchies
    • Perspectives
    • KPIs
    • Partitions
    • Processing
    • Deployment

    Module 7: SQL Server 2012 Reporting Services

    This module explains the new and exciting features available in SQL 2012 Reporting Services.


    • Report Lifecycles
    • Installation Modes
    • Report Creation Tools
    • Data Sources
    • Datasets
    • Graphics
    • Report Parts

    Module 8: Master Data Services

    This module explains Master Data Management and explains what it is and why it is important.


    • What is Master Data Management?
    • System Roles
    • Master Data vs. Transactional Data
    • Master Data Services ETL
    • Master Data Services Key Concepts

    Module 9: Data Mining/Predictive Analytics

    This module explains the concept of data mining and how it can be a valuable tool in your business intelligence arsenal.


    • Definitions for Our Purpose
    • Problems Addressed
    • Business Analytics
    • CRISP-DM
    • Key Concepts
    • Microsoft Data Mining Process
    • Data Mining Tasks
    • Microsoft Algorithms
    • Matching the Tasks to the Algorithm
    • Data Mining Add-in for Excel

    Module 10: SharePoint 2013 Business Intelligence Center

    This module explains 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 11: SharePoint 2013 Excel Services

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


    • New 2013 Excel Services Features
    • Core Components
    • Excel Web Access (EWA)
    • What Excel Web Access is Not
    • Differences in the Browser vs. Desktop
    • SharePoint Libraries to Store Workbooks
    • Power View Add-in for Excel
    • Excel Web App

    Module 12: SharePoint 2013 PerformancePoint 2013

    This module explains the new 2013 PerformancePoint Services features.


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

    Module 13: SharePoint 2013 Visio Services

    This module explains 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
    • SharePoint 2013 Visio Services

    Module 14: 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 15: SharePoint 2013 Business Connectivity Services

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


    • New 2013 Business Connectivity Service Features
    • What is Business Connectivity Services?
    • BCS Terminology
    • BCS Security
    • Using SharePoint Designer 2013 with BCS
    • Surfacing the BCS Data

    Module 16: 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 course is intended for:

    • Project Managers,
    • Business Intelligence Developers,
    • SQL Server Developers and
    • IT Professionals 
    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.