Exercise Files

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

• Customer-Membership Demographics.csv
  
• Checking Accounts.csv
  
• Debit Card Masterfile.csv
  
• Credit Card Masterfile.csv
  
• Consumer Loans.csv
• Mortgage Loans.csv

 

Exercise Overview

You are a Business Operations Analyst at a Financial Institution and you are working on a project that will help the marketing team create targeted campaigns for some customers of the organization. You need to create a 360 degree View of your customers based on which products they own to help marketing tailor the messaging. You manager has asked you to focus on the following products to create the view; Checking Accounts, Debit Cards, Credit Cards, Consumer Loans, and Mortgage Loans, and combine the data using the Data Prep Studio.

 

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.