analyzing-auto-insurance-data

What problem does it solve?

This Skill specializes in analyzing vehicle insurance daily reports and signing lists, transforming raw data into actionable business insights. It helps users monitor performance, identify trends, and detect anomalies, enabling data-driven decision-making.

Core Features & Use Cases

• 7-Step Analysis Workflow: Guides through data loading, cleaning, metric calculation, dimensional analysis, anomaly detection, and report generation.
• AI-Friendly Data Handling: Prioritizes CSV/JSON for efficient AI processing, with robust Excel conversion support.
• Business Rule Integration: Incorporates specific rules for negative premiums, zero commissions, and staff-institution mapping for accurate attribution.
• Anomaly Detection: Identifies critical business anomalies like daily premium fluctuations, weekend surges, and institution concentration risks.
• Use Case: A business analyst needs a weekly performance review of insurance data. This skill can process the latest data, compare daily trends across weeks, highlight top-performing institutions, and flag any unusual business activities.

Quick Start

Analyze the attached 'daily_insurance_report.csv' to generate a summary of total premium, policy count, and any detected anomalies.