Altair Monarch Exercise 12 - Debit Card Analytics
Baba_Majekodunmi_703
Altair Employee
Exercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
- Skills/Features Tested: Report Trapping, Filters, Formula Fields, Group By, Join, Append
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached
- Debit Card Transactions.txt
- Debit Card Masterfile.xlsx
- Customer-Membership Demographics.xlsx
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-Membership 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.
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.
0