How vishalpandit531/aegisshield-insurance-data-analytics works
This repository is an insurance analytics project: cleaned customer, policy, claim, agent, and complaint datasets support SQL analysis and a seven-page Power BI dashboard, producing business insights and recommendations. The README documents the workflow and model relationships; source excerpts were unavailable, so links reflect only those documented flows, not unverified implementation details.
Main entry points: AegisShield Insurance Ltd.pbix Power BI Dashboard · Customers_Cleaned.csv Customers · Policy_Cleaned.csv Policies · Claim_Cleaned.csv Claims
Components 13
Insurance Data
- Customers
Customers_Cleaned.csv - Policies
Policy_Cleaned.csv - Claims
Claim_Cleaned.csv - Agents
Agents_Cleaned.csv - Complaints
Complaints_Cleaned.csv - Cleaning Log
Insurance_Project_Cleaning_Log.xlsx
Analysis
- MySQL Database
- SQL Analysis
- Power BI Dashboard
AegisShield Insurance Ltd.pbix
Business Outputs
- Business Insights
AegisShield_Insurance_Project_Report.pdf - Recommendations
AegisShield_Insurance_Project_Report.pdf
Other components
- Business Analyst
- Power BI
Connections 17
- Business Analyst → Customers: profiles data
- Business Analyst → Policies: profiles data
- Business Analyst → Claims: profiles data
- Business Analyst → Agents: profiles data
- Business Analyst → Complaints: profiles data
- Business Analyst → Cleaning Log: records cleaning
- Customers → MySQL Database: imports
- Policies → MySQL Database: imports
- Claims → MySQL Database: imports
- Agents → MySQL Database: imports
- Complaints → MySQL Database: imports
- SQL Analysis → MySQL Database: queries
- MySQL Database → SQL Analysis: returns results
- MySQL Database → Power BI Dashboard: models data
- Power BI → Power BI Dashboard: renders
- Power BI Dashboard → Business Insights: supports
- Business Insights → Recommendations: informs