Innovation in the Clouds: Sky's Blue-Sky Approach to FinOps - Build What's Next
Case Study

Innovation in the Clouds: Sky’s Blue-Sky Approach to FinOps

2917

Of your peers have already read this article.

2:30 Minutes

The most insightful time you'll spend today!

Sky is using a bold, innovative strategy to revolutionize their financial operations. Join us as we explore their journey and the cutting-edge approaches they're using to achieve success. Know more!

Google Cloud’s partnership with Sky Group, one of Europe’s largest media and entertainment companies, dates back more than four years to when Sky first became a Google Cloud customer moving diagnostic data from millions of its Sky Q TV boxes to its Google Cloud data platform.

In June 2019, a few years into their cloud adoption journey, Sky was faced with a challenge they had anticipated from the start. Their recent bill across all major cloud providers had been increasing rapidly, reaching their planned yearly budget after only six months. Sky wasn’t sure if they’d undershot their forecasts, if they were overspending, or both.

“In the beginning, we were given a brief to investigate internal cloud spend with the aim of finding out where we could make savings, but in reality we didn’t know what we would expect to find,” said Nathan King, a cloud architect in the Cloud Enablement Center and now Head of Cloud Financial Management (FinOps) at Sky since the start of 2020.

Nathan assembled a small team who started to explore Google Cloud spend using the Cloud Billing tool. At first, they drilled into their biggest Google Cloud cost categories and discovered some immediate cost optimizations with BigQuery, Compute Engine and Cloud Storage. Over the course of the next six months, through careful analysis, they managed to find over $1.5m in immediate savings, exceeding expectations.

Yet they soon realized this was just the tip of the iceberg—it was clear there were millions of pounds more savings to be made, but actually achieving them at scale would require careful planning. “We formed a FinOps function to target these savings, but with 600 to 700 projects for Google Cloud alone, spanning four Google Cloud organizations, it would have been a manual process and difficult for teams to digest our recommendations,” Nathan said.

After attending a Google-led FinOps workshop and shaping their FinOps strategy, Nathan’s team focused on iterating through the FinOps lifecycle phases of Inform, Optimize, Operate and generating savings over time. Here’s how they did it:

Inform: Make Information Visible

The first step was focused on developing a clear vision for cost allocation and recharge, which required partnering closely with the finance, procurement and tax teams (particularly for international and affiliates) to understand the supporting business logic and processes. With a lot of hard work, the team managed to break down barriers to implement and embed new processes into broader business functions like finance.

WIth the recharge model in place, the team ran a number of pilots to find the right FinOps tooling to meet their needs. They ran a number of pilots, including using Data Studio and visualizing BigQuery exports. Given their ambitions to scale across the enterprise globally, the team chose Google Cloud’s Looker to realize their vision, building intuitive dashboards to visualize spend and recommendations across all cloud providers. “We wanted one view across all clouds, where customers can dynamically see cloud spend and intelligent optimization recommendations in just one place,” Nathan said.

After less than three weeks of development, the Looker dashboards were ready to go and have been a game changer ever since. “The moment our leadership and different departments started seeing the Looker dashboards, the value we were adding as a FinOps team became immediately clear,” Nathan said.

There are different report pages for each stakeholder group, each custom developed and automated using Looker and BigQuery. The BigQuery Optimization page, for example, provides insights on Slots consumed across the organization, down to granular query data like the cost of each query, how it was written, who submitted it and number of slots utilized. The dashboards also highlight potential areas of optimization, like BigQuery datasets without retention policies set or where data isn’t partitioned.

A recent breakthrough has been building pages for business teams, showing the related cloud spend contributing to a business unit of value, such as the cost per live stream or per subscriber in Sky’s case. Although this is an inherently difficult metric to capture, the opportunity has been made possible with the FinOps team’s progress and is starting to drive business investment decisions.

Optimize: Drive Cloud Efficiency

The second stage of the FinOps lifecycle focuses on delivering optimizations. As Sky’s FinOps dashboards were operationalized and highlighted savings opportunities, they enabled users to generate more than $3 million in Google Cloud savings alone in 2020 and over $800,000 in other cloud providers.

The team began with focusing on the top four products by spend: BigQuery, Compute Engine, Cloud Dataflow and Cloud Storage. Working with their Google account team and studying Google whitepapers and blog posts like Cloud cost optimization: principles for lasting success, they developed their own best practice guidance and embedded recommendations into the dashboards.

Creating their own recommenders and leveraging Google Cloud’s recommenders, the team discovered a plethora of cost optimization opportunities. “Key examples were overly expensive queries, storage buckets set without retention policies, and VMs without autoscaling enabled,” Nathan said. Teams were then empowered to make their own savings, like the NowTV business unit that had been forecast to overspend for the year until they received their dashboard with thousands of optimization recommendations. After just three weeks, the team had implemented more than 90% of recommendations and brought their spend under budget for the year, saving more than 50%.

The FinOps team still searches for new recommendations every day and have been collaborating with Google product managers to take their insights to the next level. “We’ve loved partnering with Google product managers, who encourage us to give feedback on new features before they go to market. We’ve also shared some of our in-house recommenders to influence the features being developed by Google, including the Idle VM and Idle Persistent Disk Recommenders as part of Active Assist,” Nathan said.

Operate: Embed FinOps & Drive Self-Sufficiency

Now that teams could visualize their cloud spend and make real-time decisions based on cost optimization recommendations, the FinOps team has begun working on embedding processes, leveraging machine learning, and improving efficiency in their own ways of working.

Looker’s extensive capabilities continue to play a role in this. “Before we started using Looker, our most popular report was an electricity bill showing customers’ detailed monthly cloud spend, previous month comparisons and forecasts for months ahead,” Nathan said. “This report took days, sometimes weeks to run. With Looker, we’ve automated the entire process and brought that time down to just minutes.”

More teams are embedding the dashboards into their own processes, like finance, which now uses the interactive dashboards in meetings instead of static report snapshots, or in-house Google Cloud architects, who use the recommendations to optimize their cloud spend before deploying any technology.

As the FinOps team continues to operate like a product function, designing with CX/UX in mind and iteratively releasing new features like anomaly reporting, budget alerts, and forecasting based on machine learning, it’s becoming clear that Cloud Financial Management is a key capability and mindset that can impact wide-reaching parts of the business at scale.

Elevating Sky’s FinOps journey to the next level
Indeed, as more business teams collaborate with the FinOps function, the opportunities are growing. “The FinOps team has changed the way we view and manage cloud spend, enabling us to partner with finance and show digestible reports to the CFO. We’re now looking further to broaden our range of insights, like elevating our dashboards to understand how using Google Cloud is supporting Sky’s Net carbon zero ambitions by incorporating Google’s data center sustainability metrics,” says Vince Marco, Architecture Manager at Sky.

So, after being unsure of drivers for their increasing cloud spend in 2019, 18 months later Sky is far more confident about its investment decisions. The team knows that every dollar spent is being used optimally and driving maximum value for its investment.

If you’re an enterprise using cloud, but want to better manage cloud costs, consider setting up a FinOps capability and creating a FinOps mindset. Looker can help you get started by providing reporting and insights into cloud expenditures to identify initial savings. As you learn more and scale, empower teams to make their own savings utilizing built-in actionality for monitoring and customizing for business billing activity nuances and department-specific chargebacks. Reimagine how cloud finances can be managed and optimized as Sky is doing.

To learn more about Looker’s Cloud Cost Management Block visit Looker Marketplace.

Blog

Google and NetApp Partnership Expansion to Ease Customers’ Cloud Migration

3668

Of your peers have already read this article.

3:00 Minutes

The most insightful time you'll spend today!

At the Next 21 event last week, Google Cloud announced expansion of its strategic partnership with NetApp to ease customers' cloud migration journey and run business critical applications on Google Cloud. Learn more!

As organizations continue to evolve to meet the needs of their stakeholders, they are increasingly looking to adopt the cloud and digitally transform their business. Since our partnership with NetApp began in 2018, we’ve been focused on delivering the infrastructure, tools, and services to help customers on their cloud migration journey and benefit from their data to better serve their customers. 

“Customers are looking to adopt flexible and scalable solutions that meet the needs of their business,” said Ronen Schwartz, SVP & GM, Cloud Volumes, NetApp. “Our long-standing partnership with Google Cloud continues to deliver innovative solutions for customers as they look to migrate and run their business critical applications in the cloud while unlocking the power of their data with industry-leading cloud services.”

Innovative, industry-first solutions have become the standard for our partnership. From the general availability of NetApp Cloud Volumes Service (CVS) for Google Cloud in 2019, to our collaboration on new architectures in 2020 with the release of the software-defined CVS powered by Google Kubernetes Engine (GKE), we continue to deliver first-of-its-kind enterprise file storage services together. In 2021, the pace of innovation has only increased—together, we delivered volume replication powered by SnapMirror, which efficiently copies volume data from one Google Cloud region to another for data consistency, development, testing, or disaster recovery. 

We’ve also made our services available globally—you can now run Cloud Volumes ONTAP in all 28 Google Cloud regions, and CVS is now available in 19 regions, allowing you to access our services wherever you are around the globe. All of this is backed up by a 99.99% SLA for CVS, enabling high availability for your enterprise workloads.

Hundreds of customers including MailerLite, a leader in marketing automation, have benefitted from our joint services. MailerLite was looking to move millions of files to the cloud without disruption as they were facing availability, management, and maintenance challenges as their business scaled. By leveraging NetApp CVS on Google Cloud, MailerLite was able to migrate over 100 million files to Google Cloud in about an hour, removing their ongoing infrastructure overhead, saving developer hours, and eliminating the scalability limitations they previously experienced. 

Expanding our partnership

Last week at Google Cloud Next ‘21, we announced we are expanding our strategic partnership in two ways to make it even easier for customers to migrate and run business critical applications on Google Cloud. First, NetApp will provide storage infrastructure for the newly announced Google Distributed Cloud Hosted, where data resides in customer-owned data centers and colocation facilities. This enables a safe and secure way to modernize an on-premises deployment while still meeting data security and privacy requirements.

Additionally, for customers looking to migrate their VMware workloads to Google Cloud, we announced preview access for NetApp Cloud Volumes as datastores for Google Cloud VMware Engine. By providing customers with the choice to scale compute and storage independently, customers can now reduce costs and complexity when migrating and running storage-bound workloads. This also allows customers to address regional disaster recovery use cases, making it easier and more cost-effective to move on-premises workloads into Google Cloud. To get started, you can sign up for preview access using the Registration for Preview Access form.

Looking forward

We’re excited for what’s to come with our partnership and committed to delivering value to customers across industries. Google Cloud is a Gold sponsor at this week’s NetApp Insight, and we invite you to join our spotlight session featuring Google Cloud and NetApp leaders. Additionally, we are leading multiple breakout sessions where you will hear from our product team on how you can accelerate cloud adoption with Google Cloud and NetApp. You can also learn more and get started today by visiting our NetApp on Google Cloud website.

Blog

Why Moving SAP Workloads to Google Cloud is Beneficial for the Consumer Goods Industry

3639

Of your peers have already read this article.

3:00 Minutes

The most insightful time you'll spend today!

The consumer packaged goods (CPG) industry running on SAP systems can leverage Google Cloud to unlock its data analytics capabilities to reduce Opex, drive innovation, business outcomes and meet consumer expectations. Learn how!

Even before the COVID-19 pandemic struck, the consumer packaged goods (CPG) industry was facing disruption. Consumers have come to expect personalized and seamless experiences at every point in their relationship with a brand. Additionally, consumers are expecting CPG brands to meet rising standards for sustainability, social responsibility, and transparency. Business models are shifting as well. Direct-to-consumer and subscription models have been gaining ground on traditional business models. Add in the CPG industry’s ever-present pressure for wider profit margins and the effects of the global pandemic, and you get a perfect storm of disruption. 

Leading CPG companies are responding to these changes by capitalizing on the potential of emerging technologies and leveraging the power of the cloud to create digital enterprises. In doing so, they can unlock value through reduced operational costs, faster innovation, improved marketing ROI, and greater transparency and sustainability—among other benefits. For businesses that run on SAP, accessing these benefits requires creating a digital enterprise with SAP at its heart. 

What CPG can expect from SAP on Google Cloud

SAP drives core business processes across most enterprise functions in CPG companies, and modernizing these operations is step one in unlocking next-level data and analytics capabilities. Creating a digital enterprise with SAP at the core requires establishing a digital foundation on a cloud platform capable of supporting and optimizing SAP workloads well into the future. From there, CPG companies can leverage the combination of SAP data and additional data signals to support high-value use cases utilizing the advanced analytics capabilities of the cloud

For CPG companies, running a successful digital enterprise in this climate depends on the power of the cloud because of the unmatched agility, security, scale, and flexibility offered by cloud technologies. More and more, consumer brands are turning to Google Cloud to host their applications—including core enterprise applications such as SAP—to drive business agility and maximize the value of data through smart analytics and machine learning. Google Cloud establishes a digital foundation for SAP customers by simplifying SAP deployments and offering  a suite of applications that integrates with and enhances SAP functionality. A Forrester study on the total economic value of Google Cloud for SAP customers found an average payback of less than six months and a total ROI of over 160%. By turning to Google Cloud to run their SAP systems, companies are able to: 

  • Maximize insights 
    CPG enterprise data is often fragmented across disparate systems. Google’s analytics tools including BigQuery and Looker allow businesses to connect customer, operational and business data at scale by unifying data from SAP systems with other Google data signals such as Ads, Maps, Shopping or Google Marketing Platform. This precious data is fully democratized, allowing for complex queries to be completed rapidly so companies can uncover and analyze insights and create an end-to-end view of the consumer and the business.
  • Create an intelligent organization
    Google’s AI and machine learning capabilities allow businesses to create built-in intelligence. Instead of reacting to trends, they can accurately predict them. For marketing teams, this could be the ability to evaluate promotions and effectiveness of marketing spend. For forecasting, product quantities and restock timing can be better planned. Supply chain optimization can include external data sources to closely monitor inventory and eliminate stock outs. 
  • Future-proof your business
    Running SAP systems on Google Cloud creates an agile, secure and highly available environment that scales quickly as a business grows and as the CPG market evolves. A recent study conducted by IDC showed that SAP on Google Cloud deployments resulted in a 46% lower three-year cost of operations with 83% less frequent unplanned downtime and 56% more efficient IT teams. This frees IT resources to drive innovation and customer centricity. 
  • Deliver on sustainability 
    Around the globe, consumers are becoming more and more demanding regarding sustainability. The impact of climate change and the abundance of plastic waste is only fueling this trend. Consumers are leaning into social signalling, and CPG companies are taking note. Sustainable IT is step #1, significantly advanced by  moving applications to Google Cloud, the cleanest cloud in the industry. We’ve neutralized all of our carbon emissions since our founding in 1998 and matched 100% of our electricity consumption with renewable energy purchases since 2017. Google Cloud allows SAP enterprises to further drive sustainability compliance and business objectives with AI and ML tools that can drive down waste and provide real-time decision making power to support proactive green initiatives. 

Rémy Cointreau is in high spirits after deploying SAP in the Google Cloud

Rémy Cointreau, a family-owned international maker of fine spirits, has products that can take up to one-hundred years to produce. But this long production cycle presents some unique challenges in today’s hyper-competitive premium beverage brands market. Since 1724, the company has been consumed with putting its customers first. In 2020, the company realized it was failing to capitalize on the benefits that the cloud can provide and began searching for a business partner that could help with this transformation.  

Rémy Cointreau made the move to Google Cloud for many reasons. First, the company could connect its SAP backbone to key SaaS applications like Salesforce. This enabled the creation of a 360-view of data among its ecommerce platform, SAP, and Salesforce to deliver sophisticated customer experiences that reflect the heart of the brand. The Rémy Cointreau team quickly realized they now had the ability to be more agile in their finance, manufacturing, and supply chain functions with easy access to valuable SAP system data that drives decision-making. Sebastien Huet, the company’s CTO, explains: “Now that we’re fully deployed on Google Cloud Platform, anything is possible. We can pull data in from multiple sources via integration and analyze it in a matter of days. We don’t need a three-month project to see value.”  

In today’s on-demand, omnichannel world, it’s not enough for CPG brands to understand their consumers. For companies like Rémy Cointreau, it is mission-critical that they anticipate consumer preferences and deliver personalized experiences. The winners will be the companies that can reduce time to insights by treating all their data as strategic assets, breaking down data silos to enable real-time business intelligence. With SAP on Google Cloud, CPGs are transforming consumer relationships and business outcomes.

Are you ready to change how your CPG brand operates? Check out this video and read the Google Cloud for SAP CPG customer white paper and ebook.  Learn more about how your peers are leveraging SAP on Google Cloud to evolve their businesses.

Case Study

How a Mid-Sized Firm is Shrinking Inventory Carryovers 50% with AI

7447

Of your peers have already read this article.

5:30 Minutes

The most insightful time you'll spend today!

In addition, the 25-man manufacturing company is able to compete with much larger e-commerce retailers by being able to improve the accuracy of demand planning, make quicker decisions, and make better pricing decisions to optimize profitability--all thanks to AI.

For more than 10 years, NMK Textile Mills has manufactured bed linens for major retailers in the United States and Canada. As e-commerce exploded, the company’s co-founder saw an opportunity to grow the business. So, in addition to manufacturing bed linens wholesale for retail customers, NMK Textile Mills reworked its complete supply chain to manufacture products for California Design Den, which became an e-commerce retailer selling its own fashion-forward products directly to consumers online.

With California Design Den’s push into e-commerce, it became apparent the SMB company (with about 250 global employees) faced the same tough supply chain questions as large retail customers, including maintaining enough inventory to meet customer demand in a timely, efficient way.

California Design Den depended upon a myriad of systems to track its complex forecasting and reordering processes. Team members typically planned inventory manually using desktop spreadsheet software, which could lead to excess inventory. Accurately forecasting demand and supply was essential to the company’s financial success—but it was also a challenge.

A couple years ago, California Design Den partnered with Pluto7, a technology solutions provider that offers a software as a service (SaaS) called Planning In A Box. Leveraging Google Cloud Platform machine learning and artificial intelligence, Planning In A Box intelligently helps predict demand and balances it with supply.

But that was just the beginning. “Along the way, we realized that to compete with larger retailers, make quicker decisions, and move faster, we needed to go further,” says Deepak Mehrotra, Co-founder and Chief Adventurer at California Design Den.

With guidance from Pluto7, California Design Den began migrating its database to Google Cloud Platform. Using Google BigQueryGoogle Compute EngineGoogle Cloud SQL, and Google Cloud Storage, and experimenting with Google Cloud Vision and Google Cloud AutoML, the company is reducing inventory carryovers by more than 50%, improving the accuracy of demand planning quarter over quarter, and gaining granular insights into how individual SKUs are performing.

“We would need an army of data scientists to make faster decisions on pricing and inventory levels. With Google Cloud Platform machine learning and artificial intelligence, we don’t need that. We can make much faster pricing decisions to optimize profitability and move inventory.”

Deepak Mehrotra, Co-founder and Chief Adventurer, California Design Den

No need for army of data scientists

“Using Google Cloud Platform machine learning and AI was essential for California Design Den if it was to compete successfully with larger retailers,” Deepak says.

For example, tastes and fashions in bed linens can change quickly and consumer prices fluctuate. With more than 2,500 SKUs, it wasn’t possible for California Design Den’s team to continuously monitor product demand and experiment with competitive pricing in real time.

“We would need an army of data scientists to make faster decisions on pricing and inventory levels,” says Deepak. “With Google Cloud Platform machine learning and artificial intelligence, we don’t need that. We can make much faster pricing decisions to optimize profitability and move inventory.”

By integrating all its data onto Google Cloud Platform, California Design Den’s team gains deeper insights into product sales over time, which in turn helps the company improve demand planning by better determining which styles to manufacture and sell in the future.

“When experienced employees leave, their knowledge leaves with them. By having all data in one place, and with machine learning and AI, California Design Den can go back in its history, look at products made or sold years ago, and analyze product performance.”

Deepak Mehrotra, Co-founder and Chief Adventurer, California Design Den

Merging visuals with data

Before Google Cloud Platform, team members had to dig through spreadsheets and run scenarios to get a sense of how particular products had sold. The next step was to perform keyword searches across the company’s photo library in the cloud to find each product’s image. From there, a team member would insert the product images into a presentation, along with relevant data points, to provide a report for stakeholders on how particular styles performed.

Today, California Design Den, with the help of Pluto7, is integrating its entire product image library with its database on Google Cloud Platform. Experimenting with Google Cloud Vision and Google Cloud AutoML, California Design Den is moving towards a day when team members can run sales scenarios and get deep background data on individual product performance while viewing images of the relevant products.

Merging product visuals with data will help designers and team members better understand sales patterns over time and in context. In the past, making correlations between things like which sheet colors sold well in California, compared to how the same sheet colors performed on the East Coast, was something that California Design Den employees primarily did in their heads.

“When experienced employees leave, their knowledge goes with them,” says Manjunath Devadas, Founder and CEO at Pluto7. “By having all data in one place, and with machine learning and AI, California Design Den can go back in its history, look at products made or sold years ago, and analyze product performance.”

“We are literally growing the complexity of our business on all levels, including designing, manufacturing, selling, reordering, inventory holding—everything.”

Deepak Mehrotra, Co-founder and Chief Adventurer, California Design Den

Reimagining supply-demand balancing

Pluto7’s mission statement is to democratize supply demand balancing with machine learning and AI. California Design Den is a case in point, as the combination of Planning In A Box and Google Cloud Platform gives the company greater control over its destiny.

“Big retailers used to tell us what to manufacture and how much they would pay for it,” says Deepak. “That was our primary business, and if we didn’t accept the terms, a competitor would.” Today, in addition to continuing to make products for retailers, California Design Den can design, make, and sell a variety of designs for itself, including custom and limited-edition products, thanks to Google Cloud Platform and Pluto7 software offerings. The payoff is not only in having a more diversified business. California Design Den also receives more favorable profit margins by selling its own products.

“We are literally growing the complexity of our business on all levels, including designing, manufacturing, selling, reordering, inventory holding—everything,” Deepak says. “We can make smaller batches. We can connect directly with consumers. We can identify the missing pieces—what should we produce next, when, and how much? We otherwise couldn’t afford the level of talent it would take to do this.”

Cutting through the noise

Google and Pluto7 software helped California Design Den reduce inventory carryovers by more than 50%. Inventory tracking and distribution, along with insights and visibility into product sales, are faster, more efficient, and accurate. Google Cloud Platform flexible pricing, speed, reliability, security, and scalability enable California Design Den to stay relevant and be more competitive.

In addition to benefiting from Google Cloud Platform, California Design Den relies on G Suite—also part of Google Cloud—to enhance collaboration among its global teams. Previously, the company’s email server would sometimes crash, due to the heavy load of sharing product photos and other data. “Gmail and Google Drive handle the everyday demands on the business effortlessly and reliably,” Deepak says.

“Google machine learning and AI enable us to cut through all the noise from raw data, so we can see what’s important. We can focus on analytics to guide us to success today and in the future.”

Deepak Mehrotra, Co-founder and Chief Adventurer, California Design Den

The company is exploring additional ways to leverage Google Cloud Platform in the near future. For example, one possibility is to import customer reviews from sites where products are sold into Google BigQuery, and to use that data to perform sentiment analysis via Google Cloud Natural Language. It could provide another valuable data source to help California Design Den’s team decide where to focus future designs.

“Google machine learning and AI enable us to cut through all the noise from raw data, so we can see what’s important,” Deepak says. “We can focus on analytics to guide us to success today and in the future.”

Case Study

This Chart, from Home Depot, Dramatically Demonstrates the Power of a Cloud Data Warehouse

7606

Of your peers have already read this article.

2:30 Minutes

The most insightful time you'll spend today!

When Home Depot moved it's gigantic enterprise data warehouse to Google Cloud, it could not have imagined how much faster it could crunch data--for a variety of uses cases.

The Home Depot (THD) is the world’s largest home-improvement chain, growing to more than 2,200 stores and 700,000 products in four decades. Much of that success was driven through the analysis of data. This included developing sales forecasts, replenishing inventory through the supply chain network, and providing timely performance scorecards.

However, to compete in today’s business world, THD has taken this data-driven approach to an entirely new level of success on Google Cloud, providing capabilities not practical on legacy technologies.

The Home Depot BigQuery installation performance table
Percent reduction in time that specific workloads took using BigQuery versus on-premises data warehousing.

The pressures of contemporary growth that drove much of the work are familiar to many businesses. In addition to everything it was doing, THD needed to better integrate the complexities in its related businesses, like tool rental and home services. It needed to better empower teams, including a fast-growing data analysis staff and store associates with mobile computing devices. It wanted to better use online commerce and artificial intelligence to meet customer needs, while maintaining better security.

Even before addressing these new challenges, THD’s existing on-premises data warehouse was under stress as more data was required for analytics and data analysts were utilizing the data with increasingly complex use cases. This drove rapid growth of the data warehouse, but also created constant challenges for the team in managing priorities, performance, and cost.

In order to add capacity to the environment, it was a major planning, architecture, and testing effort. In one case, adding on-premises capacity took six months of planning and a three-day service outage. Within a year, capacity was again scarce, impacting performance and ability to execute all the reporting and analytics workloads required. The capacity refresh cycles were shrinking, and the expecations for data were growing. There had to be a better way.

Still, THD did not take its move to the cloud lightly. A large-scale enterprise data warehouse migration involves tremendous effort among people, process, and technology. After careful consideration, THD chose Google Cloud’s BigQuery for its cloud enterprise data warehouse.

BigQuery, a scalable serverless data warehouse, was better on cost, infrastructure agility, and analytics capability, driving better insights with improved performance. There are no service interruptions when capacity is added, and that capacity can be added within a week (and soon same day). It doesn’t require complex system administration, and its standard SQL support means people can easily ramp up quickly. Valuable BigQuery products like Identity and Access Management meant THD could create many separate Google Cloud projects, while ensuring that different teams weren’t interfering with each other or accessing protected data.

THD also utilizes BigQuery’s flat-rate monthly pricing model that allows teams to budget their capacity based on need and provides billing predictability. The capacity not being used by a given project is available for enterprise use. This ensures no surprises when the monthly bill arrives and provides all analytical users access to significant computing power.

While THD’s legacy data warehouse contained 450 terabytes of data, the BigQuery enterprise data warehouse has over 15 petabytes. That means better decision-making by utilizing new datasets like website clickstream data and by analyzing additional years of data.

As for performance, look at this chart:

With the cloud EDW migration complete, and the legacy on-premises data warehouse retired, analysts now execute more complex and demanding workloads that they would not have been able to complete before, such as utilizing Datalab for orchestrating analytics through Python Notebooks, utilizing BigQuery ML for machine learning directly against the BigQuery data (no movement of large datasets), and AutoML to help determine the best model for predictions.

Additionally, engineers at THD have adapted BigQuery to monitor, analyze, and act on application performance data across all its stores and warehouses in real time, something that was not practical in the on-premises system.

With over 600 projects that THD now has on Google Cloud, the BigQuery story is just one of the many ways that Google Cloud is working with THD to deliver meaningful business results, every day.

Blog

Say Hola to New Google Cloud Region in Madrid

2999

Of your peers have already read this article.

1:30 Minutes

The most insightful time you'll spend today!

A new Google Cloud region in Madrid joins network of 33 global centers to boost businesses and reach with high performance, low latency and sustainable services in Spain. Read how a cloud built for Spain allows businesses and govts meet requirements!

We’re continuing to expand our global footprint — and we’re doing it rapidly. In 2020, we announced our plans to launch a new cloud region to help accelerate the economic recovery and growth of Spain. Today, we’re excited to announce that our new Google Cloud region in Madrid is officially open.

Designed to help meet the growing technology needs of Spanish businesses, the new Madrid region (europe-southwest1) provides low-latency, highly available cloud services with high international security and data protection standards — all on the cleanest cloud in the industry. The new Madrid region joins our network of 33 regions throughout the globe, helping local Spanish businesses connect with users everywhere. You can join us at our region celebration on May 25 here.

A cloud built for Spain


Google Cloud’s global network of regions is the cornerstone of our cloud infrastructure, enabling us to deliver high-performance, low-latency, sustainable cloud-based services and products to support our customers across the globe.

Built in partnership with Telefónica, the new Madrid region offers Google Cloud’s unique global infrastructure locally, creating new opportunities for digital transformation across various industries and making it easier for organizations at any stage of their cloud journey to securely deliver faster, more reliable customer experiences.

Accelerating digital transformation also requires cloud services that meet regulatory compliance and digital governance requirements. In particular, highly regulated sectors like government, healthcare, and financial services need additional controls to store data and run workloads locally.

“We welcome the Cloud capabilities that the Google Cloud region is bringing to Spain. It is especially important for the alignment with the security levels that public sector organizations demand and as required in the National Security Scheme. They must take advantage of a cloud that is offered locally with the highest security guarantees. The collaboration with hyperscalers is key. It is also essential to continue advancing with best practices adoption, training, security configurations and supervision” Luis Jimenez, Subdirector del Centro Criptológico Nacional.

Having a new region in Madrid helps remove these barriers to cloud adoption, allowing both Spanish businesses and government entities to meet their availability, data residency, and sustainability needs in Spain while also accelerating their digital transformation.

The Madrid region is launching with three cloud zones to prevent service interruptions, and our standard set of products, including Compute Engine, Google Kubernetes Engine, Cloud Storage, Persistent Disk, CloudSQL, and Cloud Identity. . Customers will also get access to smarter analytics capabilities, AI and ML solutions, and application modernization tools that allow them to unleash the full potential of cloud computing.

At the same time, customers will benefit from controls that enable them to maintain the highest security, data residency, and compliance standards, especially those that deal with specific data storage requirements.

“In DIA Group we have always been committed to seeking innovative solutions to improve our customers’ experience while respecting the trust they place on us every day. For this reason we have decided to rely on the new Google Cloud region in Madrid for some of our most critical workloads like our store operations (orders, inventory, product stock, etc). This will guarantee our customers a low-latency service while managing their data within the national borders, as well as optimized performance.” – Carlos Valero, Chief Information Officer, Grupo DIA

“Offering our customers low-latency services while keeping workloads and data management safe, is vital for us. The availability of the new Google Cloud region in Madrid represents a great step forward that will allow us to achieve our goals and meet the expectations of our customers by offering them a premium user experience without neglecting data security and residency.” – Carmen Lopez Herranz, CTO, BBVA

Going beyond with a transformation cloud


At Google Cloud, we’re constantly working to help customers across various industries achieve what was once considered impossible, reinvent themselves, and transform the way they serve their customers using digital technology — all on the cleanest cloud in the industry.

Our transformation cloud is helping businesses become:

Smarter: Google Cloud lets you leverage data for deeper insights with a unified platform that makes it easy to get value from structured or unstructured data, regardless of where it resides.
Open: Google Cloud’s commitment to multicloud, hybrid cloud, and open source provides the freedom to choose the right solutions, allowing developers to build and innovate faster, in any environment.
Connected: Digital transformation isn’t just about technology — it’s about people and culture. In an era where work can happen anywhere, Google Cloud provides the tools needed to be more innovative, productive, and make faster decisions, together.
Trusted: Google Cloud offers strong security capabilities and a zero-trust architecture to help protect data, applications, and infrastructure against potential threats. We also provide specific offerings and work closely with local partners to help address digital sovereignty requirements emerging from both customers and policymakers.

In addition to the launch of our new Madrid cloud region, we’re making other commitments that will pave the way for new business innovations and development in Spain. The Grace Hopper subsea cable landed in September 2021 in Bilbao, connecting Spain and the UK with the United States for increased performance and greater support using the same network that powers Google infrastructure and products.

We’re also helping people develop new skills that will enable society to champion cloud technology and growth in the future. Google has already helped to train more than 1 million people with our Grow with Google program in Spain, and we have future plans to open a center of excellence for cybersecurity in Malaga and support the creation of the AI Lab Granada, in collaboration with Indra Minsait in the coming years.

For more details about the Madrid region, head to our cloud locations page, where you’ll find updates on the availability of additional services and regions.

More Relevant Stories for Your Company

Case Study

Sky News Looks to Google Cloud to Live Stream Election Results

Sky News live streamed the results from 150 of the 650 constituency counts in the U.K. while competitors, who did not have live video from as many counts, had to wait for slower independent data services to report the results. Sky News also delivered all the live streams over the

Blog

Conversations on Government Security with Dmitri Alperovitch, CrowdStrike’s Founder and Former CTO

As I was preparing for my fireside chat with Dmitri Alperovitch, Founder and Former CTO of CrowdStrike and Executive Chairman of the Silverado Policy Accelerator, for the Google Cloud Government Security Summit taking place on Tuesday, July 20th, I was reflecting about recent developments in cybersecurity, Zero Trust best practices – including aspects

Blog

Google Extends Support for Windows Server Containers on Anthos for Faster App Modernization and Consistent Dev Experience

Today, many applications in organizations’ data centers run on Windows Server. Modernizing these traditional Windows apps onto Kubernetes promises a host of benefits: a consistent platform across environments, better portability, scalability, availability, simplified management and speed of deployment, just to name a few. But how? Rewriting traditional .NET applications to

Case Study

Dassana: Choosing Google Workspace and Google Cloud to accelerate growth and reach goals

When Dassana co-founders Gaurav Kumar and Parth Shah, formerly founder and founding engineer at RedLock (now Prisma Cloud by Palo Alto Networks), set out on a new startup journey in 2020, they knew exactly where to start: sign up for Google Workspace. “Every startup I’ve been at, we used Google

SHOW MORE STORIES