Excel Services

In this lab you will learn how to add Business Intelligence (BI) capabilities to your SharePoint Online site using Excel Services.

Overview

Lab Time: 45 minutes.

Lab Folder: C:\%Office365TrainingKit%\Labs\5.1

Lab Overview: The purpose of this lab is to demonstrate the Business Intelligence (BI) capabilities available in SharePoint Online using Excel Services. You will begin by using the Chart Web Part to create graphical representations of data within SharePoint lists. Next, you will take an existing Excel workbook that displays BI information and publish the workbook with Excel Services to make it accessible to users via the browser. Finally, you will expose Excel chart data using the REST API.

In this lab, you will be working with sales data that has been generated from the AdventureWorks database. The AdventureWorks data on sales revenue spanning six different counties.

System Requirements

You must have the following items to complete this lab:

• SharePoint 2010
• SharePoint Designer 2010
• Visio 2010
• Visual Studio 2010
• SharePoint Online
  • Note: You will need administrator access to an SPO site collection to perform the steps in this lab.