There has been considerable investment in the Business Intelligence capabilities of SharePoint 2010. From new product capabilities like balanced scorecards, interactive dashboards, and line of business integration to improvements in Excel rendered content with Excel Services, improved and new capabilities for Self-Service information access, and creation of BI assets. In this session, we will cover the major components and identify the new capabilities.
Hands-On Labs
Developing BI Applications Lab
The purpose of this lab is to demonstrate the Business Intelligence (BI) capabilities of SharePoint Server 2010. You will begin by using the Chart Web Part to create graphical representations of data within SharePoint lists. Next, you will play the role of an analyst using Microsoft Excel 2010 to examine and data from SQL Server Analysis Services. After creating an Excel workbook that displays BI information, you will then publish the workbook with Excel Services to make it accessible to users using the browser. In the final exercise, you will work with a PerformancePoint Services site and the new Dashboard Designer to create a dashboard for the executive management team at Adventure Works.
Videos
Introducing Business Intelligence
There has been considerable investment in the Business Intelligence capabilities of SharePoint 2010. From new product capabilities like balanced scorecards, interactive dashboards, and line of business integration to improvements in Excel rendered content with Excel Services, improved and new capabilities for Self-Service information access, and creation of BI assets. In this session, we will cover the major components and identify the new capabilities.
Business Intelligence (BI) Primer
If you are new to Business Intelligence this video will get you up to speed quickly. You will learn about some of the new BI features in SharePoint 2010, such as Excel Service and PerformancePoint Services.
Excel Services
In this video you will learn how to create BI applications using Excel Services.
PerformacePoint Services
PerformacePoint Services is all about surfacing data to users in a dashboard format to allow users to create business decisions based on the dashboard information.