Tuesday, 21 November 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Exploring PowerPivot for Excel and Power View in SQL Server 2012 - Peter Myers
Author: Grant Paisley Date Posted: 4/10/2011 11:26:43 AM
Join Peter Myers as he presents on what’s new in PowerPivot for Excel and explores Power View.

PowerPivot, first released with SQL Server 2008 R2, is an add-in for Excel 2010 that empowers business users to create their own tabular data models. In this presentation, you will learn how the add-in has been enhanced to include a new designer experience and new modeling features.

Power View is an interactive data exploration, visualization, and presentation experience that provides intuitive ad-hoc reporting for business users. It delivers this experience via SharePoint in the Web browser, and must be based on a tabular BI Semantic Model (either a PowerPivot workbook or a Tabular Project). Ordinarily, the tabular BI Semantic Model will need to be optimized for the Power View experience, and the basics on how to achieve this will be covered in this presentation.

Note: All theory and demonstrations will be based on the latest publicly available version of SQL Server, which is pre-release, and near function complete


About the Presenter
Peter Myers has 13 years' solid experience working in OLTP database design and development, DBA support and Data Warehousing/Business Intelligence with SQL Server.

Specializing in Microsoft Business Intelligence, Peter provides mentoring, technical training and course content authoring for SQL Server and Office. Specifically he works with Integration Services, Analysis Services (cubes and data mining), Reporting Services, Excel, PowerPivot and PerformancePoint Services.

He has a broad business background supported by a bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2006.

Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft technologies by presenting at user group meetings, technical events and conferences.

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) | 6:00PM - 8:00PM Session | On: Tuesday, 13 December 2011