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.
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!!!