This repository contains the project files for the Shield Insurance data analysis and dashboard creation, completed as part of my virtual internship at Codebasics.
The primary goal of this project was to assist Shield Insurance, an imaginary company, in making data-driven decisions by analyzing their data from November 2022 to April 2023.
The task was to create an interactive dashboard that visualizes key insights and metrics required by the company to understand their performance and customer preferences better.
Dim Customer: Contains customer demographic information.
Dim Policies: Contains details about different insurance policies.
Dim Date: Contains date-related data to facilitate time-based analysis.
Fact Premiums: Contains data about premiums collected.
Fact Settlements: Contains data about insurance settlements.
Microsoft Power BI: For creating the dashboard and visualizations. Microsoft PowerPoint: For presenting the findings and insights.
Revenue and Customer Distribution: Delhi NCR generated the highest revenue and had the most customers compared to other cities.
Sales Channels:
Over half of the customers preferred offline agents, although there is a noticeable shift towards online sales. Popular Policies:
The policy POL4321HEL, which provides a coverage amount of 2 lakh, is the most popular and the cheapest.
Customer Age Groups:
The age groups 31-40 and 41-50 have the highest number of customers.
The 31-40 age group, in particular, has the highest number of customers, totaling 11,000.
Sales Trends:
Sales through offline agents are decreasing, while online sales are on the rise.
Settlements:
Although the settlement percentage is higher for the 65+ age group, the 31-40 age group has the highest expected settlements.
Power BI Dashboard File: The Power BI file (.pbix) with all the visualizations and insights. Presentation: PowerPoint presentation summarizing the project and findings.
To explore the dashboard and insights:
Open the Power BI dashboard file in Microsoft Power BI Desktop.
Navigate through the different visualizations and reports to understand the data and insights.
Refer to the PowerPoint presentation for a concise summary of the findings.
This project provided valuable insights into Shield Insurance's customer base, sales trends, and policy preferences, aiding in strategic decision-making. The shift towards online sales and the popularity of specific age groups and policies can help the company tailor their offerings and marketing strategies accordingly.
Feel free to explore the repository and provide feedback or suggestions for improvement.
Contact: For any queries or further information, please reach out via Mail ([email protected]).