BI, Big Data, and Data Visualization

SQW03 Through Gardens Overgrown: PowerPivot to Analysis Services 2012 Tabular

11/20/2013

9:15am - 10:30am

Level: Intermediate

William Pearson

William E. Pearson III

Business Intelligence Architect and Founder

Island Technologies Inc.®

In this presentation, Analysis Services Maestro and SQL Server MVP Bill Pearson overviews the steps required to "upgrade" an Excel PowerPivot model to an SSAS 2012 Tabular model using SQL Server Data Tools (SSDT). We'll discuss motivations behind moving to SSAS 2012 Tabular, including PowerPivot model size challenges for the client environment, both from the perspective of processing and querying optimization. We will then undertake a walkthrough of the steps required to convert a model designed in PowerPivot to a server - level Tabular model.

You will learn:

  • Understand reasons for "upgrading" a PowerPivot model to an SSAS Tabular model
  • Be able to create and configure a new SSAS 2012 Tabular Project using SQL Server Data Tools, and import PowerPivot metadata into the project
  • Understand the components of an SSAS 2012 Tabular Project and be able to Deploy and Navigate the newly created SSAS 2012 Tabular Project, as well as to use it as a source with previously created reports and PivotTables