SQL Server Tools, Tricks, and Techniques

SQW09 Implementing a Tabular Data Model with Microsoft PowerPivot and Analysis Services


1:45pm - 3:00pm

Arman Saffarnia

Principal Consultant


Microsoft PowerPivot technologies empower information workers and business intelligence (BI) professionals by delivering in-depth, up-to-date insights through familiar business tools. PowerPivot for Microsoft Excel empowers information workers and BI professionals to create powerful, sophisticated reports that can dynamically group, sort, and recalculate data at the click of a button. PowerPivot for Microsoft SharePoint 2013 provides a platform for sharing PowerPivot for Excel workbooks with a wider audience, helping to promote collaboration and enable consistent and accurate decision making through central governance of key business information.

With Microsoft SQL Server 2012, you can install Analysis Services in Tabular mode and create Tabular data models that information workers can query with any Analysis Services client, including Microsoft Excel and Power View. This session describes Analysis Services Tabular data models and explains how to develop one using SQL Server Data Tools. It also describes Analysis Services Tabular data model projects, the workspace database, partitions, Tabular data model security and more.

You will learn:

  • Key features and benefits of Tabular data models and PowerPivot technologies
  • Understand the process of creating a PowerPivot for Excel workbook, and sharing one to a SharePoint PowerPivot Gallery, and querying one directly
  • About Analysis Services Tabular data model projects
  • Understand the process of implementing an Analysis Services Tabular data model using SQL Server Data Tools