Google Spreadsheet Visualization

Written by Kin Lane
Apr 9, 2009

I came across a cool tool that allows you to visual data in Google Spreadsheets, using the Secure Data Connector.

It is a reporting tool that will connect to any Google Spreadsheet and create very advanced visualizations of the data contained in there.

• Here is an overview of this tool: http://news.prnewswire.com/DisplayReleaseContent.aspx?ACCT=104&STORY=/www/story/04-08-2009/0005002822&EDATE=
• Here is a demo of the actual tool: http://pivot.panorama.com/Panorama/FoodMart.htm (make sure and drill down in the spreadsheet, its huge)
• Here is a video explaining how its used: http://www.panorama.com/google/pivot-table-tutorial/

What does this mean in short?

It means you can basically use Google Spreadsheets as a data warehouse and dump data through the API into spreadsheets from any other system.

You can then provide an interactive visualization of that data in a full or widget view that you can embed anywhere.

Pretty slick stuff!!!

---

← Previous

Next →