How Can Brands Evolve in Post-pandemic Era amid Changing Consumer Behavior Patterns - Build What's Next
Blog

How Can Brands Evolve in Post-pandemic Era amid Changing Consumer Behavior Patterns

3654

Of your peers have already read this article.

1:30 Minutes

The most insightful time you'll spend today!

A digital wave swept the retail and consumer goods industry by the virtue of the pandemic in 2020. Brands that managed to embrace this reality to make their online operations sustainable and agile have takeaways on disruption amid changes.

2020 saw an unprecedented change in consumer behaviour around the world, with shoppers finding new ways of discovering, evaluating and buying products. This has created fresh expectations for both brands and retailers to drive consumer closeness, embrace the digital moment and transform their operations to be more agile and sustainable. These themes have been top of mind in my conversations with our CPG customers, and set the tone at Google Cloud Summit for Retail and Consumer Goods, which concluded this week. I couldn’t be more proud of our team and thankful for our customers that supported us by participating in our sessions and attending the event.

I joined Google Cloud in January 2021 after a long career in the CPG industry, and as I shared in my CPG keynote at the summit, I am thrilled to be helping bring the power of Google to drive industry innovation in CPG. At Google we call this ‘new normal’ the transformation cloud era, where we’re working with customers who want to not just save money on storage or compute, but to use cloud and digital technologies to drive agility across their business. I also call it the era of ‘consumer switching’, because Covid-19 has accelerated the likelihood of consumers to switch brands or the way they shop. Some of these changes are still happening; over 40% shoppers in a recent Google survey reported that in March 2021 they changed brands or shopped online for something they were previously buying in store.

At Google, we have an amazing team of strategists who have been researching, observing, and analyzing the many facets of consumer behavior over the last few years. In the opening keynote at the Summit Capturing the Hearts and Minds of Today’s Consumers, Google’s Human Truths Team kicked off the Retail & Consumer Goods summit by sharing some of their consumer insights, including what behavior patterns they think will “stick” as we move into a post-pandemic world.  I think these insights are especially relevant for brands, as they speak to some of our latest findings on the CPG shopper’s mindset.

gcp stats.jpg

Accenture estimates that there could be a 3 trillion dollar shift in value between companies as a result of consumers shifting brands and behaviours. While it is not known who the winners of the shift will be, one thing is certain – those who will be able to leverage data and analytics fastest will benefit the most from these times of rapid change. I shared some of the implications for the CPG industry in my keynote How to grow brands in times of rapid change along with the three key areas in which Google cloud is helping CPG companies drive brand success: 

  1. Unlocking consumer growth with data powered insights 
  2. Transforming go-to-market in the omnichannel ecosystem
  3. Driving connected, efficient, and sustainable operations
google cloud gcp transformation.jpg

Let’s take a quick look at each of them:

Unlocking consumer growth with data-powered insights

The digital marketing ecosystem is transforming for a privacy centric world, and brands are seeing a direct impact in marketing effectiveness. As the CPG industry becomes more consumer-centric and shifts more toward direct-to-consumer (D2C) business models, acquiring and activating consented first-party consumer data presents a clear opportunity to capitalize on new consumer demands. 

As a result, CPGs are turning to consumer data platforms (CDPs) to help them unify, manage, enrich, and secure all of their disparate data from different marketing tools, website analytics, email campaigns, loyalty programs, and more. Google Cloud and our ecosystem of partners can help CPGs build a privacy-centric CDP which brings together all their customer and marketing data into a modern data warehouse, with built-in predictive data visualization tools and models. With a CDP built on Google Cloud, you can integrate data from Google Marketing Platform to drive predictive marketing and media effectiveness. And with pre-built connectors you can also easily integrate non-Google media and data from other enterprise platforms like SAP and Oracle to leverage consumer data for more integrated decision making. Democratize access to data across the organization with our Business Intelligence tool Looker to enable faster decisions in real-time from marketing to supply chain to product innovation.

At the Retail & CPG Summit we shared how retailers and brands can drive consumer closeness in a privacy-centric world  featuring Procter & Gamble’s experience building and activating consumer data in a privacy-safe way to serve consumers better and maximize marketing effectiveness and drive growth across their business. And in a demo, Constellation Brands shared how they’re leveraging real-time data from several commercial sources using Looker to unpack insights and develop action plans.

Transforming go-to-market in the omnichannel ecosystem

Amidst COVID-19 restrictions and rolling lockdowns, ecommerce activity has surged past a point of no return. Direct to consumer (D2C)  or digitally native brands were able to minimize consumers switching during the pandemic  by offering a great online experience. While in-person shopping remains important, consumers are expecting more digital and omnichannel experiences and many will continue to explore new brands and purchase online. CPGs that want to maintain their market leadership can no longer afford to ignore the key role omnichannel capabilities will play in capturing the attention of both retailers and consumers.  Even if D2C sales are not a big portion of your business, you will benefit from first-party data that can help you drive insights and product innovation. 

CPG brands want to transform their older, clunky ordering processes into modern digital shopping experiences. Re-platforming legacy solutions on Google Cloud not only accelerates application innovation, but also makes it easier to quickly launch new features and products. At Google Cloud we have transformed ecommerce for large D2C brands and traditional retailers, so we know what a best in class D2C experience looks like. And we can bring it to your brands. We already help some of the biggest brands in retail modernize ecommerce and enhance product discovery with solutions like Visual Search and Recommendations AI. All of these can help you build a best in class omni channel presence for your brands.

We had several sessions on improving your omni channel experience, including 

Why search abandonment is the metric that matters featuring Macy’s and Conversational Commerce with Google with Albertsons, where we shared how Google’s conversational experiences can help consumers message businesses from wherever they are, and whenever they need them.

Driving connected, efficient, and sustainable operations

The superpowers of  AI/ML are not just for marketing.  Did you know that research from MIT and Google Cloud has found companies that use AI/ML can drive 2x more data-driven decisions, 5x faster decision making, and 3x faster execution? By connecting your operations in real time with demand signals like search, trends, weather, mobility and supercharging this data with AI and ML, you can make smarter and quicker business decisions. For example, you can use search trends to drive demand forecasting and ramp up manufacturing for popular products.

Google Cloud can help you modernize legacy business applications by migrating them to the cloud and using AI/ML and smart analytics to drive business outcomes. Take SAP for example – a Forrester study found that modernizing SAP with Google not only resulted in 56% more efficient IT teams – it also generated 160% 3-year ROI. 

SAP data on Google Cloud breaks down silos across SAP, marketing, manufacturing systems, and external data sources for next-level intelligent operations. For example, with SAP and Google Cloud, you can combine product, media, CRM, digital commerce and site data from SAP and non-SAP sources to uncover stronger consumer insights and fuel product discovery along the path to purchase. You can merge SAP product and sales data with consumer,  market data and Google geo trends to drive targeted promotion outcomes, maximizing the ROI of promotional dollars across retail channels. You can also integrate supply chain and manufacturing data from SAP systems with consumer, marketing and Google geo market data to improve demand forecasting and optimize supply chain logistics. The possibilities are endless. This is why we describe SAP modernization as The Gift That Keeps On Giving. Check out the session on SAP from the Summit and hear from Rodan + Fields on their experience of modernizing SAP on Google Cloud. 

Another solution that excites me is Vertex AI, which transforms the demand forecasting process. Traditional demand forecasting accuracy is a challenge for most CPGs. Current forecasting methods do not take into account granular factors that impact demand, like local weather, demographics, or unforeseen events. With our recently launched Vertex Forecast, Google is making it much easier to start using cutting-edge machine learning models for demand forecasting. In our session Demand Forecasting: Time for Intelligence, Not Intuition featuring American Eagle Outfitters, we share how you can adopt a data science approach to demand forecasting that’s customized to your unique needs.

CPG organizations come to Google for help solving their toughest problems, whether it be driving new consumer growth, unlocking new routes to market, or building connected, sustainable operations. And we bring the best of Google: innovation, culture, infrastructure, AI/ML, and a deep understanding of consumer behaviour to help them build best-in-class brands. 

I’d like to end with a topic that’s very close to my heart. This is around Solving for Sustainability in Retail and Consumer Goods. Our research shows that 62% of shoppers cared about at least one sustainability aspect when purchasing online in 2020. In addition, the events of the past year have triggered consumers to re-evaluate their relationships with brands and prioritize those that are more sustainable in the context of the pandemic. Watch this session to learn more about how retailers and consumer goods companies can leverage technology, data, and machine learning to help make sustainability a core part of the recovery.

All our session content is available on demand. Ready to learn more about how we’re helping CPG brands and manufacturers drive results? Learn more about Google Cloud’s consumer packaged good solutions and reach out to your Google Cloud sales executive to set up a deeper conversation on how we can help you grow your brands today and in the future.

Blog

Google Announced Leader in 2021 Gartner Magic Quadrant for Cloud Infrastructure and Platform Services

3549

Of your peers have already read this article.

3:00 Minutes

The most insightful time you'll spend today!

For the fourth time in a row, Google Cloud's customer centric innovations, performance, sustainability, cost and support, wins hands down at the 2021 Gartner, Magic Quadrant for Cloud Infrastructure and Platform Services!

For the fourth consecutive year, Gartner has positioned Google as a Leader in the 2021 Gartner Magic Quadrant for Cloud Infrastructure and Platform Services (formerly titled as Magic Quadrant for Cloud Infrastructure as a Service upto 2014 Infrastructure as a Service, or (IaaS).

With our customers and communities adjusting to new ways of working and doing business, Google Cloud has remained focused on building services and platforms that help you be more resilient and derive even more value from your cloud infrastructure. We believe Gartner’s analysis and recognition gives our customers the confidence needed to choose Google as the platform for customer-centric innovation. Here are just a few recent examples.

Ready for the most demanding, mission-critical workloads

Our enterprise-ready cloud provides you the uptime, performance, and scale to run even your most demanding workloads. Examples of recent launches: 

Saves you money

Save money with a transparent and innovative approach to pricing and intelligent recommendations. In the past year, we’ve launched several innovations to help you save costs:

  • Tau VMs, which offer the best price-performance among leading clouds for scale-out workloads 
  • Machine-learning-driven predictive auto-scaling for VMs and GKE Autopilot, enabling infrastructure to scale up and down as needed with minimal waste 
  • Standard network tier which routes traffic over the internet for cost optimization 

Open

We have a long history of leadership in open technologies—from projects like Kubernetes, the industry standard in container orchestration and interoperability, to TensorFlow, a platform to help anyone develop and train machine learning models. Here are a few recent improvements we’ve made to ensure your cloud is an open cloud: 

Secure

Google Cloud’s trusted infrastructure uses layers of security to protect your data with advanced technologies and operations, keeping your organization secure and compliant. For example, we offer:

Sustainable

Google Cloud helps customers transform their business sustainably. We operate the cleanest cloud in the industry to make sure your digital footprint doesn’t leave a carbon one. Here are a few proof points:

Supporting our customers

Most importantly, our field organizations and partner organizations work with a singular focus to ensure customer success. This has made Google Cloud the fastest growing hyperscaler, with a rapidly expanding customer base across all geos and industries.

Since launching Customer Care last year, we consolidated and simplified the post-sales engagement with customers, increased the support channels, created an API to allow programmatic case creation, and combined product specific support into a single package for all of Google Cloud. Enterprises with Customer Care continue to report high levels of satisfaction with their focused technical account managers (TAMs), helping them get the most business value out of Google Cloud.

We are committed to sustaining and accelerating the pace of customer-centric innovation. You can download a complimentary copy of the 2021 Magic Quadrant for Cloud Infrastructure and Platform Services on our website. 

Join us to learn much more about Google Cloud at the upcoming Google Cloud Next ‘21 digital conference.  


Gartner, Magic Quadrant for Cloud Infrastructure and Platform Services,  Raj Bala | Bob Gill | Dennis Smith | Kevin Ji | David Wright, 27 July 2021
Gartner, Solution Scorecard for Google Kubernetes Engine,  Tony Iams | Traverse Clayton | Megan Bain, 12 April 2021
Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

Case Study

Cloud Computing at Sea: Google Public Sector Boosts U.S. Navy Collaboration

3056

Of your peers have already read this article.

2:00 Minutes

The most insightful time you'll spend today!

Google Public Sector is helping the U.S. Navy better collaborate through the use of cloud technology. In this blog, we'll explore how Google is assisting the Navy in improving communication and cooperation among its personnel.

With a global, always-on workforce, the U.S. Navy requires secure collaboration between teams across countries and time zones. This is especially relevant for the 50,000 U.S. Navy sailors deployed aboard approximately 100 ships at any given time, who need to connect with personnel at regional shipyards for everything from routine maintenance, to more serious ship repairs.

Google Public Sector directly assists Naval Sea Systems Command (NAVSEA), the largest of the U.S. Navy’s five “systems commands,” by providing support to the U.S. Naval Ship Repair Facility and Japan Regional Maintenance Center (SRF-JRMC) in Yokosuka and Sasebo, Japan. NAVSEA is using Google Workspace, which harnesses Google’s threat protection and zero trust capabilities, to enable effective, secure, and compliant collaboration between the SRF-JRMC and Navy stakeholders around the world.

The workforce in the SRF-JRMC facility had two unique challenges. The first was around ineffective collaboration and communication channels. Before deploying Google Workspace, a Navy officer in Japan would need to be on-base to communicate over a secure connection, and calls were typically late at night given the time difference. This challenge was even further magnified when the COVID-19 pandemic hit, further restricting staff mobility.

The second challenge was a language barrier. With more than 3,000 Japanese Master Labor Contract (MLC) employees providing critical support to SRF-JRMC’s shipyard, Navy leadership needed an easier way to communicate with their Japanese-speaking counterparts. Breaking down this barrier would ensure work could be completed faster and more effectively, facilitating a more collaborative environment.

Enabling secure collaboration

The Navy partnered with Google Public Sector to enable Google Workspace for SRF-JRMC. Today, Google Workspace assists the Navy’s shipyards by enabling Google Voice for secure voice over Internet Protocol (VoIP) calling options, so personnel can join calls and sessions on-site or at-home to communicate securely and reliably across continents. In addition, early access to solutions like English to Japanese translated captions in Google Meet help break down the language barrier by providing instant translation during meetings. The platform also saves the U.S. Navy thousands of dollars a month in phone bills by providing country-specific dial-in numbers for interviews.

Moreover, Google Workspace tools like Google Drive and Docs also help to simplify human resource workflows by streamlining the hiring for onboarding local Japanese employees for the shipyard. Having a shared Google Drive eliminates the need to send multiple files back and forth among the NAVSEA team, allowing them to minimize on-premises storage space. In addition, Google Docs enables Navy employees to communicate and collaborate with each other and with potential candidates securely, and across any device.

“As the largest overseas ship repair facility of the U.S. Navy, operational readiness and continuity of operations is our top priority,” said Peter Guo, chief information officer at SRF-JRMC. “Cloud collaboration capabilities provide us seamless and secure connectivity across continents and break down language barriers with our colleagues across the globe. We’ve improved our ability to operate anytime, and anywhere and have increased our ability to securely communicate and coordinate especially during network outages and natural disasters.”

Providing pandemic assistance

Google for Government’s Workspace solutions also became useful to the SRF-JRMC during the pandemic, providing valuable communication and collaboration tools during a time of uncertainty. In addition to deploying Google Workspace, SRF-JRMC’s IT department created a COVID-19 Pandemic Dashboard, a Google-based site that consolidated Japanese and international open-source data on COVID-19 outbreaks and provided updated guidance. The Dashboard was built in less than two hours, using Looker Studio, and it leveraged an automated data collection process to track local hospitalization numbers. Before building the site, it took the NAVSEA team hours to compile this information; now, the team can access this information in real-time.

“This Dashboard drastically reduced redundant weekly meetings centered on COVID-19 updates, and saved more than 10 hours per week manually gathering data and presenting it via slide decks,” said Guo. “Additionally, this capability enabled our leadership to make real-time, data-driven decisions and put necessary risk mitigations in place. It empowered supervisors across the shipyard to reference this website at any time and put additional health measures in place to minimize the transmission of COVID-19. Every minute counts at our two shipyards in Japan, so this made a tremendous impact on our operational efficiency and ensured the safety of our sailors.”

Delivering the best possible tools means making life better and work more fulfilling for millions of people, inside and outside of government. To help government agencies maintain access to communications and collaboration tools that they need during and after an incident to keep work going, we are also offering workshops for federal, state and local governments. Learn more about Google for Government solutions for the Department of Defense, and Google Workspace for Government.

Blog

7 Fantastic Ways Google Cloud VMWare Engine Stands Out from the Rest for Running VMWare Workloads in the Cloud!

3585

Of your peers have already read this article.

2:00 Minutes

The most insightful time you'll spend today!

Google Cloud migration for VMware workloads impacts savings 38 percent in TCO. Still considering the pros of Google Cloud VMWare Engine? Here are seven customer-centric innovations in its infrastructure that makes its ideal for Vsphere workloads!

Google Cloud VMware Engine delivers an enterprise-grade, cloud-native VMware experience that is built on Google Cloud’s highly performant and scalable infrastructure. By enabling a consistent VMware experience, the service allows customers to adopt Google Cloud rapidly, easily, and with minimal modifications to their vSphere workloads, bringing the best of VMware and Google Cloud together on one platform for a variety of use-cases. These include rapid data center exit, application lift and shift, disaster recovery, virtual desktop infrastructure, or modernization at your own pace.

Here are seven ways VMware Engine outshines alternatives for running your VMware workloads in the cloud, simplify your operations, and help you innovate faster:

  1. Dedicated 100Gbps east-west networking
    Google Cloud VMware Engine nodes come with redundant switching and dedicated 100Gbps east-west networking with no oversubscription of bandwidth, unlike other options where there is generally oversubscription. This is especially important when it comes to running latency-sensitive workloads.
  2. Four 9’s of availability in a single zone
    The service offers 99.99% uptime SLA for a cluster in a single Zone with five to 16 nodes and FTT=2 or more without the need for stretched clusters, which is higher than the alternatives. Further, dedicated connectivity for core service functions such as vSAN and vMotion enables better solution stability and availability. This enables the service to support the needs of enterprise workloads that require high availability.

Note: “Cluster” means a deployment of three or more dedicated bare metal nodes running VMware ESXi and associated networking managed via management interfaces.

  1. Global networking without complex routing
    Google Cloud VMware Engine networking is built based on Google Cloud’s powerful networking architecture. With simplified regional and global routing modes—which allow a VPC’s subnets to be deployed in any region where our service is available—you can architect global networks without the need or overhead of creating and connecting regional network designs. You get instant, direct Layer 3 access between them. In alternative cloud environments, you may have to configure special networking between regions, often requiring VPN-based tunnels over the WAN to enable global uniform network communication. This adds to the deployment and operational complexity, in addition to cost.
  2. Integrated multi-VPC networking
    Users often have application deployments in different VPC networks, such as separate dev/test and production environments or multiple administrative domains across business units. The service supports “many-to-many” access from VPC networks to Google Cloud VMware Engine networks with multi-VPC networking, allowing you to retain existing deployed architectures and extend them flexibly to your VMware environments. In addition, by providing multi-VPC networking, you can pool their VMware needs—say for QA and dev—to a smaller set of clusters, effectively reducing their costs.

For more information about the end-to-end networking capabilities and services available in Google Cloud VMware Engine, please refer to the Private Cloud Networking for Google Cloud VMware Engine whitepaper. Here, you’ll find details about network flows, configuration options, and the differentiated benefits of running your VMware workloads in Google Cloud.

  1. Unified, cloud-integrated model
    Google Cloud VMware Engine is a fully managed Google first-party service, operated and supported by Google and its world-class team. With fully integrated identities, billing, and access control, you have a simpler end-to-end experience that is different from other services. You access Google Cloud VMware Engine service via the Google Cloud console, like any other Google Cloud service. You can also access other native Google Cloud services privately from your VMware private cloud running in Google Cloud VMware Engine over local connections.
  2. Flexibility in third-party ecosystem compatibility
    With Google Cloud VMware Engine, you can set up existing VMware on-premises third-party tools or products that require additional privileges by using a solution user account. This uniquely enables operational consistency, ensuring that the tools you have invested in and used over the years work on Google Cloud VMware Engine. Furthermore, in key areas such as vSAN data encryption, you have the choice of not only using Google Cloud Key Management Service (KMS)—which is turned on by default on vSAN datastores—but also external KMS providers such as HyTrust, Thales, and Fortanix.
  3. Dense nodes with high storage:core and memory:core ratios and fast provisioning
    Google Cloud VMware Engine nodes are dense. Each node is powered by Intel® Xeon® Scalable Processors and comes with 36 cores, 72 hyperthreaded cores, 768 GB memory, 19.2 TB NVMe data and 3.2 TB NVMe cache storage. This, along with oversubscription, leads to high consolidation ratios and compelling storage:core per dollar and memory:core per dollar. In addition, you can rapidly spin up these nodes in a VMware private cloud often in under an hour, enabling on-demand, VMware-consistent capacity in Google Cloud for your needs.

These are just a few examples of customer-centric innovation that set Google Cloud VMware Engine infrastructure apart. In addition, migrating to Google cloud can save you up to 38% in TCO. Get started by learning about Google Cloud VMware Engine and your options for migration, or talk to our sales team to join the customers who have embarked upon this journey.

The authors would like to thank the Google Cloud VMware Engine product team for their contributions on this blog.

How-to

Developers and Practitioners’ Guide for Moving On-prem Data Warehouse to BigQuery

5417

Of your peers have already read this article.

3:00 Minutes

The most insightful time you'll spend today!

Google Cloud's BigQuery is a serverless, scalable and cost-effective solution for handling EDW use cases. Read to ease your migration journey of on-prem EDW to BigQuery along with examples and considerations for a successful data migration strategy!

Data teams across companies have continuous challenges of consolidating data, processing it and making it useful. They deal with challenges such as a mixture of multiple ETL jobs, long ETL windows capacity-bound on-premise data warehouses and ever-increasing demands from users. They also need to make sure that the downstream requirements of ML, reporting and analytics are met with the data processing. And, they need to plan for the future – how will more data be handled and how new downstream teams will be supported?

Checkout how Independence Health Group is addressing their enterprise data warehouse (EDW) migration in the video above.

Why BigQuery?

On-premises data warehouses become difficult to scale so most companies’ biggest goal is to create a forward looking system to store data that is secure, scalable and cost effective. GCP’s BigQuery is serverless, highly scalable, and cost-effective and is a great technical fit for the EDW use-case. It’s a multicloud data warehouse designed for business agility. But, migrating a large, highly-integrated data warehouse from on-premise to BigQuery is not a flip-a-switch kinda migration. You need to make sure your downstream systems dont break due to inconsistent results in migrating datasets, both during and after the migration. So..you have to plan your migration. 

Data warehouse migration strategy

 The following steps are typical for a successful migration: 

  • Assessment and planning: Find the scope in advance to plan the migration of the legacy data warehouse 
    • Identify data groupings, application access patterns and capacities
    • Use tools and utilities to identify unknown complexities and dependencies 
    • Identify required application conversions and testing
    • Determine initial processing and storage capacity for budget forecasting and capacity planning 
    • Consider growth and changes anticipated during the migration period 
    • Develop a future state strategy and vision to guide design
  • Migration: Establish GCP foundation and begin migration
    • As the cloud foundation is being set up, consider running focused POCs to validate data migration processes and timelines
    • Look for automated utilities to help with any required code migration
    • Plan to maintain data synchronization between legacy and target EDW during the duration of the migration. This becomes a critical business process to keep the project on schedule.
    • Plan to integrate some enterprise tooling to help existing teams span both environments
    • Consider current data access patterns among EDW user communities and how they will map to similar controls available in Big Query. 
    • Key scope includes code integration and data model conversions
    • Expect to refine capacity forecasts and refine allocation design. In Big Query there are many options to balance cost and performance to maximize business value. For example, you can use either on-demand or flat-rate slot pricing or a combination of both. 
  • Validation and testing
    •  Look for tools to allow automated, intelligent data validation 
    • Scope must include both schema and data validation
    • Ideally solutions will allow continuous validation from source to target system during migration
    • Testing complexity and duration will be driven by number and complexity of applications consuming data from the EDW and rate of change of those applications 

A key to successful migration is finding Google Cloud partners with experience migrating EDW workloads. For example, our Google Cloud partner Datametica offers services and specialized Migration Accelerators for each of these migration stages to make it more efficient to plan and execute migrations.

Data Warehouse Migration Strategy
Click to enlarge

Data warehouse migration: Things to consider

  • Financial benefits of open source: Target moving to ‘Open Source’ where none of the services have license fees. For example BigQuery uses Standard SQL; Cloud Composer is managed Apache Airflow, Dataflow is based on Apache Beam. Taking these as managed services provides the financial benefits of open source, but avoids the burden of maintaining open source platforms internally. 
  • Serverless: Move to “serverless” big data services. The majority of the services used in a recommended GCP data architecture scale on demand allowing more cost effective alignment with needs. Using fully managed services lets you focus engineering time on business roadmap priorities, not building and maintaining infrastructure. 
  • Efficiencies of a Unified platform: Any data warehouse migration involves integration with services that surround the EDW for data ingest and pre-processing and advanced analytics on the data stored in the EDW to maximize business value. A cloud provider like GCP offers a full breadth of integrated and managed ‘big data’ services with built-in machine learning. This can yield significantly reduced long-term TCO by increasing both operational and cost efficiency when compared to EDW-specific point solutions. 
  • Establishing a solid cloud foundation: From the beginning, take the time to design a secure foundation that will serve the business and technical needs for workloads to follow. Key features include: Scalable Resource Hierarchy, Multi-layer security, multi-tiered network and data center strategy and automation using Infrastructure-as-Code. Also allow time to integrate cloud-based services into existing enterprise systems such as CI/CD pipelines, monitoring, alerting, logging, process scheduling, and service request management. 
  • Unlimited expansion capacity: Moving to cloud sounds like a major step, but really look at this as adding more data centers accessible to your teams. Of course, these data centers offer many new services that are very difficult to develop in-house and provide nearly unlimited expansion capacity with minimal up-front financial commitment. . 
  • Patience and interim platforms: Migrating an EDW is typically a long running project. Be ready to design and operate interim platforms for data synchronization, validation and application testing. Consider the impact on up-stream and down-stream systems. It might make sense to migrate and modernize these systems concurrent with the EDW migration since they are probably data sources and sinks and may be facing similar growth challenges. Also be ready to accommodate new business requirements that develop during the migration. Take advantage of the long duration to have existing your operational teams learn new services from the partner leading the deployment so your teams are ready to take over post-migration. 
  • Experienced partner: An EDW migration can be a major undertaking with challenges and risks during migration, but offers tremendous opportunities to reduce costs, simplify operations and offer dramatically improved capacities to internal and external EDW users. Selecting the right partner reduces the technical and financial risks, and allows you to plan for and possibly start leveraging these long-term benefits early in the migration process.
Data Warehouse Migration Architecture
Click to enlarge

Example Data Warehouse Migration Architecture

  • Setup foundational elements. In GCP these include, IAM for authorization and access, cloud resource hierarchybilling, networking, code pipelines, Infrastructure as Code using Cloud Build with Terraform ( GCP Foundation Toolkit), Cloud DNS and a dedicated/partner Interconnect to connect to the current data centers.
  • Activate monitoring and security scanning services before real user data is loaded using Cloud Operations for monitoring and logging and Security Command Center for security monitoring. 
  • Extract files from on-premise legacy EDW and move to Cloud Storage and establish on-going synchronization using Big Query Transfer services
  • From Cloud Storage, process the data in Dataflow and Load/Export data to BigQuery. 
  • Validate the export using Datametica’s validation utilities running in a GKE cluster and Cloud SQL for auditing and historical data synchronization as needed. Application teams test against the validated data sets throughout the migration process. 
  • Orchestrate the entire pipeline using Cloud Composer, integrated with on-prem scheduling services as needed to leverage established processes and keep legacy and new systems in sync. 
  • Maintain close coordination with teams/services ingesting new data into the EDW and down-streams analytics teams relying on the EDW data for on-going advanced analytics. 
  • Establish fine-grained access controls to data sets and start making the data in Big Query available to existing reporting, visualization and application consumption tools using BigQuery data connectors for ‘down-stream’ user access and testing. 
  • Incrementally increase Big Query flat-rate processing capacity to provide the most cost-effective utilization of resources during migration. 

To learn more about migrating from on-premises Enterprise Data Warehouses (EDW) to Bigquery and GCP here.

Whitepaper

Cloud as an Innovation Platform in Capital Markets

DOWNLOAD WHITEPAPER

5642

Of your peers have already downloaded this article

5:30 Minutes

The most insightful time you'll spend today!

Public cloud, big data, and AI technologies offer competitive advantages and cost savings for capital markets firms ready to make the transition. This paper discusses the three phases capital markets firms go through in transitioning to public cloud, and the workloads, benefits, and cultural changes that characterize the three phases:

Infrastructure Optimizers: The first step on the public cloud journey, where firms focus on migrating specific workloads to save costs.

Cautious Strategists: Firms build on the success of their first public cloud migrations, and begin to change the way they develop technology to increase cost savings and start taking advantage of capabilities only available on public cloud.

Transformative Innovators: Firms shift to a fully public cloud-enabled mentality, and fully leverage the flexibility and agility of the public cloud to build industry-changing solutions and attract top IT talent.

Additionally, we reveal the five things that capital markets innovators who have advanced to the transformation phase do well in their adoption of cloud, big data, and AI technologies across the front, middle, and back office functions.

More Relevant Stories for Your Company

How-to

Relax: Support on Google Cloud is Easy and Efficient

To navigate the complexity of today’s cloud environment and to get the most out of your investment, you need robust support that is fast, efficient, and available at the time of need. Google Cloud Platform support checks all the boxes and helps you architect for the inevitable and quickly resolve

Research Reports

Modernize your Windows Server Workloads using Google Cloud Platform

Application Modernization is an important enabler of Digital Transformations (DX), which fuel competitive advantage through increased productivity and business agility. Public cloud infrastructure proves to be a solid foundation for application modernization by providing Self-Service Provisioning capabilities, cloud-based & cloud-native technologies, and easier access to technology innovations such as AI/ML.

Blog

You Can Now ‘Listen’ to Over 50 Tech Blogs on Google Cloud Reader

🎧 Prefer to listen? Check out this episode on the Google Cloud Reader podcast If you’re anything like me, you love reading, but also appreciate that sometimes your eyes need to be doing other things; whether it’s finding your exit off the highway, or keeping your puppy from destroying the couch. And

Whitepaper

CFO Watch: A Handy Guide to Financial Governance in the Cloud

With a growing number of enterprises across industries making the move from on-premise infrastructure to on-demand cloud services, there has been a major shift from CapEx to OpEx spending. As a result, budgeting can no longer be a one-time operational process completed annually. Instead, spending must be monitored and controlled

SHOW MORE STORIES