SharePoint 2010 BI - Part 1: Essentials

Training code

Upcoming sessions

Learning Goals

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

This course will focus on how to leverage the Microsoft Business Intelligence Stack on the SharePoint Server 2010 platform. You will get an in dept training on the Business Intelligence features offered by SharePoint Server 2010.

Target Audience

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


Attendees should have a basic knowledge on Microsoft products as SQL Server and Excel.

Course Outline

Overview of the Microsoft Business Intelligence Stack

  • Basics of Business Intelligence.
  • Introduction to building Cubes with Microsoft Analysis Services.
  • Overview of building Reports with Reporting Services and Report Builder 3.0.
  • Using Microsoft Excel 2010 and Visio 2010 as Data Warehouse client applications.

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 .

SharePoint Business Intelligence Center

  • What is the Business Intelligence Center site definition.
  • How can u use it as a starting point to create SharePoint BI sites and dashboard?
  • Explain the Filter Web Parts and what their role will be in in developing dashboard.
  • What role does the Secure Store Service play in implementing BI solutions in sharePoint.
  • Using the SharePoint Chart Web Part.
  • Working with the SharePoint KPI functionalities.

Integration Reporting Services and SharePoint 2010

  • 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.

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.

Visio Services

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

PerformancePoint Services

  • Explore PerformancePoint.
  • Explore PerformancePoint Dashboard and Scoreboard Designer.
  • Learn how to create PerformancePoint Reports.
  • Learn how to define KPI’s in PerformancePoint.
  • Create Filters and add Time Intelligence To PerformancePoint.
  • Combine all PerformancePoint objects into a Dashboard.
Upcoming sessions at U2U in Brussels, Belgium:

To organize this course on-site, please contact

Course Calendar
Courses On Site
Course Agenda in PDF
Become a U2U trainer

Contact Me

Call me
Send U2U folder
Send more info