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.

About Usha Martin

Founded more than 50 years ago and headquartered in Kolkata, India, Usha Martin is a leading steel and wire rope manufacturer. The company’s products are used in sectors such as oil and gas, aerial haulage, and general engineering.

Industries: Manufacturing

Location: India

Usha Martin operates several wire and rope manufacturing plants in India, Thailand, the United Arab Emirates, and the United Kingdom. In 1974, Usha Martin established an integrated alloy steel plant in Jamshedpur, India.

The business operates a range of joint ventures internationally, including a partnership with Joh Pengg AG of Austria to produce oil-tempered wire for the automotive industry and a venture with TESAC of Japan to manufacture and sell specialized wire rope.

Usha Martin’s ICT strategy had traditionally been highly localized, with independent IT infrastructures in all the manufacturing plants and businesses globally. These infrastructures were not integrated, leading to extensive duplication of effort and activities across the business.

In 2016, Usha Martin corporate started a project to integrate ICT across the business and establish centralized financial and technology controls.

“We established a program to integrate our communications infrastructure, security policies, and software licenses and implement a centralized enterprise resource planning system across our business,” says Jayanta Bhowmik, SVP-IT and CIO, Usha Martin. This program is being initiated primarily in Usha Martin’s Indian businesses before being extended to international markets.

In parallel with these initiatives, Usha Martin decided to consolidate the disparate email infrastructures and systems used by its corporate team, plants, and business units.

“We faced security threats and control problems managing and interconnecting all our very different email systems,” Bhowmik says.

“For example, we experienced on average about three to four ransomware attacks every year. We decided there was no alternative but to deploy a centralized email system.”

Usha Martin weighed its options and went so far as to purchase a license to run a single email system on its in-house infrastructure. However, the challenges of migrating a 4,000-strong workforce from up to seven existing email systems to an in-house platform proved difficult to overcome.

“We would have had to plan for server infrastructure, backups, security, and disaster recovery and execute smoothly, which would have been a time-consuming, expensive exercise,” Bhowmik says. “We estimated an in-house deployment would take seven to eight months to complete.”

“We looked at cloud-based services and Google presented a unique opportunity for us to consolidate our email without having to plan for our own infrastructure and worry about project planning, architectures, and deployment,” Bhowmik says.

“We also considered another service, but realized Google also gave us the opportunity to move our personal productivity applications to G Suite.”

A competitive evaluation regarding hosting and disaster recovery confirmed Usha Martin’s positive impressions. Google technology and processes in these areas outstripped the capabilities of the company’s own data centers.

“Google came up with a migration timeline and process that met our needs, with an expert partner to ease the transition,” Bhowmik says. “This was extremely important as the change represented a paradigm shift for a business that is very traditional and conservative.”

The Google partner worked closely with the internal Usha Martin team to complete phase one of the migration to the senior executive team. The partner also undertook training and worked with the IT team to hold meetings at various plants and locations to explain the changes. In addition, the partner conducted a skills transfer exercise to enable Usha Martin team members to complete the remaining phases of the project.

The business migrated the 1,500 team members in its Indian operations, as well as those in its Austrian joint venture, to the new platform.

“Using Google gives us wonderful alternatives to traditional systems,” Bhowmik says. “For example, using Google Hangouts Meet for video calls means we can reduce the number of video conferences that occupy large rooms and help ensure there are enough time-slots to meet demand.”

Improved Security of Information and Systems

One of the key differences between Usha Martin’s existing email systems and Gmail is the improvement in security and online safety.

“We had an anti-spam engine but, despite this, our employees received a lot of spam emails and messages carrying ransomware viruses,” Bhowmik says.

“With G Suite, we don’t receive these messages anymore and we minimize the risk of our network being compromised by malicious infections that could prevent us from accessing our files.”

Using G Suite has reduced team members’ use of USB drives to share large files that would otherwise be blocked due to email attachment limits.

“In addition, people are reducing the practice of printing documents for meetings. One person in each meeting can now steer and control documents, reducing duplication and the possibility of errors.”

“Document sharing is now happening much more in the cloud rather than through external media, improving control and security,” Bhowmik says.

Manage Calendars More Effectively

G Suite now enables Usha Martin team members to manage their calendars more effectively and share documents with multiple people without having to aggregate feedback or manage version control.

“Thanks to G Suite, our people are coming into a world of collaboration and modernization,” Bhowmik says.

Whether they’re reading the newspaper on the way to work, or catching up on the latest headlines on their smartphones, readers expect up-to-the-minute news wherever and whenever makes the most sense for them. As a result, media companies are increasingly looking for ways to improve, expand, and simplify their offerings, and they’re increasingly looking to the cloud to do it.

For more than 160 years The Telegraph has been counted on by readers across the United Kingdom and globally for award-winning news and journalism. An early adopter of cloud technology, it’s been a G Suite customer since 2008 and has already been using Google Cloud Platform to analyze digital behaviors to improve engagement and advertising performance since 2016.

Recently, The Telegraph announced it’s migrating fully to Google Cloud. By migrating all their production and pre-production services, they aim to deliver content faster, provide compelling experiences to readers, and reduce environmental impact.

“We are delighted to announce our newest collaboration with Google Cloud,” said Chris Taylor, Chief Information Officer, The Telegraph. “We have always worked closely with Google as they help us to provide our readers with great experiences on our digital products, collaboration software and internet scale through search. Their continued leadership in projects such as Kubernetes are enabling us to build flexible development environments that truly support DevOps.”

Powering the Digital Publishing Ecosystem

The Telegraph produces large volumes of digital content every day. It was imperative for them to find a cloud provider they could trust to support this ecosystem. By working with Google Cloud they have changed the way they see and engage with data: they can collect new information about their products every second and use that to continually hone their strategy. The Telegraph are placing more confidence and trust in the data captured about their content and now have one of the best available pieces of technology for capturing and analyzing the stories they publish in real-time.

Leveraging AI to support journalists

Time is critical when journalists are on a story, and The Telegraph wants to put important data in the hands of its journalists right when they need it. To do this, it will be using AutoML to classify content for journalists and make it more discoverable. For example, a reporter will be able to bring up relevant assets that link to their stories. It will also apply AutoML to classify Telegraph stock photos to help journalists attach compelling visual content to their stories faster.

Building compelling reader experiences with the help of APIs

Readers have an ever-increasing expectation of personalization. To meet this need, The Telegraph launched My Telegraph, currently live in beta, to offer registered readers personalized news experiences based on their interests or the particular journalists they want to follow. My Telegraph was developed on an API management platform provided by Google Cloud’s Apigee. You can learn more about how it’s applying API management to My Telegraph, in this blog post.

Working for environmental good

The Telegraph is the biggest selling quality newspaper in the UK, an accolade which requires it to print and distribute hundreds of thousands of copies each day. Optimal management of print production is important, and by using a combination of the cloud and machine learning, The Telegraph is better able to predict demand for physical newspapers, maximizing sales and minimizing waste. This makes great business sense for The Telegraph but also has great environmental benefit.

In previous blog posts, we’ve discussed the benefits that organizations can reap by measuring and then optimizing their overall ESG impact. In this post, we’ll look at the endgame: sustainable transformation into an organization that continually adapts to maximize its resilience while reducing risk. Where will my customers be with the evolving global community landscape? How can I design communities and products with sustainability in mind? Are my assets exposed to physical climate risk — drought, flood, wildfire? Adaptation and resilience are the board and legislative focus areas that the ambition loops created by Google Cloud Ready – Sustainability seek to accelerate. 

This is especially important due to the scrutiny of governments and financial institutions as they evaluate the viability of physical asset investments. These organizations want assurances that their investments will not be under undue environmental risk. Similarly, companies embarking on net-zero transitions can realize interest expense savings by providing the measurable, accountable assurances their financiers demand.

Leveraging analytics for climate and business resilience

We’ve said it before, but it bears repeating: The Google Cloud Ready – Sustainability program challenges the notion that sustainability is just a nice-to-have or merely good PR. Rather, we designed the program to help organizations adapt to a net-zero future with solutions that reduce risk, support growth, provide competitive advantages, and positively impact the bottom line. The following partners provide data and analytics that offer deep insights into the environment, natural resources, and social trends that point the way toward sustainable, profitable growth. 

Atlas AI has built a geospatial artificial intelligence platform that helps every organization anticipate changing societal conditions — where people live, where wealth and poverty are concentrated, how the physical makeup of communities is evolving, and more — to determine where to invest today to prepare for the world of tomorrow. Atlas AI customers, which range from the World Bank and global NGOs to multinational corporations, use the platform to accelerate growth, future-proof supply chains, target resources to vulnerable populations, and build greater resilience to climate change.  

Climate Engine’s SpatiaFi solution, powered by Google Cloud, helps financial services organizations connect economic assets to the world of Earth observation data supporting regulatory reporting, climate risk reduction, and new innovative sustainable finance offerings. Combining billions of planetary observations with peer-reviewed scientific methods, SpatiaFi is connecting Earth science to operational systems offering new levels of accuracy, transparency, scalability, and trust in climate and sustainability data in the context of financial decision-making.

Kumi Analytics‘ KACSAT solution was approved by OxCarbon as a methodology for the calculation and verification of voluntary carbon offsets in support of nature-based solutions. KACSAT leverages multiple satellite platforms and Google Earth Engine‘s state-of-the-art processing tools to enable science-based carbon assessment aligned to the Oxford Offsetting Principles of environmental integrity, additionality, permanence, and achieving net-zero emissions. Environmental organizations, financial institutions, and corporations can now offset their carbon footprints through the reforestation and conservation of millions of hectares of forests — something that was previously limited due to the cost and time of validating high-quality forest projects.

Tensorflight revolutionizes property underwriting with AI. Its cutting-edge tool provides underwriters and insurers with access to rich and highly accurate datasets for commercial and residential properties, enabling them to create superior insurance products. As pioneers of the first property-inspection platform based on convolutional neural networks, Tensorflight’s advanced technology connects seamlessly via API and utilizes ground-level imagery, satellite, and aerial data. This unique approach enables the company to generate precise replacement costs and conduct more comprehensive risk assessments. By automating property inspections and enhancing underwriting accuracy, Tensorflight empowers insurance providers to plan for the future with pragmatic decision-making. With Tensorflight, the future of property underwriting is transformed, offering unparalleled insights, efficiency, and sustainability.

Are you ready for sustainability transformation?

Transforming into a net-zero organization means much more than building resilience to climate change, as important as that is. It also means finding the customers of the future, achieving ongoing energy savings, more sustainable resource usage, and improved transparency to regulatory institutions and consumers. Google Cloud Ready – Sustainability partners offer certified solutions that can help organizations get there.

Look for Google Cloud Ready – Sustainability validated solutions on the Google Cloud Partner Directory Listing, Google Cloud Ready Sustainability Partner Advantage page, and — if applicable — via the Google Cloud Marketplace. We hope to help customers better understand how these technologies can help them meet their ESG goals, find the right solutions for their particular challenges, and implement solutions faster. 

Learn more about the Google Cloud Ready – Sustainability validation initiative and explore all our partners in sustainability transformation.