In this lab you will learn how to add Business Intelligence (BI) capabilities to your SharePoint Online site using Excel Services.
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.
You must have the following items to complete this lab: