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.

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.