Aviation Insurance PowerBI Customer Dashboard

I need a single, well-structured PowerBI report that brings together our aviation insurance statistics—Number of Aircraft, Premiums, and Claims—into a clean, reliable data model. I will supply the raw figures in several Excel workbooks; your job is to design the underlying data set, load and transform the sheets, and surface the key metrics in an intuitive, visually engaging way.

The data model must support:
• Bar, pie, and line visualisations for every metric
• Slice-and-dice analysis by year, policy type, or any additional dimensions found in the source files
• Quick comparison views so I can spot shifts in aircraft counts against premium volume and claims frequency

Deliverables
• A PowerBI (.pbix) file with clearly named tables, measures, and relationships
• Any data-prep steps documented in Power Query so future updates are simple
• A short read-me explaining how to refresh the report and where each figure originates

If you already work with insurance portfolios—or, better yet, aviation risk data—you’ll recognise the quirks of premium and claims timing, which will help ensure the visuals remain accurate and decision-ready.