Unit Cost Summary Tool Development for Cigna

This document is a case study detailing the development of the Unit Cost Summary Tool for The Cigna Group by Thorogood, a Data & AI consultancy. The tool was created to assist Cigna's Competitive Intelligence (CI) team in processing and analyzing market data efficiently. The document outlines the challenges faced by Cigna in integrating competitive intelligence with marketplace analysis, emphasizing the need for a solution that streamlines data handling and enhances decision-making capabilities. The Unit Cost Summary Tool aggregates data from multiple external sources, performs predictive analysis, and allows for data validation and augmentation by regional teams. It also generates consumable intelligence for Cigna's matrix partners and retains historical data for future analysis. The development approach involved leveraging Thorogood's prior experience with Cigna, ensuring the tool's interface met the CI team's needs. Key outcomes include increased efficiency in data processing and improved adaptability to changing data sources.