Exploring PowerPivot for Excel in SQL Server Project "Denali"
Presenter: Peter Myers
Join Peter Myers as he explores what’s new in PowerPivot for Excel in the upcoming release of SQL Server Project “Denali”. 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 webcast, you will learn how the add-in has been enhanced to include a new designer experience and new modelling features.
The new designer experience includes a diagram view to explore and manage the tabular model, and the measure grid to define, test and format measures and KPIs. The new modelling features include: active/inactive relationships, marking Date tables and columns, sorting by a different column, hierarchies, KPIs, DistinctCount measure aggregation, column and measure format properties, perspectives, and reporting properties.
Note: All theory and demonstrations will be based on the latest publicly available versions of SQL Server, which is pre-release, yet still function complete.
About the Speaker:
Peter Myers has been working with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office. Specifically, he works with SQL Server Integration Services, SQL Server Analysis Services (cubes and data mining), SQL Server Reporting Services, Excel, PowerPivot, and PerformancePoint Services.
He has a broad business background supported by a Bachelor’s degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been an MVP since 2007. Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events, and conferences.