Exercise Files

You can download all Monarch exercise files here: Monarch Sample Files for Exercises

• Debit Card Transactions.txt
• Debit Card Masterfile.csv
• Customer-Membership Demographics.csv

Exercise Overview

You are a Debit Card Analyst working at a Financial Institution and you need to identify the list of Active and Inactive Debit Cardholders in your Debit Card Portfolio. To accomplish this your manager has asked you to use the Data Prep Studio to combine data from the Debit Card Transactions file, Debit Card Masterfile, and finally against a Customer-Memberhsip Demographic file. This information will help your leadership come up with strategies to grow the Penetration, Activation, and Usage (PAU) metrics of the Debit Card Portfolio.

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.