Right now listening to Donald Farmer about PowerPivot.
He just showed.how to import a 4 000 000 rows from sql server. Really no magic going on, if you are on a slow network 1 000 000 000 rows will take a loooong time.
Also, since powerpivot is a column based store, datamining wont be available at this point. That ruins the data compression.
You will be able to add additional meta data such as calculated nembers and measures. Many functions, mdx-like, like a lot of time functions. So you can more or less skip olap...
The coolest thing though, is that you can import data from multiple sources, ie sap and the web and define relationships between theese sources.
Inga kommentarer:
Skicka en kommentar