Why PowerPivot is Better Fed From a Database

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

In a post last week I mentioned that when you use a real database as a source for PowerPivot, a number of unexpected doors open up. As a longtime Excel pro who has spent the past two years working closely with a database team, I can tell you that it's been an eye opening experience.

So I have been advocating to Excel/PowerPivot pros for quite some time that they cozy up to their database teams (if they have them). Of course, this works both ways, and I have also been advocating to Database/BI pros that they embrace and cooperate with Excel/PowerPivot pros.

Read more Part 1 ...

Read more Part 2 ...

 

Tags: excel, compare

 

2007-2015 VidasSoft Systems Inc.