Call Us: +32 2 466 00 16
Follow Us:

Developing Business Intelligence Solutions on SharePoint 2013

Training code

Upcoming sessions

This course is currently not scheduled

Subscribe to waiting list

Overview of the Microsoft Business Intelligence Stack

  • Introducing Business Intelligence
  • Databases, data warehouses and OLAP cubes
  • What is Analysis Services
  • Querying relational and OLAP data sources: a brief peek in SQL, MDX and DAX

SharePoint Business Intelligence Center

  • SharePoint storage: Web applications, Sites and lists
  • What are Service applications?
  • Creating a Business Intelligence Center site
  • Exploring the BI Center site

Business Connectivity Services

  • Overview of the BCS architecture
  • Creating External Content Types with SharePoint Designer
  • Connecting to databases and OData services
  • Working with External Lists to support CRUD operations on your data in SharePoint

Excel Services

  • Overview of Excel Services
  • Learn how to publish Excel BI workbooks to Excel Services
  • Configure and secure Shared Data Connections
  • Configure Excel Services security
  • Use the Excel Services Web Part
  • Learn how to access the Excel Services REST-full API
  • Excel Services and the Filter Web Parts

PowerPivot for Excel and SharePoint

  • PowerPivot Overview.
  • What is the role of PowerPivot in the Microsoft BI world?
  • Overview of PowerPivot for Excel and PowerPivot for SharePoint.
  • Setup of PowerPivot For SharePoint .

Reporting Services and SharePoint

  • Configure Reporting Services to run in SharePoint Integrated mode.
  • Setup Reporting Services security in Integrated Mode.
  • How to deploy Reports to Reporting Services in Integrated Mode.
  • Reporting Services Web Part.
  • Combining Reporting Services Web Part and the Filter Web Part.

Visio Services

  • Configuring Visio Services.
  • Visio Services Authentication.
  • Publish Visio BI Maps to Visio Services.
  • Connecting Visio Shapes to data.

Introducing PerformancePoint Services

  • Operation management and Balanced Scorecards
  • The need for Dashboards and Scorecards
  • Explore PerformancePoint Dashboard and Scoreboard Designer
  • PerformancePoint Document library

PerformancePoint Services Data Sources

  • OLAP versus non-OLAP data sources
  • Analysis Services data source
  • Simple Time Period Specification (STPS)
  • Tabular data sources
  • Deploying data sources to SharePoint

Developing Indicators, KPIs and Filters

  • Exploring the build-in indicators
  • Creating custom indicators
  • Key Perormance Indicators
  • Configuring KPI setting
  • Importing Analaysis Services KPIs in PerformancePoint
  • Create Filters and add Time Intelligence To PerformancePoint

From KPIs to DashBoards

  • Reports in PerformancePoint
  • Using Excel services reports
  • Using Reporting services reports
  • Combining KPIs into scorecards
  • Linking scorecards, filters and reports into dashboards
  • Deploying versus publishing dashboards

Introduction PowerView

  • From personal BI to corporate BI
  • Introducing PowerView in SharePoint

Authoring PowerView reports

  • Create tables and charts
  • Interactive sorting, filtering and highlighting
  • Working with multi-view reports
  • Exporting to PowerPoint

This instructor-led course will provide you with the knowledge and skills to develop Business Intelligence solutions on SharePoint Server 2013 with SQL Server. SharePoint 2013 Business Intelligence lets everyone access the business information they need to make good decisions. With powerful features such as interactive dashboards and scorecards they can work naturally and confidently, using well-known interfaces: Reporting Services, PerformancePoint, Visio and Excel.

This course is not only targeting Business Intelligence developers who would like to know the benefits of using SharePoint Server as a Business Intelligence platform but also SharePoint architects, developers or power users who are interested in all the SharePoint Server Business Intelligence features.

Attendees should have a basic knowledge of Microsoft SQL Server (using Management Studio, querying tables) and have some hands-on experience with Excel 2007 or later.

© 2018 U2U All rights reserved.