Logo Lanfrica
  • Home
  • Atlas
  • Insights
  • Docs
  • Sign in

© 2026 Lanfrica. All rights reserved. All copyrights of the resources shown on the Lanfrica website belong to the original copyright holders, unless explicitly stated otherwise.

prabalpkd/EIC-CaseStudy-Dashboard

Domain:

socioeconomic
Creator:
pra
Host:
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, …

Visit

github.com

Languages

Amharic

Similar

nahid-rgb/EIC-Vehicle-Insurance-Dashboardfaciladev/eic-appfaciladev/eic-web-scraperfaciladev/eic-rest-apiNovaDataAnalytics/retail-data-quality-casestudyLiSTra, Automatic Speech Translation : English to Lingala casestudy

nahid-rgb/EIC-Vehicle-Insurance-Dashboard

A Power BI dashboard analyzing vehicle insurance data (2014–2018) from the Ethiopian Insurance Corpo

faciladev/eic-app

A mobile app built using Flutter that consumes investment data for the country of Ethiopia. # Inves

faciladev/eic-web-scraper

A web scraper that collects investment data for the country of Ethiopia from different websites. #

faciladev/eic-rest-api

A REST API that serves investment data for the country of Ethiopia. # A REST API using DRF A pytho

NovaDataAnalytics/retail-data-quality-casestudy

How dirty data cost a South African retailer R2.9M in phantom revenue — a data cleaning case study

LiSTra, Automatic Speech Translation : English to Lingala casestudy

In recent years there have been great interests in addressing the low resourcefulness of African languages and provide baseline models for different Natural Language Processing tasks. Several initiatives on the continent use the Bible as a data source to provide pr