Course M55063 Advanced SharePoint 2013 Business Intelligence |

(050) 352 68 64

Course M55063 Advanced SharePoint 2013 Business Intelligence

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.

Audience Profile

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

Before attending this course, students must have:

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

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

Sign up for the closest date

Course Code


Length, days (hours)

5 (40)

Ask a Question