Cloud optimization led to a 54% reduction
in cost for a leading CPG company

Developed an end-to-end Google cloud monitoring solution to optimize infrastructure costs by more than 50%

Business Challenges

A leading CPG company was incurring high billing costs post-migration of the customer, product, and pricing data from Azure to Google cloud platform (GCP). The monthly cost cap had almost doubled leading to aborting a few critical analytics initiatives. To solve the problem, the customer’s DevOps team set up Google cloud billing dashboards but could not achieve visibility in usage and wastage. Moreover, the billing reports were generated on a monthly basis making it difficult to keep a track of any anomaly in billing patterns and predict monthly expenses. They wanted us to analyze the reasons for the cost spike and find ways to control it by implementing best practices in monitoring, guard railing, and optimizing the cloud.

Sigmoid Solution

We exported billing data into BigQuery and created SQL views for visualization on Grafana dashboards. These dashboards showed visibility in the utilization of cloud resources across various GCP services at a granular level. We also created email-based alerts on a daily, weekly, and monthly basis to track cloud cost fluctuations and notify the customer in case of anomalies in billing patterns, the variance of change in cost, and the cause of change. We also limited the over-provisioning of resources by applying rightsizing recommendations to limit cost wastage across services such as Databricks and introducing auto-termination of resource utilization.

Download the Complete
Case Study here

Business outcome

Sigmoid’s cloud optimization solutions and custom dashboards helped the customer gain visibility of estimated costs for planned projects and alerts for any fluctuations or anomalies in billing patterns.

54%

Reduction in cloud cost

Enabled daily reporting

to track fluctuations in billing patterns

97% improvement

In query performance

Relevant Blogs

Data-driven Revenue Growth Management for CPGs thumbnail

Data-driven Revenue Growth Management for CPGs

Why Is Data Engineering Critical To CPG Marketing Success thumbnail

Why Is Data Engineering Critical To CPG Marketing Success

building data pipelines for CPG

Build a Winning Data Pipeline Architecture on the Cloud for CPG