{'fraction_non_alphanumeric': 0.01240694789081886, 'fraction_numerical': 0.006617038875103391, 'mean_word_length': 5.954022988505747, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Application of Data Visualization for Improved Healthcare Insurance Management using QlikView

The healthcare insurance industry would be grounded in the absence of quality business intelligence, data analytics and visualization. Appropriate claims ratio, controls on budgetary limits and stable claims pipeline are essential to profitability, market share and customer delight. Analysis of claims was carried out monthly and quarterly between 2014 and 2018. QlikView has been applied to obtain deeper insights into healthcare insurance data from a purposively selected healthcare insurance service provider in Kenya. Data analytics revealed hitherto unbeknown data integrity issues, cost management pointers and case management insights, scheme performance to guide premium entitlement and ailment cost burden management. QlikView is recommended for simple and easily-deployable data analytics application. The human intervention and the overheads of data harvesting for QlikView analytics can be reduced by integration of QlikView on the databases into the future of application in the healthcare insurance industry. Application of simple tools, QlikView is recommended for data analytics and visualization.