Follow this blog:
RSS

How to visualize data using Google Fusion Tables

By | July 17, 2011, 11:02 AM PDT

MOUNTAIN VIEW, Calif.– Last week, I stopped by Alon Halevy’s office to learn how to visualize large data sets onto a map.

Halevy, who heads the Data Group at Google Research, walked me through the data platform:

The problem with data is that it’s ugly to look at. Nobody wants to look at an Excel spreadsheet to try to figure out the trends. Not to mention, in the age of Google docs and our Facebook sharing nature, collaborating with people on big data sets isn’t that easy to do.

That’s the idea behind Google Fusion Tables, a cloud-based data management system that was launched in June 2009. It was originally designed for organizations who wanted to make their data available online, so companies could share their data internally or externally. Users upload their data files in various formats such as a spreadsheet or Comma Separated Values and can upload data sets up to 100MB.

Here are some applications of the tool:

  • ecologists in Costa Rica who want to maintain records of specimens and include genetic information produced by a lab in Canada
  • non-profit that wants to publish data about water resources
  • The International Coffee Organization collects and shares information about coffee exports and imports
  • an epidemiologist who wants to illustrate disease trends

Halevy explains how to use the tool and encourages more people and corporations to share their data.

Here is a detailed support page that should answer most of your questions, along with some examples of how data visualization has been used.

The Guardian’s Simon Rogers is a power user, who has done a great job of using data visualizations to tell stories based on data.

New Scientist’s Peter Aldhous used Google Fusion Tables to map hydrothermal vent fields:

Aldhous also used Google Fusion Tables and Tableau to get a better idea of what is going on with tornadoes. It’s clear that 2011 has been deadly, if you look at what’s been going on historically. Click here to interact with the map.

Google Fusion Tables is a good for mapping and for collaborating with others. But if a customer or business wants more help, a service like Tableau Software would provide a more hands-on experience. Flowing Data is a blog that features visualizations from around the web.

Chris Anderson wrote in Wired about the end of theory, saying that sensors and access to the cloud will give us access to data on the petabyte scale.

True. The amount of data is exploding. “15 out of 17 sectors in the United States have more data stored per company than the US Library of Congress,” according to a recent McKinsey report. “Companies and policy makers must tackle significant hurdles to fully capture big data’s potential.”

It’s what you do with the data that matters. As tools to handle and make sense of the data improve, it will be easier to spot disease trends, identify business trends and clarify current affairs such as mapping 186 medical marijuana dispensary locations in Los Angeles.

Related on SmartPlanet:

Start your week smarter with our weekly e-mail newsletter. It's your cheat sheet for good ideas. Get it.

Boonsri Dickinson

About Boonsri Dickinson

Boonsri Dickinson was a contributing editor for SmartPlanet from 2010 to 2012.

Boonsri Dickinson

Boonsri Dickinson

Contributing Editor

Boonsri Dickinson is a freelance journalist based in San Francisco. She has written for Discover, The Huffington Post, Forbes, Nature Biotech, Technewsdaily.com, Techstartups.com and AOL. She's currently a reporter for Business Insider. She holds degrees from the University of Florida and the University of Colorado at Boulder.

Follow her on Twitter.

Boonsri Dickinson

Boonsri Dickinson

In the unlikely event that Boonsri has a professional or financial relationship with a company she writes about, it will be prominently disclosed.

She writes for SmartPlanet and is not an employee of CBS.

If you liked this, don't miss...
2
Comments

Join the conversation!

Follow via:
RSS
0 Votes
+ -
Thank you very much
Well done! Thank you very much for professional templates and community edition
sesli chat sesli sohbet
Posted by yarinsiz
Updated - 24th Aug 2011
0 Votes
+ -
jkl
points. sac louis vuittonAinsi, plus le taux de la BCE est bas, plus le co? louis vuitton site officiel"C???est ce qui s???est toujours fait ?? la RTBF, a confirm?? ?? Lib??ration le directeur de la r??daction de la RTBF,? sac vuittonEn r??action, la Bourse de Paris, qui avait commenc?? dans le rouge jeudi matin, a imm??diatement rebondi. sacs louis vuittonLa BCE n'avait pas baiss?? ce taux depuis mai 2009, o?? il ??tait ?? son plus bas niveau historique, ?? 1? Rien ne nous le garantit?!A attribu?? par les agences de notation s'ils ne parviennent pas ?? pr??senter un bon train de mesures.? Qu'est-ce que le principal taux directeur de la BCE??Les sites internet, les radios et les cha? louis vuitton pas cheraise ne s???applique pas en Belgique, r??pond-il.? Louis Vuitton Sac Toile
Posted by michael kors handbags
14th May 2012
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the SmartPlanet community and join the conversation! Signing up is fast and free. Don't wait -- we want to hear your opinion!