Exercise#40: ICE Mortgage MSP P-181 Analysis

Baba_Majekodunmi_703

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.

https://fast.wistia.net/embed/iframe/nivy0e3c2h?web_component=true&seo=true&videoFoam=false

Exercise 40 Files.zip

Exercise 40 Files.zip