Application of rules to dataset and identification of ML$/$TF risks and generation of Customer alerts and new customer recommendations

Due Date: Monday $20$ May by $9$am $(12$ marks$)$

After discussion with the Branch Manager and AML Compliance Officer and having agreed upon appropriate rules you are required to complete the $3$ steps outlined below.

Step $1$: Apply these rules to the given dataset using MS Excel and Tableau to identify ML$/$TF risks.

It is highly recommended that you watch the pre$-$recorded Workshop $9$ video $($Workshop $9$ falls on a public holiday, so we have provided you with a recording$)$ and attend the Workshop in Week $10$ as you will be provided with instructions on how to utilise MS Excel and Tableau for your data analysis. It is advised that you should download the data and install the Tableau software before class.

Resources$/$rules for analysis and the data: $($to be released in week $8)$

Customer DataDownload Customer Data

Customer Transaction Data Download Customer Transaction Data$($note that this file is too large to open in Excel. You will have to save it from your downloads folder as a csv file, which can then be uploaded into Tableau.

Task $2$ RulesDownload Task $2$ Rules

Task $2$ Rules for new customers and business customersDownload Task $2$ Rules for new customers and business customers

Existing Business Customer DataDownload Existing Business Customer Data

Business Transaction Data Download Business Transaction Data$($note that this file is too large to open in Excel. You will have to save it from your downloads folder as a csv file, which can then be uploaded into Tableau$).$

New Customers InformationDownload New Customers Information

New Business Customer InformationDownload New Business Customer Information

Instructions for downloading Tableau:

Download the latest version of Tableau Desktop and Tableau Prep Builder hereLinks to an external site.

Click on the link above and select $$Download Tableau Desktop$$ and $$Download Tableau Prep Builder$.$ On the form, enter your school email address for Business E$-$mail and enter the name of your school for Organization.

Activate with your product key: TCL$5-6$AAA$-8$C$40-$F$2$E$8-165$E

Already have a copy of Tableau Desktop installed? Update your license in the application: Help menu $->$ Manage Product Keys

Are you new to Tableau? Refer to the free Student Resource PageLinks to an external site. to help you get started.

$($Students can continue using Tableau after the class is over by individually requesting their own one$-$year license through Tableau for StudentsLinks to an external site..$)$

Step $2$: Generate Customer alerts and evaluate new customers

Based on your analysis of the data using the given rules and appropriate software:

Generate a list of alerts from the existing customer transaction data. Your alerts should indicate the names of customers and red flags$/$reasons for alert generation.

Evaluate whether the new customers should be accepted$/$ accepted with ECDD or rejected.

Step $3$: Report your findings to your Branch Manager

Prepare your answers in MS Word and include a title page that lists all the members of your group. Your submission should specifically address the following criteria:

$1.$ Customer alerts and justification $-$ Provide your list of alerts. Your alerts should indicate the names of customers and red flags$/$reasons for alert generation. You should set this out in a table as follows:

No$.$

Customer Name

Red flag$/$reason

Supporting evidence reference

$1.$

XXX

Red flags$/$reasons

Appendix $1$

$2.$

YYY

Red flags$/$reasons

N$/$A

$3.$

ZZZ

Red flags$/$reasons

Appendix $2$

$4.$

$...$

$...$

$...$

In your appendices, you will then include any relevant explanations$/$evidence from Tableau, including screenshots to show commands and output.

$2.$ New Customer Recommendations $-$ Make recommendations as to whether the new customers should be accepted$/$ accepted with ECDD or rejected, giving justification for your decisions.

For information on the requirements for Task $3$ click on 'Next'

Submission