You will get Auto Insurance Claims Analysis — FY2023
Rising Talent
Project details
3 professional sheets:
Claims Data - 500 rows of realistic auto insurance claims with claim type, region, adjuster, amounts, status, fraud flags, and days to close. Formatted with alternating row colors and a navy header.
Summary Analysis - Live formula-driven tables covering KPIs (total claims, total value, fraud count), breakdown by claim type, by region, and adjuster performance. Everything recalculates automatically.
Dashboard - 3 charts: claims count by type (bar), claim value by region (pie), and adjuster settlements (horizontal bar).
Claims Data - 500 rows of realistic auto insurance claims with claim type, region, adjuster, amounts, status, fraud flags, and days to close. Formatted with alternating row colors and a navy header.
Summary Analysis - Live formula-driven tables covering KPIs (total claims, total value, fraud count), breakdown by claim type, by region, and adjuster performance. Everything recalculates automatically.
Dashboard - 3 charts: claims count by type (bar), claim value by region (pie), and adjuster settlements (horizontal bar).
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$50
|
Standard
$100
|
Advanced
$150
|
|---|---|---|---|
| Delivery Time | 5 days | 10 days | 14 days |
Number of Revisions | 1 | 1 | 2 |
About Tameka
Management Consulting & Analysis | Insurance, Operations Analytics
Port Saint Lucie, United States - 10:44 am local time
With a BSc in Management Information Systems, a Google Data Analytics Certificate, and hands-on experience processing and analyzing insurance claims at scale, I bring both technical skill and real industry knowledge to every project. I'm proficient in Excel, data cleaning, pivot tables, and data visualization, and I communicate findings in plain language- no jargon, just results.
Whether you need a one-time data cleanup, a recurring reporting dashboard, or help making sense of messy spreadsheets, I deliver accurate, organized, and visually clear work on time.
Let's talk about what your data can do for your business.
Steps for completing your project
After purchasing the project, send requirements so Tameka can start the project.
Delivery time starts when Tameka receives requirements from you.
Tameka works on your project following the steps below.
Revisions may occur after the delivery date.
Data Review
I review your file, assess data quality, and identify any cleaning needed.
Data Cleaning
I remove duplicates, fix formatting issues, and standardize the dataset.