CLIENT: Large Insurance Provider

An insurance company approached Sapling to develop Power BI dashboards to help keep track of the policies they sell and customer retention

Presentation in office or ornament meeting room with analyst team
Key Insights

We made dashboards to keep track of the policies being sold based on types and yearly improvements on certain key metrics

We calculated which customer has an active policy at any given point based on transactional data. We incorporated this into a cohort table to visualize how many of the customers maintained an active policy over the following months

As a result the client is not only able to monitor the growth of their business, but also to identify and rectify the underperforming aspects of the business where they can reach the greatest improvements

NUMBER OF CUSTOMER WITH ACTIVE POLICY
Latest Case Studies
  • Sell-Side Quality of Earnings
    • August 26, 2026

    A B2B distributor selling to major retailers in the U.S. engaged Sapling to perform a sell-side Quality of Earnings review to support the planned sale of the business. The engagement focused on reconstructing and validating historical financial performance using transaction-level data, bank activity, inventory records,...

  • Project Pipeline and 3-Statement Model
    • August 3, 2026

    A heavy civil construction contractor running operations across several entities asked Sapling to build a management model that delivers private equity-level, best-in-class budgeting and scenario planning. The goal was a 3-statement model and dashboard that builds up from the project pipeline, so the team could...