Hands On Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for Excel Workbook
This Hands On Lab will show you how to build your first SQL Server 2008 R2 PowerPivot for Excel workbook to perform self-service analysis, and how to share it with SQL Server 2008 R2 PowerPivot Server for SharePoint.
This lab will create a PowerPivot workbook that will import data from a SQL Server database and a data feed. The PowerPivot model will be refined by defining relationships and calculated columns. Next, a PivotTable report will be created and measures defined. Finally, the PowerPivot workbook will be published to SharePoint.
The objectives of this exercise are to:
You must have installed the following items to complete this lab:
All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps.
To perform the setup steps you need to run the scripts in a command window with administrator privileges.
This Hands-On Lab comprises the following exercise:
Estimated time to complete this lab: 30 minutes.