📊 Insurance Data Analysis Dashboard

This repository showcases an interactive Power BI dashboard developed for PRISM Insurance Pvt. Ltd., providing a comprehensive overview of key insurance metrics such as policy distribution, claim status, premium trends, and customer demographics.

📚 Table of Contents

• Project Overview
• Business Problem
• Key Insights
• Dataset
• Tools Used
• Getting Started
• Future Enhancements
• Author & Contact

🧾 Project Overview

The dashboard visualizes insurance data to help stakeholders monitor performance, identify trends, and make data-driven decisions. It includes filters, summary statistics, and multiple visualizations for intuitive exploration.

🧠 Business Problem

PRISM Insurance Pvt. Ltd. manages a diverse portfolio of insurance products including Travel, Health, Auto, and Life policies. With thousands of customers and claims processed across age groups and policy types, the company faces several key challenges:

• 📉 Lack of visibility into claim outcomes: Stakeholders need a clear breakdown of settled, rejected, and pending claims to assess operational efficiency and customer satisfaction.
• 💰 Premium vs. Coverage imbalance: Understanding how premium amounts compare to coverage and claim payouts is critical for pricing strategy and risk management.
• 👥 Customer segmentation gaps: Insights into customer activity (active vs. inactive) and demographics (e.g., gender, age group) are essential for targeted marketing and retention.
• 📊 Policy performance tracking: Comparing claim amounts and premium contributions across policy types helps identify underperforming products and optimize offerings.

This dashboard addresses these challenges by providing a centralized, visual summary of insurance operations, enabling data-driven decisions for underwriting, claims processing, and customer engagement.

📌 Key Insights

• Summary Metrics:

  • Premium Amount: ₹5.98M
  • Coverage Amount: ₹600.55M
  • Claim Amount: ₹16.91M

• Claim Status Distribution:

  • Settled: ~6.4K
  • Rejected: ~3.8K
  • Pending: ~2.8K

• Premium by Policy Type:

  • Travel: ₹2.5M
  • Health: ₹2.3M
  • Auto: ₹1.2M
  • Life: ₹0.5M

• Claim Amount by Age Group:

  • Adult: ₹8.3M
  • Elder: ₹6.4M
  • Young Adult: ₹2.2M

• Customer Activity:

  • Active Customers: ~11.5K
  • Inactive Customers: ~3.5K
  • Female Customers: 5,001

📂 Dataset

• CSV file is located in the /Data/ folder:
  • InsuranceData.csv

🛠️ Tools Used

• Power BI for dashboard creation and data visualization
• Excel / CSV as data source (assumed)
• Git & GitHub for version control and project sharing

🚀 Getting Started

To explore or extend this project:

1. Clone the repository.
2. Open the .pbix file in Power BI Desktop (if available).
3. Replace or update the data source as needed.
4. Customize visuals or filters to suit your analysis goals.

📈 Future Enhancements

• Add time-series analysis for claims and premiums
• Integrate customer satisfaction metrics
• Enable drill-through for individual policy and claim details

👤 Author & Contact

Tanay Srivastava
Data Analyst
📧 Email: tanaysrivastava562@gmail.com
🔗 LinkedIn

---