Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Google Docs can access data from BigQuery

with 5 comments

I don’t know how I missed this news from last week (luckily I saw it relayed here), but this is important: Google have announced that you’ll be able to access data stored in BigQuery direct from Google Docs:
http://googledata.org/google-docs/bigquery-meet-google-spreadsheets/

I’ve been following BigQuery and Google’s BI efforts for a while, and it looks like it’s only a matter of time before they have something resembling a pivot table built into a Google Docs spreadsheet – and that would be a very significant development in the world of web-based BI. Think about it: vast amounts of data stored in BigQuery, accessible through a SQL-like interface and able to be queried very quickly; a spreadsheet on the front; all that’s needed is some kind of OLAP-like-layer in between to make it easy for end users to build their own queries. And Google have done similar things to what’s necessary here with Fusion Tables and their collaboration with Panorama

Microsoft really need an answer to this. We know SSAS in the cloud is coming, and we have the Excel web app, but again we need pivot table support in the web app to complete the picture (see here and here for more discussion on this topic). I hope it comes soon!

Written by Chris Webb

January 12, 2011 at 4:57 pm

Posted in Google

Tagged with

5 Responses

Subscribe to comments with RSS.

  1. Hi Chris,

    Any idea how you get large volumes of data up to the Google cloud in the first place? Also, any ideas on how secure you can make that for skeptical IT Corporates.

    Genuinely interested to hear your thoughts.

    Cheers,

    Mike

    Mike Askew

    January 13, 2011 at 4:34 pm

    • Well, those would be the other big questions that Google would need to answer before it had a viable cloud-based BI option and we’re clearly a long way from that.

      But you could argue that if the data was already in the cloud anyway, then doing the cloud would be the obvious place to do BI on it; I also think that if you have terabytes of data to analyse and the choice is between uploading it to Google, or spending several million dollars on buying a MPP data warehouse appliance, or just not being able to analyse it, then uploading the data to Google (possibly in a continuous stream as the data is generated rather than in several TB chunks) looks like an attractive idea.

      Chris Webb

      January 13, 2011 at 4:49 pm

  2. Hi Chris,
    How quickly do you think a user would be able to analyze the data with BigQuery? I have a few large spreadsheets and very long docs on my personal google apps, and the larger they get, the longer opening them takes–currently I have to push the scripts several times to be able to access the largest spreadsheet.

    Claire

    January 18, 2011 at 8:44 pm

    • Based on what Google says, BigQuery should be able to handle billions of rows of data very quickly – much faster than any spreadsheet. But that’s what Google says, I’ve not tried it myself.

      Chris Webb

      January 18, 2011 at 9:18 pm

  3. [...] develops in the future and integrates with the rest of the Google stack (it’s already possible to hook it up to Google docs with a bit of coding). I will, of course, be equally interested to see what Microsoft’s cloud BI [...]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,302 other followers

%d bloggers like this: