Reach Us
Maximizing Savings: Optimizing Google Cloud Costs with BigQuery and Looker Studio
ABOUT THE CUSTOMER

Our customer is one of India’s fastest growing companies built for companies and individuals
providing pharmagenic products primarily in the healthcare sector.

THE CHALLENGE |

Our customer had increasing costs for their cloud resources. The cost accumulation was not noticeable with each charge being very small. Over-retention of backups, ingress and egress charges of microservices, and unused static IP addresses were among the factors that added up over time and led to inflated overall cloud costs. One month, a development engineer had spun up a huge Compute engine and database but forgot to turn it off. The costs for the Google Compute engine and database were naturally higher than normal.

THE SOLUTION |

The CloudifyOps team recommended our customer export their cloud billing data to BigQuery for a detailed analysis of the usage, cost estimate, pricing data, and more. Looker Studio, an in-house GCP tool, was leveraged to visualize the data on custom dashboards. This helped the team to forecast various metrics such as the breakdown of monthly costs, resource metrics, cost history by month and product categories, etc.

BENEFITS DELIVERED |

The customer was able to maximize efficiency and prevent unexpected budget overruns by leveraging Google Cloud Platform (GCP) cost management tools. More than 25% of their Google Cloud cost was saved by integrating with BigQuery analytics. The customer also obtained insights to improve their products and services, increase customer engagement and revenue, and improve their position in the healthcare product market.

TECHNOLOGY STACK |

Google Cloud billing data, BigQuery, and Looker Studio

METRICS |
  • Improved accuracy in forecasting
  • Increased visibility into the resource usage and costs
  • Saved money and other resources
Contact Us
Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from - Youtube
Vimeo
Consent to display content from - Vimeo
Google Maps
Consent to display content from - Google
Spotify
Consent to display content from - Spotify
Sound Cloud
Consent to display content from - Sound
Contact Us