The Challenge
They had valuable historical data of all studies in different data formats under different systems covering multiple therapeutic areas. Significant amount of study planning and tracking information were also in thousands of spreadsheets. Many GBs of data was exchanged between the client and their customers on a weekly basis.
Client depended on many manual operations for accessing and analysing data for BI. These insights were not only important to track the studies but also to predict various inflection points of studies still in the planning stage. This manual processing resulted in a long time to obtain these valuable insights and quality reports were not available throughout the organization.
Integrate the data from Study budgets, Clinical Trial Management System, Timesheets, HR and Payroll data, Vacation management system and Finance and Invoicing system and create data lake. The data from the disparate data sources couldn’t be integrated seamlessly. The existing systems inefficiency to handle unstructured data was affecting the quality of the business intelligence derived. The client was expecting an intuitive and a responsive user interface to generate various reports and dashboards.