prabalpkd/EIC-CaseStudy-Dashboard

Power BI Dashboard Exploring the Causes Behind the Downfall of EIC (Ethiopian Insurance Company) # 📊 EIC Case Study Analysis Dashboard An interactive Power BI dashboard developed as part of a data analysis case study to explore key trends, segment profitability, claims, and policy insights for EIC (Ethiopian Insurance Company). This dashboard provides a comprehensive view of premium and claim data across different vehicle types and usage categories from 2014 to 2018. ## 📷 Screenshot ## 🧩 Overview The EIC Case Study Analysis dashboard focuses on answering critical business questions, including: - **Who is buying our policies?** Identifies which vehicle categories contribute most to policy counts (e.g., Motor-cycles, Trucks, Pick-ups). - **Who claims the most?** Visualizes the distribution of claim amounts by usage type, highlighting significant contributors such as Agricultural Any Farm and Car Hires. - **Premium vs Claims (averages):** A scatter plot comparing average premium values with average claim amounts to analyze profitability across segments. - **Profitability over time:** A heatmap to observe profitable and underperforming segments across years, revealing trends and opportunities. - **Claims by demographic:** Highlights claim patterns based on policyholder sex, showing which group files more claims per policy. ## 📌 Key Metrics & Insights - **Policies Opened:** ~57K - **Total Premium Collected:** $384M - **Total Claim Amount:** $337M - **Premium to Claim Ratio:** 113.8% - **Average Premium per Policy:** $7K - **Average Claim Amount:** $6K - **Claim Count:** 2K ✅ Most policies are bought for Motor-cycles, Trucks, and Pick-ups. ✅ Agricultural usage shows high profitability, while segments like Car Hires and Others show mixed results. ✅ The Premium to Claim ratio suggests overall profitability but also highlights areas needing closer monitoring. ## 📈 Dashboard Highlights - **Interactive Year Filter:** Filter visuals by year (2014–2018) to explore yearly trends. - **Dynamic Visuals:** Including bar charts, area charts, scatter plots, pie charts, …