1 of 11Image
Google made its BigQuery service public on May 1st. Though the name sounds like “Big Data,” Google’s offering is really a self-service Business Intelligence (BI) solution, hosted in the cloud. In this gallery, I'll tell you how it works.
BigQuery is a cloud-based data analytics system from Google. It lets you upload data, then analyze it using SQL (Structured Query Language) as the query interface. BigQuery lets you query up to 100GB of data per month for free. Just create a Google Developer account for yourself, create a new project and enable BigQuery within it.
Click on any image to enlarge.
BigQuery offers a simple, easy to master browser console, providing for dataset browsing on the left and SQL querying on the right. When queries are returned, options appear to let you save the results in alocal CSV file or create a new table containing the result set’s content.
A simple query against the sample github_timeline table is shown here. The first few rows from the results of the query appear on the bottom-right of the screen, along with navigation controls that allow you to page through the data. Note the “Save as Table” and “Download as CSV” options, which work nicely in Chrome and FireFox. Unfortunately, the "Save as Table" option is not available in Internet Explorer (nor is a file upload option we'll look at shortly). Everything in BigQuery also works nicely in Safari on the iPad, though you can’t save or upload local files there either.