Microsoft SharePoint 2013 End to End Business Intelligence

Download Course Contents

Microsoft SharePoint 2013 End to End Business Intelligence Course Overview

The Microsoft End to End Business Intelligence Course is a high level training that introduces participants to SharePoint 2013 Business Intelligence and SQL 2012 BI services. This includes Excel Services, Visio Services, PerformancePoint Service, Business Connectivity Services and Business Intelligence Center. These modules are stand-alone allowing users to customize the course according to their inclination for a particular technology. The course aims to explain the interdependencies between these so as to give a 360 degree view to students. The course is a combination of theoretical understanding and practical demonstrations that let students perform exercises themselves for a wholesome learning experience. 


The Microsoft SharePoint BI course is recommended for SQL Server Developers , Business Intelligence Developers, Project Managers, and IT Professionals who wish to gain skills in designing, developing and maintaining SharePoint 2013 BI solutions.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Cour se Overview
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Business Intelligence in Three Ways
  • SQL 2012 Business Intelligence
  • New 2013 SharePoint Business Intelligence Features
  • New 2013 PowerPivot in Excel Feature
  • The Bus ines s Intelligence Stack
  • 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
  • SQL Server Integration Services (SSIS) 2012
  • The Data Warehouse/Data Mart
  • The Tools
  • Key Concepts
  • Data Sources
  • Data Views
  • Cubes
  • Data Profiler
  • Proactive Cache
  • Wizards
  • SQL 2012 Bus ines s Intelligence Semantic Model (Multidimens ional Mode)
  • Concepts in Multidimensional Space
  • Basic MDX Statements
  • SQL Server Management Studio MDX Query Editor
  • Navigating Hierarchies
  • Working with Time
  • Microsoft Multidimensional Expressions
  • Microsoft Multidimens ional Expres s ions
  • 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
  • SQL 2012 Bus ines s Intelligence Semantic Model (Tabular Mode)
  • Report Lifecycles
  • Installation Modes
  • Report Creation Tools
  • Data Sources
  • Datasets
  • Basic Reports
  • Graphics
  • Maps
  • Report Parts
  • SQL Server 2012 Reporting Services
  • What is Master Data Management?
  • System Roles
  • Master Data vs. Transactional Data
  • Master Data Services ETL
  • Master Data Services Key Concepts
  • Mas ter Data Services
  • Definitions for Our Purpose
  • Problems Addressed
  • Business Analytics
  • Key Concepts
  • Microsoft Data Mining Process
  • Data Mining Tasks
  • Microsoft Algorithms
  • Matching the Tasks to the Algorithm
  • Data Mining Add-in for Excel
  • Data Mining/Predictive Analytics
  • New 2013 SharePoint Central Administration
  • New 2013 Business Intelligence Center
  • Permissions and Roles
  • Included Document Library and List Apps
  • SharePoint 2013 Bus ines s Intelligence Center
  • 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
  • The Save and Share Process
  • Excel Web App
  • Best Practices
  • SharePoint 2013 Excel Services
  • New 2013 Overview of PerformancePoint Services
  • Dashboard Designer
  • Data Sources
  • Indicators
  • KPIs
  • Visual Reports
  • Filters
  • Scorecards
  • Dashboards
  • SharePoint 2013 PerformancePoint 2013
  • New 2013 Visio Services Features
  • Visio Graphics Service
  • Visio Drawings in the Browser
  • Visio Web Access Web Part
  • SharePoint 2013 Visio Services
  • New 2013 PowerPivot Features
  • PowerPivot and Excel
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence and PowerPivot
  • Importing Data
  • Enriching Data
  • SharePoint Sharing
  • PowerPivot
  • 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
  • SharePoint 2013 Bus ines s Connectivity Services
  • 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
  • Dashboards
Live Online Training (Duration : 40 Hours) Fee On Request
Group Training Incl. Official Courseware
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours

Course Prerequisites
  • Understanding of the benefits of business intelligence.

Upon Completion of this Course, you will accomplish following:-

  • Using SQL Server Management Studio for browsing data in the cube.
  • Using Visual Studio 2013 to browse data.
  • Connecting to tabular sources to import/export data.
  • Creating a sample/test database.
  • Creating a project.
  • Understanding and implementing the MDX functionality.
  • Using Table Import Wizard for importing data.
  • Using Excel for connecting to a Tabular Model.
  • Using the new SharePoint 2013 Central Administration in your project to explore its properties and settings.
  • Creating a new BI site and a web application using features of both SharePoint and SQL.
  • Creating a SharePoint library for Excel workbooks.
  • Using the PowerPivot and Power View feature in Excel
  • Exploring the Dashboard Designer interface and creating/configuring a data source.
  • Using Report Manager for creation of a shared data source.

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 55045: Microsoft End to End Business Intelligence Boot Camp Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Request More Information

Add Name and Email Address of participant (If different from you)


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Microsoft Learning Partner