Claims Analysis Dashboard – Excel In Business

Claims Analysis Dashboard

Please select the icon above to run the Dashboard in Full Screen

Benefits & Features

Where post code metadata exists in the underlying source data, full Claims demographic analyses can be provided at both Regional and District areas
Innovative Word Cloud analysis allows Claims Incident reports to be analysed by key words to spot exposure to certain types of claim
Claims data can be presented and contrasted by either Incident Date (date of loss), Notification Date (from the broker) and Transaction Date (accounting date)
Full summary and detailed claims analysis are available by Claims Type

Data Source(s)

Any Policy Administration system from a Premiums perspective
Any Claims system, Third Party Administrator (TPA) system
Premium and/or Claims Bordereau files

MI Platform

Underlying MI Data Warehouse produced by EiB AppStudio in Microsoft Azure cloud
Power BI Models stored as Premium Per User (PPU) or Premium datasets
Excel reporting provided by connecting EiB ReportStudio in Excel 365 to the Power BI Model

Customisation

The Power BI Dashboard whilst shown above for Motor, can be easily produced for Personal Lines, Commercial Lines and other Line of Businesses (LOB)
The Power BI dashboard file will be made available to each Customer so derivatives can be easily developed by those Customers who want to own ongoing development of their Dashboards
JSON file will also be provided, so corporate branding guidelines can be applied
EiB Power BI Template also provided to provide a common methodology for developing new Dashboards