Monarch Exercise 32 - Sagent LoanServ 0067-001 Daily Cash Audit Trial Balance

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited January 23 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Classic
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested:  Standard Trap, Append, Group Footer, Summary
  • Systems of Record: Sagent LoanServ
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached Below;
    • 0067-001 CASH AUDIT TRAIL REPORT.txt

Exercise Overview

You are an Investor Reporting Analyst at a Financial Institution and your Manager has asked you to perform some analysis on the 0067-001 CASH AUDIT TRAIL REPORT.txt in your Sagent LoanServ system.

You are asked to answer the following questions;

  • How many unique accounts had Activity?
  • Which accounts had an Escrow Return?
  • Which accounts had Expenses Fees?

Answer

  • Please upload your answers below in the comment section for the exercise
  • A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.
Tagged:

Categories