Exercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Report Templates, Filter, Duplicate, Join
- Systems of Record: ICE Mortgage Black Knight MSP
- Estimated Time to Solve: 10 mins
- Exercise files required are attached Below;
- P-181 Trial Balance by Investor.txt
- Passport P-181 Trial Balance by Investor.csv
Exercise Overview
You are an Investor Reporting Analyst at a Financial Institution and your Manager has asked you to perform some analysis on the P-181 Trial Balance by Investor.txt in your ICE Mortgage (formerly Black Knight) MSP system.
You are asked to answer the following questions;
- How many mortgages have a Principal Balance that is greater than $400K?
- How many mortgages have a monthly payment that is greater than $5,000
- How many mortgages have a different Principal Balance on the P-181 txt file vs. the Passport csv file.
