PowerPivot 101 – an Introduction

If you showed a business analyst or finance guy how to manipulate a whole year’s worth of data in Excel they’ll probably buy you lunch.  PowerPivot for Excel does just that, but before you cash in, you need to be aware of how it works its magic and understand why it compliments rather than replaces your existing investment in business intelligence.

First of all having this power in Excel can be seen as a two edged sword..

Read more...