How PowerPivot differs from SSAS Tabular, and using it to prototype data models
Part one of a four-part series of blogs

PowerPivot is virtually identical to SSAS Tabular underneatht the glossy exterior, but it has got a few extra features explained in this blog (which also shows how to import PowerPivot data models into Analysis Services, and why you might want to do this).

  1. Using PowerPivot with Analysis Services (tabular) (this blog)
  2. Using PowerPivot
  3. The 3 main differences between PowerPivot and SSAS
  4. Importing PowerPivot data models into SSAS Tabular

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 18 February 2016

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Using PowerPivot with Analysis Services (tabular)

This blog shows how to create models in PowerPivot, and how (and why) to then import them into your Analysis Server database.

This blog isn't a tutorial on how to use PowerPivot; instead, it shows how PowerPivot differs from SSAS, and how you can use it to prototype data models before importing them into Analysis Services.

This blog covers the following topics:

Topic Notes
Using PowerPivot How to install and run PowerPivot, and how to use it to create data models and pivot tables.
Differences between PowerPivot and SSAS The ways in which PowerPivot differs from Analysis Services (tabular model).
Prototyping in PowerPivot Why you might choose to import a data model developed in PowerPivot into Analysis Services, and how to do this.

I'll start with a quick guide to how to use PowerPivot to create data models and pivot tables.

This blog has 0 threads Add post