DATA WAREHOUSE DESIGN FOR PATIENT CASE ENGAGEMENT PLATFORM
Data Warehouse design for patient case engagement platform Problem A Swedish software development company offering pharmaceutical companies a cloud-based and easy-to-use patient case engagement platform was experiencing data inconsistency. The company stores the data in a PostgreSQL JSON database used for analytics and dashboarding in their application. The existing data structure didn’t allow business users…