GCP – From operations to planning, G Suite customers scale data insights with Connected Sheets

We recently announced the general availability of Connected Sheets, which brings you the power and scale of a BigQuery data warehouse in the familiar context of Google Sheets. With Connected Sheets, you can analyze billions of rows and petabytes of data in Sheets without specialized knowledge of computer languages like SQL. This makes it easy for anyone, not just data analysts, to apply pivot tables, charts, and formulas to massive datasets and unlock insights.

Our customers use Connected Sheets to enable data-driven decision making across their organizations. We’ve heard many stories about how Connected Sheets has enabled them to achieve operational efficiencies and new ways of unlocking the power of their data; we’d like to share a few here.

Operate with agility

Now more than ever, it’s critical for organizations to react with flexibility and agility to new realities. Connected Sheets helps organizations harness and collaborate on massive amounts of data, making it easier to understand and quickly respond to today’s dynamic landscape. 

The United Nations Office for Project Services (UNOPS) helps the UN and its partners deliver peace and security, humanitarian, and development solutions. As COVID-19 emerged, UNOPS used Connected Sheets to help coordinate a swift global response. Says Tushar Dighe, Chief Information Officer at UNOPS, “When the COVID-19 pandemic started, we needed to quickly assess the status of our operational capacity in order to assist governments with the response. We used a Connected Sheet with data from our BigQuery data warehouse combined with manual status inputs on the same Sheet, where colleagues in more than 80 countries were able to collaboratively provide inputs. The results in the form of pivots and charts were instantly available live. It took less than three hours to design and implement the solution, and we had status information from more than 80 countries within the first 24 hours.”

Improve business and financial reporting

Reports and dashboards displaying business metrics, like revenue figures or operational KPIs, play a critical role in organizations. These reports help sales teams track performance, enable finance teams to make projections, and provide business leaders with a picture of their organization’s health. Especially now, as businesses adapt their planning to reflect the new normal and employees remain dispersed, it’s doubly important that teams can quickly access and collaborate on business and financial dashboards, from wherever they are. But building and maintaining these reports can be time consuming and error-prone, and requests for changes or new views result in manual work for data analysts. All of this just extends the time to insight and action. 

Connected Sheets helps automate report creation, while maintaining a single source of truth for data in BigQuery. The live connection between BigQuery and Sheets also means that data stays fresh, minimizing the risk that people make decisions based on outdated information and avoiding the data integrity risks of manual data pulls. 

Says Alexander Danilowicz, a Software Engineer at data connectivity company Liveramp,“Our Finance team uses Connected Sheets to automate reports that are shared with other stakeholders to run the business. This enables our business partners to analyze and create pivot tables on massive datasets, which is not possible in a traditional spreadsheet.”

“Now that it’s all integrated, there’s no human error involved. Changes can be made at the click of a button, resulting in 10 hours saved per month,” he adds.

Track product adoption

It’s important for teams across the business to understand customer adoption of products and services, whether it’s the product team tracking usage of a newly released feature or the support team trying to anticipate incoming service requests. Similarly,  IT teams need to analyze adoption of an organization’s internal applications and systems, so they know what tools employees are using and how they are being used. But product adoption datasets are often too large for traditional spreadsheets to handle, and new data is continuously being added. 

Connected Sheets can provide teams access to large, powerful, and up-to-date usage datasets, in the familiar Sheets interface. PwC, a global professional services organization, uses Connected Sheets as part of its efforts to make technology and data more accessible across its workforce. One way PwC uses Connected Sheets is to monitor and analyze internal adoption of tools like G Suite. 

Says Peter Van Nieuwerburgh, Global Change Manager at PwC, “If you look at our own adoption dashboarding, it’s more than three terabytes of data—good luck putting that in any spreadsheet. With Connected Sheets, we’re not really pulling the data into the spreadsheet, rather it lives in the database where it belongs. The ability to go and so easily analyze and visualize the data is really powerful.”

We hope Connected Sheets helps to scale data-driven decision making at your organization, by making powerful data easily accessible across your sales, finance, product, and IT teams. Connected Sheets is available to G Suite Enterprise, G Suite Enterprise for Education, and G Suite Enterprise Essentials customers who also use BigQuery. Learn more about Connected Sheets (including how to get started with a BigQuery trial environment at no charge), or watch this in-depth product tutorial.