A 94-measure Power BI model for a lender's loan book

The challenge

The lender needed reliable loan-book analytics that their team could build on and trust, with clear rules for how every number is calculated.

What we built

• A Power BI semantic model with 94 base measures across 12 business themes
• 38 tables and 59 relationships, organised so reports stay fast and consistent
• Calculation groups to avoid duplicating time-intelligence and variance logic
• A 24-page technical document covering how the model works, governance risks and data lineage

The result

The lender has one trusted source for loan-book reporting, and documentation that lets their own team and auditors understand exactly where each number comes from.