Business Case:

To analyze operations and volumetrics related to insurance premium and derive appropriate trend analysis from the data. To understand and dig deeper into the different types of policy.

Solution:

To create an overview that spans information about policies, premiums and gives a trend analysis in terms of relevant KPIs.

Technology used:

Power BI

Data Source:

There are three sections of the report:

Operational Analysis:

Gives an overview of account premium and the different KPIs.

Premium Banding:

Dives into high and low premium banding of policy count and general insight into policy by KPIs.

Trend Analysis:

Analysis of trends with respect to different KPIs.