谷歌中国开发者社区 (GDG)
  • 主页
  • 博客
    • Android
    • Design
    • GoogleCloud
    • GoogleMaps
    • GooglePlay
    • Web
  • 社区
    • 各地社区
    • 社区历史
    • GDG介绍
    • 社区通知
  • 视频
  • 资源
    • 资源汇总
    • 精选视频
    • 优酷频道

Connecting BigQuery and Google Sheets to help with hefty data analysis

2019-01-16adminGoogleCloudNo comments

Source: Connecting BigQuery and Google Sheets to help with hefty data analysis from Google Cloud

As enterprises amass terabytes of complex data, they need tools to house and make better sense of their information. This is why we’ve built BigQuery, to help data analysts deal with large datasets. But not all of us are data wizards. Many of us use spreadsheets to perform ad-hoc analysis.

We want to make it easier for employees outside of data analytics functions to run queries, like analyzing sales data, so we’re combining the power of BigQuery and Google Sheets to make that possible. The Sheets data connector for BigQuery will be generally available to G Suite Business, Enterprise and Education customers in the coming weeks.

Sheets data connector for BigQuery.png

With the Sheets data connector for BigQuery, you can analyze and share large datasets from BigQuery right from within your spreadsheet. Connect up to 10,000 rows of data from BigQuery into Sheets (with a simple SQL statement that you can get from a data analyst), and analyze it using the Explore feature, or by creating charts or pivot tables, in your spreadsheet. As always, you can control share permissions to limit who can view, edit or share your data. Those with “edit” access in Sheets and the BigQuery table have the ability to refresh the dataset.

You can also use the data connector to:

  • Collaborate with partners, analysts or other stakeholders in a familiar spreadsheet interface. 
  • Ensure a single source of truth for data without having to create additional CSV exports.
  • Streamline your reporting and dashboard workflows.

Yahoo! data analysts have found the connector helpful in simplifying workflows. Says Nikhil Mishra, director of Engineering at Verizon Media, “The data connector for BigQuery saves our analysts time and errors by reducing multiple steps otherwise needed to get data into spreadsheets.”

Take it a step further

Doing analysis in Sheets is most useful when the data is up-to-date. In the coming weeks, you’ll be able to use tools like Apps Script and the macro recorder to schedule automatic updates to the connected BigQuery data. For example, you can automatically refresh data in your spreadsheet so that when you turn on your computer at the beginning of your day, your data is fresh and ready for analysis. If you’re curious about how to record or run macros in Sheets, check out this G Suite Pro Tip to learn more.

除非特别声明,此文章内容采用知识共享署名 3.0许可,代码示例采用Apache 2.0许可。更多细节请查看我们的服务条款。

Tags: Cloud

Related Articles

Exploring container security: This year, it’s all about security. Again.

2018-12-11admin

Better cost control with Google Cloud Billing programmatic notifications

2018-05-24admin

Advancing confidential computing with Asylo and the Confidential Computing Challenge

2019-02-07admin

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Recent Posts

  • New UI tools and a richer creative canvas come to ARCore
  • Introducing PlaNet: A Deep Planning Network for Reinforcement Learning
  • AI in depth: monitoring home appliances from power readings with ML
  • AI in depth: monitoring home appliances from power readings with ML
  • AI in depth: monitoring home appliances from power readings with ML

Recent Comments

  • Chen Zhixiang on Concurrent marking in V8
  • admin on 使用 Android Jetpack 加快应用开发速度
  • 怪盗kidou on 使用 Android Jetpack 加快应用开发速度
  • 鸿维 on Google 帐号登录 API 更新
  • admin on 推出 CVPR 2018 学习图像压缩挑战赛

Archives

  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • January 1970

Categories

  • Android
  • Design
  • Firebase
  • GoogleCloud
  • GoogleDevFeeds
  • GoogleMaps
  • GooglePlay
  • Google动态
  • iOS
  • Uncategorized
  • VR
  • Web
  • WebMaster
  • 社区
  • 通知

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

最新文章

  • New UI tools and a richer creative canvas come to ARCore
  • Introducing PlaNet: A Deep Planning Network for Reinforcement Learning
  • AI in depth: monitoring home appliances from power readings with ML
  • AI in depth: monitoring home appliances from power readings with ML
  • AI in depth: monitoring home appliances from power readings with ML
  • Run cron jobs reliably on Compute Engine with Cloud Scheduler
  • Run cron jobs reliably on Compute Engine with Cloud Scheduler
  • Run cron jobs reliably on Compute Engine with Cloud Scheduler
  • Introducing scheduled snapshots for Compute Engine persistent disk
  • Revevol: How we built a BI dashboard with GCP to track G Suite adoption

最多查看

  • 谷歌招聘软件工程师 (21,002)
  • Google 推出的 31 套在线课程 (20,072)
  • 如何选择 compileSdkVersion, minSdkVersion 和 targetSdkVersion (18,624)
  • Seti UI 主题: 让你编辑器焕然一新 (12,670)
  • Android Studio 2.0 稳定版 (8,958)
  • Android N 最初预览版:开发者 API 和工具 (7,934)
  • 像 Sublime Text 一样使用 Chrome DevTools (5,947)
  • Google I/O 2016: Android 演讲视频汇总 (5,519)
  • 用 Google Cloud 打造你的私有免费 Git 仓库 (5,496)
  • 面向普通开发者的机器学习应用方案 (5,193)
  • 生还是死?Android 进程优先级详解 (4,969)
  • 面向 Web 开发者的 Sublime Text 插件 (4,134)
  • 适配 Android N 多窗口特性的 5 个要诀 (4,103)
  • 参加 Google I/O Extended,观看 I/O 直播,线下聚会! (3,472)
© 2018 中国谷歌开发者社区 - ChinaGDG