Consolidating data from multiple on-premises source transaction systems and making it ready for consumption by business departments. Standardised, transformed, and visualised datasets were delivered for patient visits, revenue, and the rejection cycle for the client's hospital, clinic, and pharmacy operations.