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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
