Elevating Insurance Analytics: A Looker and GCP Success Story

John David

Client:

Services:

Year:

Key Challenges

  • Need for standardization of data in their data lake to facilitate efficient analysis and reporting across multiple dashboards.
  • Implementing ETL measures for all the key performance indicators (KPIs) to ensure accurate and consistent reporting.​
  • Recreation of existing reports to enhance data visualization capabilities and improve overall reporting efficiency

Technologies

 

Solution

  • Sparity’s team conducted a thorough analysis of the client’s data lake to identify gaps and inconsistencies affecting the accuracy and reliability of reports and analytics.
  • Implemented data cleansing techniques to address deviations and duplications, ensuring improved data accuracy.
  • Collaborated with the client to understand their specific reporting needs, implemented ETL logics for all the key performance indicators (KPIs).
  • Loaded Google cloud storage data into BigQuery using scheduled queries and created consolidated aggregated tables for efficient analysis.
  • Developed a centralized reporting infrastructure using Looker Studio and Tableau. We migrated existing reports from spreadsheets to Google Sheets, seamlessly integrating with BigQuery for efficient data retrieval.

Benefits

  • The data quality analysis and cleansing efforts resulted in improved data accuracy, reducing errors and inconsistencies in the client’s reports and analytics.
  • Met reporting requirements and provided tables to support multiple dashboards.
  • Migration of reports to Looker Studio and Tableau enabled the client to leverage advanced data visualization capabilities.