You can download all Monarch exercise files here: Monarch Sample Files for Exercises
You are a Credit Analyst and you need to prepare data that will be useful for developing a Credit Risk Model, used to manage lending risk in a financial institution. Using the Data Prep Studio You'll need to prepare data by acquiring it from a variety of data sources (pdf, Access, Excel) that consist of customer demographics, account balance information, and additional reference information. Fortunately, there is a unique identifier across the files so you should be able to join the data with ease.
Once the data is combined and prepared, you will export the data and share it with your colleagues in the Modeling team that will use a Statistical Modeling tool of choice (like Altair Knowledge Studio) to develop the Credit Risk Model.
Before sharing the final prepared data you decide to answer the following questions that you believe will provide helpful insights for your colleagues who will be developing the credit risk model:
Step 1: Combine data from multiple files to build the credit risk file.
Step 2: Answer the following questions/perform the following tasks:
Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.