weekly-kpi-report

This Skill automates extraction and validation of weekly auto insurance data, calculates 16+ KPIs across business scale, profitability, structure, and risk categories, then generates a McKinsey-style executive PPT with week-over-week comparisons. Upload Excel or CSV data and the system returns a board-ready report.

Yes. The Skill ingests weekly auto insurance data from Excel or CSV, supports bilingual field names through field mapping, performs unit conversion and KPI calculations, and outputs an executive-ready PPT with progressive disclosure and actionable insights for board presentations.

The Skill calculates 16+ KPIs spanning four categories: business scale, profitability, structure, and risk. It supports segmentation by branch and customer, week-over-week comparisons, and cross-institution analysis to surface trends and performance drivers.

Yes. The Skill uses field_mapping.json to normalize bilingual field names, performs boolean normalization, handles unit conversion automatically, and supports both single-week snapshots and multi-week comparative analysis for auto insurance datasets.

Prepare weekly auto insurance data as Excel or CSV with fields aligned to Hua An Insurance Sichuan Branch schema. The Skill validates data, applies field mapping for bilingual support, normalizes boolean values, and converts units—no manual preprocessing required.

Yes. Supply two weeks of data to trigger week-over-week comparison analysis. The Skill segments KPIs by branch and customer, generates comparative insights, and surfaces them in the executive PPT with actionable recommendations.