Microsoft SharePoint 2013 End to End Business Intelligence

Microsoft SharePoint 2013 End to End Business Intelligence Certification Training 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. 

Audience:

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.

Microsoft SharePoint 2013 End to End Business Intelligence (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2000
22 - 26 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2300
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Cour se Overview
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
Module 2: The Bus ines s Intelligence Stack
  • 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
Module 3: SQL Server Integration Services (SSIS) 2012
  • 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
Module 4: SQL 2012 Bus ines s Intelligence Semantic Model (Multidimens ional Mode)
  • 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)
Module 5: Microsoft Multidimens ional Expres s ions
  • 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
Module 6: SQL 2012 Bus ines s Intelligence Semantic Model (Tabular Mode)
  • 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)
Module 7: SQL Server 2012 Reporting Services
  • Report Lifecycles
  • Installation Modes
  • Report Creation Tools
  • Data Sources
  • Datasets
  • Basic Reports
  • Graphics
  • Maps
  • Report Parts
  • SQL Server 2012 Reporting Services
Module 8: Mas ter Data 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
Module 9: Data Mining/Predictive Analytics
  • 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
  • Data Mining/Predictive Analytics
Module 10: SharePoint 2013 Bus ines s Intelligence Center
  • 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
Module 11: SharePoint 2013 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
  • The Save and Share Process
  • Excel Web App
  • Best Practices
  • SharePoint 2013 Excel Services
Module 12: SharePoint 2013 PerformancePoint 2013
  • New 2013 Overview of PerformancePoint Services
  • Dashboard Designer
  • Data Sources
  • Indicators
  • KPIs
  • Visual Reports
  • Filters
  • Scorecards
  • Dashboards
  • SharePoint 2013 PerformancePoint 2013
Module 13: SharePoint 2013 Vis io Services
  • 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
  • New 2013 PowerPivot Features
  • PowerPivot and Excel
  • PowerPivot and SharePoint
  • Enterprise Business Intelligence and PowerPivot
  • Importing Data
  • Enriching Data
  • SharePoint Sharing
  • PowerPivot
Module 15: SharePoint 2013 Bus ines s Connectivity Services
  • 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
Module 16: Dashboards
  • 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
Download Course Contents

Request More Information

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.