Why use a dimensional data model for PowerPivot

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Why use a dimensional data model for PowerPivot? This is not about why one should, or should not, convert an OLTP model into a dimensional one, this post looks at the why from another direction i.e. morphing a "flat" table model as used to feed traditional Excel Pivot Tables (and other pivoting platforms) into a more PowerPivot/DAX friendly format.

Read more...

Tags: design

 

2007-2015 VidasSoft Systems Inc.