Ready yet?
In the last exercise, we explored loan_status.xlsx
and found that some loans were missing all the necessary time-stamps they need to be traded.
We need a simpler way to identify these loans than having to look through every single date field. One way to do this is to create our own status that can summarize the loan's readiness to trade.
If you have lost progress, close any open workbooks and load 1_3_post_close_process_solution.bpix
from the Exercises folder on the Desktop. Continue working on the Loan Statuses table.
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
