bigclean, nov 2012 filip hráček · google confidential and proprietary big data is hard. 1. data...

Google Confidential and Proprietary

Tools for open dataFilip HráčekBigClean, Nov 2012

Google Confidential and Proprietary

Big data is hard.

1. Data gathering – hard2. Data refinement – hard3. Data analysis – super hard4. Data sharing – hard

Google Confidential and Proprietary

Data gathering

Google Confidential and Proprietary

Public Data Explorerhttp://www.google.com/publicdata/directory

Google Confidential and Proprietary

Fusion Tables (Public)http://research.google.com/tables

Google Confidential and Proprietary

Google Trendshttp://www.google.cz/trends

Google Confidential and Proprietary

Google Trends Correlatehttp://www.google.com/trends/correlate

Google Confidential and Proprietary

Google Ngram Viewerhttp://books.google.com/ngrams

Google Confidential and Proprietary

Data refinement

Google Confidential and Proprietary

Open Refinehttp://code.google.com/p/google-refine/

Google Confidential and Proprietary

Google Confidential and Proprietary

Data analysis

Google Confidential and Proprietary

Big data.

1. Text editor2. Excel3. Local database

Google Confidential and Proprietary

https://bigquery.cloud.google.com/

Google BigQuery

Google Confidential and Proprietary

Google Fusion Tableshttp://www.google.com/fusiontables http://research.google.com/tables

Google Confidential and Proprietary

Data sharing

Google Confidential and Proprietary

Google Fusion Tableshttp://www.google.com/fusiontables

Google Confidential and Proprietary

Google Fusion Tables – in the wildhttp://www.guardian.co.uk/news/datablog/interactive/2011/aug/16/riots-poverty-map

Google Confidential and Proprietary

Google Docs – in the wildhttp://data.blog.ihned.cz/c1-57386250-hledejte-s-nami-fakta-v-projevu-davida-ratha

Google Confidential and Proprietary

Big thank you! (for your attention)

Filip Hráček, Google Czech Republic

Google Confidential and Proprietary

Links

● Public Data Explorer○ Import public data form

● Google Correlate○ Explanation (Comics)

● Ngram Viewer○ Advanced use