Project Gemini has a new name, Power Pivot. A little over 1 year ago (original post here) Project Gemini surfaced as “an Excel-based user analytics mashup tool” to bring previously high-end OLAP cube style functionality to the masses…and now, at the Sharepoint Conference 2009, it has been announced in the form of Power Pivot.
The video (featuring the dude above) says that it can easily bridge different databases, give real time updates and be quickly shared via Sharepoint 2010…as well as working with millions of rows of data! Microsoft say:
“Sort, filter, and scroll through millions of rows with about the same performance as a few thousand.”
so they’ve made some real leaps forward in performance.
It turns Excel into a much richer, more eye-pleasing and user friendly BI tool as you can see below.
I haven’t seen any info about licensing etc but it’s called “PowerPivot for Excel” and the video shows it as a separate box copy, so I’m assuming it will be a product available to buy separately-rather than being bundled with Excel. <—Having said that, the datsheet claims it is available to download free of charge from www.powerpivot.com …it isn’t there yet but is that how it will be?
I’ll try and clear this up and post the answer here ASAP 🙂