Enabling Predictive Provider Analytics Through a Data Warehouse for a Digital Health Marketing Company
Our customer is a U.S.-based digital marketing and analytics company specializing in serving pharmaceutical companies.
The Need
The client needed to predict healthcare provider behaviour in connection with participation in promotional programs and drug prescription. The data required to predict this behaviour was fragmented across heterogenous sources, including SQL Server, Oracle, Excel, MS Access, and flat files.
The Challenge
- Identification of unique providers across multiple systems to avoid duplication.
- Defining precise business logic for transforming and cleansing data during ETL processes.
- Investigation and proper handling of discarded or incomplete data to improve data accuracy.
Get it now