Pluto7 and Google Cloud helped the largest insurance company in India improve data infrastructure and operations

partner of the year
succes stories images

Using BigQuery and Data Studio to improve operational efficiency and handle governance issues.


The client is the largest insurance company of India, who etched their name on the leader boards in a decade. Their insurance portfolio covers  vehicles, travel and health insurance. Client’s services spanning across the geography made their leadership realize the imminent need for a better data management infrastructure to handle the governance issues and speed up their data-driven operations. 

Why We Chose Pluto7

Data security is the primary concern of any organisation working in financial services. As an industry leader, the client was looking for an authoritative partnership to transform their data infrastructure. Pluto7, being a Google Cloud Partner with a strong history of delivering exceptional results to other industry leaders, the client wanted to move forward with us. Our solution made the leadership realize the operational efficiency that would be achieved. Our subject matter expertise combined with an end-to-end support throughout their data journey helped them entrust us. 


Insurance is a data extensive industry and the client being the largest insurance company in India translates into a large team spread across the geography executing many operational activities everyday, leading to myriads of data flowing in servers. Pluto7 helped the client to transform their data management system and generate the required insights.

success stories

Data was transferred from MySQL (On-Premise) to GCS (Google Cloud Storage) with orchestration handled by Google Cloud Composer. Using BigQuery in conjunction with Google Storage, Data Studio was populated as per the client’s requirements. Two pipelines were built, one for “PnL dashboard” and another for “Premium dashboard”. Both dashboards gave insights for multiple categories of insurance portfolio: cars, two-wheelers, travel, and health. 


Stakeholders no longer had to wait to 10-15 days for data consolidation and delayed KPI reports followed by it. Having data migrated to Google Cloud Platform squeezed the time required to view generate the reports to less than a minute. Moreover, these insights were available on cellular devices. 

Additional benefits were the elimination of multiple licenses with Google Data Studio and a more robust governance system where reports could be securely shared with authorized personals. 



industry image

Industry High-tech

Solutions Demand-ml| Marketing-ml


  • Data consolidation with the existing servers took almost 10 days.
  • Stakeholders had to wait longer to get real-time and historical insights.
  • Multiple licenses were required for SAP business objects.
  • The client faced a data governance issue with their existing systems.


  • Pluto7 solutions reduced the time for data consolidation from 10 days to less than a minute.
  • All the insights and real-time team performance was available to stakeholders on their cellular devices.
  • With Google Data Studio, the need for multiple licensing was eliminated.
  • Google App Script enabled a robust governance system.

Products Used

  • Google Cloud Storage
  • Google Cloud Composer
  • BigQuery
  • Google Data Studio

Customer Success Stories

  • thumb image

    Success Story: Pluto7 helped a leading manufacturer to setup data foundation and demand forecasting model

    Read more
  • thumb image

    Success Story: Improving Collaboration and enhancing overall Data Security

    Read more
  • thumb image

    Success Story: Enhancing Collaboration and Security with Google Workspace

    Read more