Developing BI Applications Lab

In this lab, you will learn about the BI offerings in SharePoint 2010. You will start by performing simple visualization of existing list data using the Chart Web Part. You will then use Excel to analyze external internet sales data and then post your results on SharePoint using excel services. Based on that work you will finish by creating a complete dashboard used to monitor reseller sales and track actual versus expected year to date sales numbers.

Overview

In these exercises, you will learn about the BI offerings in SharePoint 2010. You will start by performing simple visualization of existing list data using the Chart Web Part. You will then use Excel to analyze external internet sales data and then post your results on SharePoint using excel services. Based on that work you will finish by creating a complete dashboard used to monitor reseller sales and track actual versus expected year to date sales numbers.

Objectives

In this lab you will:

• Learn to use the Chart Web Part
• Learn to publish Excel Workbooks to Excel Services for viewing in the browser
• Learn to use PerformancePoint Services to build rich dashboards to analyze business information

System Requirements

This lab assumes that you have SharePoint Server installed in a test environment. For guidance on how to setup SharePoint Server see https://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx. Note that any URL referred to in this lab must be adjusted for use with your local setup. You must have the following items to complete this lab:

• Microsoft® Windows® Vista SP1 or Microsoft® Windows Server 2008 (64-bit)
• Microsoft® SharePoint Server 2010 (64-bit)
• Microsoft® Office Professional Plus 2010 (32-bit or 64-bit)
• Microsoft® Visual Studio 2010

Setup

You must perform the following steps to prepare your computer for this lab. This consists primarily of creating a SharePoint site collection at https://intranet.contoso.com/sites/BIApplications and installing the code snippets for this lab.

1. Run the command file Setup.bat located at %Office2010DeveloperTrainingKitPath%\Labs\BIApplications\Source\.

Exercises

This Hands-On Lab is comprised of the following exercises:

1. Using the Chart Web Part
2. Performing Analysis with Excel and Excel Services
3. Building a Dashboard with PerformancePoint Services

Estimated time to complete this lab: 60 minutes.