# vishalpandit531/aegisshield-insurance-data-analytics architecture

> Architecture diagram of the GitHub repository vishalpandit531/aegisshield-insurance-data-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/vishalpandit531/aegisshield-insurance-data-analytics
- Repository: https://github.com/vishalpandit531/aegisshield-insurance-data-analytics

## Overview

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`](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield%20Insurance%20Ltd.pbix) (Power BI Dashboard), [`Customers_Cleaned.csv`](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Customers_Cleaned.csv) (Customers), [`Policy_Cleaned.csv`](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Policy_Cleaned.csv) (Policies), [`Claim_Cleaned.csv`](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Claim_Cleaned.csv) (Claims)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Insurance Data"]
  node_customers["Customers"]
  node_policies["Policies<br/>[Policy_Cleaned.csv]"]
  node_claims["Claims<br/>[Claim_Cleaned.csv]"]
  node_agents["Agents<br/>[Agents_Cleaned.csv]"]
  node_complaints["Complaints"]
  node_cleaninglog["Cleaning Log"]
end

subgraph group_analysis["Analysis"]
  node_mysql[("MySQL Database")]
  node_sqlanalysis["SQL Analysis"]
  node_dashboard["Power BI Dashboard"]
end

subgraph group_insights["Business Outputs"]
  node_insights["Business Insights"]
  node_recommendations["Recommendations"]
end

node_analyst(("Business Analyst"))
node_powerbi["Power BI"]

node_analyst -->|"profiles data"| node_customers
node_analyst -->|"profiles data"| node_policies
node_analyst -->|"profiles data"| node_claims
node_analyst -->|"profiles data"| node_agents
node_analyst -->|"profiles data"| node_complaints
node_analyst -->|"records cleaning"| node_cleaninglog
node_customers -->|"imports"| node_mysql
node_policies -->|"imports"| node_mysql
node_claims -->|"imports"| node_mysql
node_agents -->|"imports"| node_mysql
node_complaints -->|"imports"| node_mysql
node_sqlanalysis -->|"queries"| node_mysql
node_mysql -->|"returns results"| node_sqlanalysis
node_mysql -->|"models data"| node_dashboard
node_powerbi -->|"renders"| node_dashboard
node_dashboard -->|"supports"| node_insights
node_insights -->|"informs"| node_recommendations

click node_customers "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Customers_Cleaned.csv"
click node_policies "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Policy_Cleaned.csv"
click node_claims "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Claim_Cleaned.csv"
click node_agents "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Agents_Cleaned.csv"
click node_complaints "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Complaints_Cleaned.csv"
click node_cleaninglog "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Insurance_Project_Cleaning_Log.xlsx"
click node_dashboard "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield%20Insurance%20Ltd.pbix"
click node_insights "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield_Insurance_Project_Report.pdf"
click node_recommendations "https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield_Insurance_Project_Report.pdf"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_customers,node_policies,node_claims,node_agents,node_complaints,node_cleaninglog toneBlue
class node_mysql,node_sqlanalysis,node_dashboard toneAmber
class node_insights,node_recommendations toneMint
class node_analyst,node_powerbi toneIndigo
```

## Components

### Insurance Data

- [Customers](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Customers_Cleaned.csv): `Customers_Cleaned.csv`
- [Policies](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Policy_Cleaned.csv): `Policy_Cleaned.csv`
- [Claims](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Claim_Cleaned.csv): `Claim_Cleaned.csv`
- [Agents](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Agents_Cleaned.csv): `Agents_Cleaned.csv`
- [Complaints](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Complaints_Cleaned.csv): `Complaints_Cleaned.csv`
- [Cleaning Log](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/Insurance_Project_Cleaning_Log.xlsx): `Insurance_Project_Cleaning_Log.xlsx`

### Analysis

- **MySQL Database**
- **SQL Analysis**
- [Power BI Dashboard](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield%20Insurance%20Ltd.pbix): `AegisShield Insurance Ltd.pbix`

### Business Outputs

- [Business Insights](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield_Insurance_Project_Report.pdf): `AegisShield_Insurance_Project_Report.pdf`
- [Recommendations](https://github.com/vishalpandit531/aegisshield-insurance-data-analytics/blob/main/AegisShield_Insurance_Project_Report.pdf): `AegisShield_Insurance_Project_Report.pdf`

### Other components

- **Business Analyst**
- **Power BI**

## Connections

- 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