{"id":14746,"date":"2019-04-11T09:08:46","date_gmt":"2019-04-11T09:08:46","guid":{"rendered":"https:\/\/rsoftsolution.com\/blog\/google-makes-the-power-of-bigquery-available-in-sheets.html"},"modified":"2019-04-11T09:08:46","modified_gmt":"2019-04-11T09:08:46","slug":"google-makes-the-power-of-bigquery-available-in-sheets","status":"publish","type":"post","link":"https:\/\/www.rbsitsoftwaresolution.in\/blog\/google-makes-the-power-of-bigquery-available-in-sheets.html","title":{"rendered":"Google makes the power of BigQuery available in Sheets"},"content":{"rendered":"

Google <\/a> today announced a new service that makes the power of BigQuery<\/a>, its analytics data warehouse, available in Sheets, its web-based spreadsheet tool. These so-called \u201cconnected sheets\u201d face none of the usual limitations of Google\u2019s regular spreadsheets, meaning there are no row limits, for example. Instead, users can take a massive data set from BigQuery, with potentially billions of rows, and turn it into a pivot table.<\/p>\n

The idea here, is to enable virtually anybody to make use of all the data that is stored in BigQuery. That\u2019s because from the user\u2019s perspective, this new kind of table is simply a spreadsheet, with all of the usual functionality you\u2019d expect from a spreadsheet. With this, Sheets becomes a front end for BigQuery \u2014 and virtually any business user knows how to use a spreadsheet.<\/p>\n

\"\"<\/a><\/p>\n

This also means you can use all of the usual visualization tools in Sheets and share your data with others in your organization.<\/p>\n

\u201cConnected sheets are helping us democratize data,\u201d says Nikunj Shanti, chief product officer at AirAsia. \u201cAnalysts and business users are able to create pivots or charts, leveraging their existing skills on massive data sets, without needing SQL. This direct access to the underlying data in BigQuery provides access to the most granular data available for analysis. It\u2019s a game changer for AirAsia.\u201d<\/p>\n

The beta of connected sheets should go live within the next few months.<\/p>\n

In this context, it\u2019s worth mentioning that Google also today announced the beta launch of BigQuery BI Engine, a new service for business users that connects BigQuery with Google Data Studio for building interactive dashboards and reports. This service, too, is available in Google Data Studio today and will also become available through third-party services like Tableau and Looker in the next few months.<\/p>\n

\u201cWith BigQuery BI Engine behind the scenes, we\u2019re able to gain deep insights very quickly in Data Studio,\u201d says Rolf Seegelken, senior data analyst at Zalando. \u201cThe performance of even our most computationally intensive dashboards has sped up to the point where response times are now less than a second. Nothing beats \u2018instant\u2019 in today\u2019s age, to keep our teams engaged in the data!\u201d<\/p>\n

<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Google today announced a new service that makes the power of BigQuery, its analytics data warehouse, available in Sheets, its web-based spreadsheet tool. These so-called \u201cconnected sheets\u201d face none of <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[19],"tags":[25],"class_list":["post-14746","post","type-post","status-publish","format-standard","hentry","category-enterprise-software","tag-enterprise"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t