Identification of the Limitations of Healthcare Service/Insurance Industry ERPs on Data Flow using QlikView and MS Excel

Digital transformation has enterprise benefits at the operational, tactical and strategic levels of the enterprise. The healthcare service/insurance sector would benefit from digital transformation. Analysis was done on data drawn from three healthcare service/insurance industry ERPs available in Kenya: PARAS, eOxegen and digital medical card system on the efficacy of data exchange/flow. Data was obtained from the intersection of the three systems for the months of March and April 2018 based on access to data and month-on-month comparison. Juxtaposition, comparison and summation was done using functions in QlikView and Microsoft Excel. Inconsistencies were observed on the data between the three systems with significant monetary value. Data analytics using common Microsoft Excel and QlikView tools is recommended for identification of inconsistencies and limitations in healthcare service/insurance ERPs. The study is beneficial to healthcare service/insurance players, ERP solution developers and project implementers for consistent data flow and mitigation of the pursuant risks.