This looks interesting …. see the link here
Panorama Pivot Table for Google Docs is an interactive table that automatically extracts, organizes, and summarizes your data. You can use this report to analyze the data, make comparisons, detect patterns and relationships, and discover trends. In just a few steps any users can find answers such as the best selling region, and best selling product or analyze results of an academic research. With Panorama Pivot Tables for Google Spreadsheets, you can interact with the data and look at it in various ways in a simple drag and drop environment.
The Pivot Table for Google Docs is developed by Panorama, who were, interestingly enough, the original inventors of Microsoft Analysis Services OLAP (Online Analytic Processing) engine. So now, part of Panorama code will be inside two of the biggest software companies in the world!
With this new feature, every Google spreadsheet user will have access to powerful OLAP, as a free BI SaaS add-on to Google Docs. In my opinion – a very wise move by Google to continue to push Google Docs into enterprises.
In order to compete with Excel, among many other features, Google spreadsheets lacked specific business functionality needed to analyze vast amounts of data stored in these spreadsheets. With Panorama free add-on Google spreadsheets, users can now take advantage of this lightweight – but still very respectable and powerful – OLAP engine. Yes, out of the box native pivot tables in spreadsheets can do basic analysis on rows and columns of data, but Panorama takes it much farther with more powerful OLAP functions like (I don’t actually know yet what subset of full Panorama OLAP functionality is available as Google add-on):
- Drill up/down
- Drill across / Drill through / Drill anywhere
- Combine/merge/split dimensions
- Exception handling and conditional formatting