quantumudit/Insurance-Portfolio-Analysis — reverse-engineered prompt

Build me a complete insurance portfolio analysis project for a fictional company that expanded aggressively across Florida counties in 2021. I want to start with raw insurance data, clean it with Python, and turn it into analysis ready files that can be used for charts, maps, and reporting.

Please include a simple ETL flow, organized project folders, clear sample data, and a Jupyter notebook that explains the main findings in plain English. The analysis should help someone understand portfolio growth, county level patterns, policy or premium trends, and any useful geographic insights across Florida.

Also create a Power BI report setup or dashboard guide that shows how to visualize the cleaned data with filters, cross filtering, county maps, summary cards, and trend charts. Use fictitious data only, but make it realistic enough for a business case study.

Keep the README beginner friendly so someone with basic Python and Power BI knowledge can run the project and understand the workflow from raw data to final dashboard.