Get startedGet started for free

Story telling

Now we know that our actual Loan Profit Margin is greater than our Target Profit, we should explore why this happened. While it is great to make more money than we expected from the trade, lending is a competitive business where even a small price difference can mean the difference between winning or losing borrowers. Many borrowers will shop around at different mortgage lenders to get quotes; even a difference as small as .25% is enough to lose a potential borrower.

We can leverage some AI tools built into Power BI, like the Key influencers visual. This tool runs a regression analysis based on the inputs we put into it, and it simplifies the results by creating an informative visualization with statistically significant findings.

If you have lost progress, close any open workbooks and load 3_2_target_profit_solution.pbix from the Exercises folder on the Desktop.

This exercise is part of the course

Case Study: Mortgage Trading Analysis in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise