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.
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
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
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.
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.
Configuring Visio Services.
Visio Services Authentication.
Publish Visio BI Maps to Visio Services.
Connecting Visio Shapes to data.
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.