TechValidate Research on Google Cloud Data Analytics


Google BigQuery Case Study

SulAmérica

Introduction

SulAmérica migrated up to 50TB from their traditional data warehouse to BigQuery. By migrating off their Cloudera/Hadoop system to BigQuery, SulAmérica was able to improved scale, security, reliability, and integrations with external data sources and tools.

“Powerful and easy to start and grow without infrastructure limits. Pay-as-you-go model with serverless solutions are worthwhile.”

Challenges

SulAmérica Faced the following pain points prior to their BigQuery migration:

  • Performance outages
  • Long compute and storage capacity planning
  • Growing database operations management
  • An upcoming hardware refresh
  • An upcoming software license renewal
  • Pressure from management / board
  • Pressure from line of business for faster insights
  • Migrated off the following legacy systems to BigQuery:
    • Cloudera/Hadoop
  • Evaluated the following data warehouse provider before adopting BigQuery:
    • AWS Redshift
  • Use Case

    The key features and functionalities of Google BigQuery that the surveyed company uses:

    • Used Informatica for implementing their BigQuery migration.
    • Migrated up to 50TB from their traditional data warehouse to BigQuery in total.
    • Their BigQuery migration took 12+ months.

    Results

    SulAmérica achieved the following results with Google BigQuery:

    • Business value achieved after migrating to BigQuery:
      • Improved scale
      • Improved security & reliability
      • Integrated with external data sources & tools
    • Improved in the following areas after using BigQuery:
      • Improved advanced analytics & ML: up to 25%
      • Increased agility & faster insights: 75-100%
      • Improved security: 75-100%
      • Improved query data living in external data sources (sheets, Marketo) for richer insights: 75-100%
    • Received insights 20x faster after investing in BigQuery.
    • Took on 5-10 net new data & analytics projects as a result of moving to BigQuery in a year.




    About This Data

    This data was sourced directly from verified users of Google Cloud Data Analytics by TechValidate.

    TechValidate verifies the identity and organizational affiliation of all participants that contribute to published research data. When research participants so desire, we also guarantee their anonymity so that they may share information honestly and freely.


    More Research on Google Cloud Data Analytics