Using Connected Sheets to analyze BigQuery data

https://storage.googleapis.com/gweb-cloudblog-publish/images/09_-_Data_Analytics_tFH57V6.max-2600x2600.jpg

Many organizations’ single source of truth is data that resides in BigQuery, Google’s governed, secure and petabyte-scale data platform. However, the "last mile" of ad-hoc analysis, modeling, and reporting often happens where business users are most comfortable: Google Sheets.

Bridging this gap usually involves exporting data as CSVs. But this is inefficient, creating data silos, version control problems, and security and governance risks. Connected Sheets helps to eliminate this trade-off, turning the familiar Google Sheets interface into a direct, live window into your BigQuery data platform, letting you analyze petabytes of data quickly, securely, and easily.

In this post, we’ll do a quick overview of Connected Sheets, walk through real-world use cases, and show you how to perform enterprise-grade data analysis using BigQuery directly in Google Sheets.

A live window into the single source of truth

Business users often wait days or weeks for simple reports. Connected Sheets solves this...

Copyright of this story solely belongs to google.com. To see the full text click HERE

Read more

https://assets.bwbx.io/images/users/iqjWHBFdfxIU/iVgbUGzh6SJY/v0/1200x800.jpg

WiseTech co-founder Richard White steps down as chair amid a police probe over claims he exploited a woman's immigration status for sex; WTC jumps 7%+

More: XBOX Wire, Kotaku, IGN, Game File, The Verge, Aftermath, Kotaku, Reuters, The Information, Game Developer, GamesIndustry.biz, The Information, Forbes, Polygon.com, Rock, Paper, Shotgun, PC Gamer, Double Fine, Push Square, GamesRadar, Business Insider, Comic Book, Pure Xbox, Aftermath, GeekWire, The Hollywood Reporter, Phandroid, Fast Company, TheGamer, The Tech