Exercise#41: FIS TSYS (TS2) TSAD0553 Reject 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, Group By, Join
• Systems of Record: FIS TSYS (TS2)
• Estimated Time to Solve: 10 mins
• Exercise files required are attached Below;
  • TSAD0553 Reject Register.txt
  • TSYS Credit Card Reject List.xlsx

Exercise Overview

You are a Credit Card Analyst at a Financial Institution and your Manager has asked you to perform some analysis on the TSAD0553 Reject Register.txt in your FIS TSYS (TS2) system.

You are asked to answer the following questions;

• What reject reason occurred the most?
• How many unique credit cards had rejects?
• What is the total reject amount and current balance by Network?
  • First Digit of Card Number of 4 = Visa
  • First Digit of Card Number of 5 = MasterCard
  • First Digit of Card Number of 3 = Amex

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

Exercise 41 Files.zip