Excel 2010 – Business Intelligence for the end user

This is totally awesome…


Code named Gemini, PowerPivot is an addin for Excel 2010 which gives you BI out of the box.

There's still the need for a decent data warehouse, so Database guys like me will still be required.

Given the nature of most data out there, this is both great and dangerous at the same time.

What's really compelling is the ability to suck in data from the web to compare your current data with.


There's also the PowerPivot server option in SharePoint 2010.
Note: You need to install SharePoint 2010 and not configure it and then install Sql2008R2 to let the magic begin.


Most people will only install the 32 bit version of Excel 2010 - the 64 bit is for those business analysts using PowerPivot to the extreme..as long as they have more than 4G of RAM on their desktop.

Regards,

Tom Bizannes
http://www.macroview.com.au