Overview
In this lab, you will learn how Microsoft SQL Server PowerPivot for SharePoint leverages SharePoint 2010 and Excel Services to support centralized management of PowerPivot workbooks to enable collaboration. You will also learn how to configure a PowerPivot site in SharePoint for successfully viewing PowerPivot workbooks and how to publish PowerPivot workbooks to that PowerPivot site. In addition, you will learn about the PowerPivot Gallery views and how to change the default view, and create a linked document based on a PowerPivot workbook and configured a data refresh of the workbook. Finally, you will learn how to build a Reporting Services report using the PowerPivot Web service as a data source, and review the PowerPivot Management Dashboard.
During this lab, we will cover:
- Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
- Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
- Exploring PowerPivot for SharePoint
- nalyzing and Reporting with the Excel 2010 Client
- Developing and Consuming Shared Components in SQL Server 2008 R2 Reporting Services
Registration: To register, please contact me for registration details as this is an invite only training for our managed customers. This special, no charge training series will fill quickly and space is limited, so be sure to register as soon as possible to reserve your seat.
Date
Wednesday October 5th, 2011
Time
9:00am – 1:00pm Pacific Time
Location:
Virtual Hands On Lab Classroom.
Target Audience:
IT Pro, IT Manager
Before the Event:
- Check virtual lab for your computer http://test.vlabcenter.com/hv/default.aspx
- Install the ActiveX control. The Microsoft "Virtual Machine Remote Control" ActiveX control is required to start the virtual lab.
- Review system requirements.
- If you have any issues, please contact support.
What is a virtual hands-on-lab:
This isn’t your typical IT class. A hands-on lab online is an invite only event that combines LiveMeeting with a virtual lab. Attendees and presenters login from anywhere. Attendees watch a brief LiveMeeting presentation, then spend most of the time getting hands-on experience working through all, or just self-selected modules of the entire lab – at their own pace, and receive real–time, personal, one-on-one attention from the presenter. In addition, there’s a proctor available for technical support and to answer more attendee questions.