> > > 55063

Advanced SharePoint 2013 Business Intelligence (55063)

Course Description Schedule Course Outline

About this Course

This 5-day Instructor Led course How to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways! Also included are Power* features like PowerView, PowerQuery, PowerMap and PowerBI. You will also be exposed to Big Data topics such as Hadoop, HDInsight and StreamInsight.

This course will take you down a path of building a BI environment from scratch to full interactive dashboards using the Microsoft BI Stack.

Who should attend

This course is intended for Sr. Business Intelligence Architects and Consultants, Sr. Business Analysts, anyone responsible for implementing BI with SharePoint.

Class Prerequisites

Understanding of SharePoint 2013 User Interface, database reporting concepts and familiarity with Data Marts and Data Warehouses

Outline: Advanced SharePoint 2013 Business Intelligence (55063)

Module 1: Business Intelligence

  • Why Business Intelligence?

]Module 2: Business Intelligence Center

  • Business Intelligence Center

]Module 3: Data Mart & Data Warehouses and Master Data Services

  • Understanding Data and Data Formats
  • Building Data Marts & Data Warehouses
  • Master Data Services

]Module 4: Business Connectivity Services and Secure Store

  • Business Connectivity Services
  • Secure Store

]Module 5: Analysis Services, HDInsight and StreamInsight

  • Analysis Services
  • HDInsight & Hadoop
  • StreamInsight

]Module 6: Filter Web Parts

  • Filter Web Parts

]Module 7: Excel, Excel Services and Excel Web App

  • Excel Services

]Module 8: PowerPivot, Tabular Data Sources

  • PowerPivot For Excel
  • PowerPivot For SharePoint

]Module 9: Reporting Services

  • Reporting Services
  • Reports

]Module 10: Power View, Power Query and Power BI

  • Power View
  • Power Query
  • Power BI

]Module 11: Performance Point

  • Performance Point

]Module 12: Visio & Access Services

  • Visio Services
  • Access Services

]Module 13: GeoSpatial Data, GeoLocation and Power Map

  • GeoSpatial Data
  • GeoLocation, Bing Maps and Charts
  • Power Map


  • Business Intelligence Worksheet
  • Business Intelligence Center
  • Data & Data Formats
  • Build A Data Warehouse
  • Extract & Load
  • Transform & Load
  • Granularity
  • Build A Data Mart
  • Master Data Services
  • BCS Basics
  • BCS With Data Warehouse
  • Office & BCS for BI
  • BCS and OData
  • Analysis Services
  • Building An Analysis Services Database
  • Key Performance Indicators
  • Hadoop and Azure HDInsight
  • StreamInsight
  • Filter Web Parts
  • Create An Excel Report
  • Excel Services
  • MDX
  • Sparklines
  • Filters & Excel Services
  • REST & Web Services
  • Use PowerPivot
  • Integrate Power Pivot and SharePoint
  • Tabular Models
  • Import PowerPivot to SSAS
  • Install Reporting Services
  • Building Reports with Reporting Services
  • Automating Reports with Reporting Services
  • Reporting Services and PowerPivot
  • Use Power View
  • Use Power Query
  • Use Power BI
  • Performance Point
  • Visio Services
  • Access Services
  • GeoSpatial Data with SQL Server
  • Bing Maps and GeoLocation column
  • Use Power Map
  • Use Power Map and Power Query
  • NET Charts
Classroom Training

Duration 5 days

  • United States: US$ 2,895
  • SA Voucher: 5
Enroll now
Online Training

Duration 5 days

  • United States: US$ 2,895
  • SA Voucher: 5
Enroll now