O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data with Power Pivot

Power Pivot is an add-in for Excel that enables business users to create models using disparate data sources. Once the data is gathered, you can build PivotTables, PivotCharts, or Power View reports. For example, a user could import internal business data and mash it up with external data to create an analytical model to share with others in the company. Instead of requiring IT to be involved in building the solution, PowerPivot empowers users to go beyond requirements and actually build a solution. If the solution is required for the enterprise, the PowerPivot model can be used as the basis for the tabular model deployed to the server.

Getting ready

Before you can use PowerPivot for the first time, you will need ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required