There has been a revenue decline for a bank and they would like to know what actions to take. After investigation, they found out that the root cause is that their clients are not depositing as frequently as before. Term deposits allow banks to hold onto a deposit for a specific amount of time so they can invest in higher gain financial products to make a profit. In addition, banks also hold better chance to persuade term deposit clients into buying other products such as funds or insurance to further increase their revenues. As a result, the bank would like to identify existing clients that have higher chance to subscribe for a term deposit and focus marketing efforts on such clients.
The assessment consists of two analytical tasks:
Task 1: Based on the analysis from a number of marketing campaigns the bank performed, predict which of the existing clients are most likely to subscribe to a term deposit. The marketing campaigns were based on phone calls. Often, more than one contact to the same client was required. For this task you are provided with two data files. The first one, MarketingCampaignsData.csv, includes information about:
The second file, ExistingCustomers.csv, holds the information about bank’s current customers and includes everything listed above except column y. Building on the knowledge obtained from the first file, try to predict which of the bank’s current customers are most likely to subscribe to a term deposit. To build prediction model, choose the best prediction technique, explain which variables are most important for predicting client subscription to a term deposit, and establish who will subscribe. Provide a detailed explanation of your analytical approach – i.e. workflow model and its elements. Explain step by step what was done to get the best possible predictions. Provide detailed overview of the outputs and elaborate your findings.
Task 2: Once you have established who is most likely to subscribe to a term deposit, explore if different types of subscribers exist. More specifically, establish how many segments of subscribers there are, profile and name the identified segments, and recommend marketing strategy for each segment. As in the previous task, elaborate your approach and your findings.
Once you have completed the two tasks, you need to provide recommendations on what actions the bank should take to improve subscription to its bank term deposit service. While you have creative freedom, your recommendations have to be linked with the insights you have created and other external sources (from research and/or practice). Please note that there will be two audiences reading this report. First audience is the bank’s board of directors. They do not like technical and lenghty reports, which require hours of reading. Instead, they prefer intuitive info graphs with very little text that can be easily understood. They are willing to read up to 3 infographic slides. Put these in the executive summary so they do not have to struggle finding them in your report. The second audience is the bank’s data analysis team. They will be interested to thoroughly read and inspect your analytical approach and findings. Therefore, be elaborate and precise and provide links to all your models so they can inspect your workflows, working files, and outputs. Make sure you justify decisions in building models. Bear in mind you do all of these analyses to help the bank improve subscription to its term deposit product.
All analyses must be performed in Orange Data Mining software. If necessary, install addons that will assisst you in completing the two tasks. In explaining your analytical approach you are allowed to insert workflow screenshots. It is vital that your workflows are well annotated and made available. Therefore, save all your workflows and data files on your LJMU provided Microsoft OneDrive cloud storage and provide link to it so they can be inspected when marking. Failing to do so will have negative impact on your final mark. When making infographics you can use Excalidraw for making drawings and Flaticon to access a large library of visual elements and icons you may need. Both tools can be used for free and are available without installation via a browser. Of course, you do not need to use these tools and are free to use any other software you wish. Producing data analysis report is a very demanding task. Hence, you should start working on it as soon as possible!
The assessment is an individual report (4,000 words) where only part of that is written report proper (2,000 – 2,500 words). The rest will be workflows and datasets that you have to produce by using Orange Data Mining software. The link to all your workflows and datasets must be included in your submission (via a link to your Microsoft OneDrive cloud storage) and will be counted as equivalent of 1,500 – 2,000 words.
Your report ought to be structured as follows:
Cover page
Table of contents
Executive summary infographics
References
Appendices
For both tasks, you need to provide a link to Microsoft OneDrive cloud storage, which will provide access to all your workflows and datasets. Once your report is submitted, you are not allowed to alter your workflows and datasets. Dates on files will be checked. Screenshots of your workflows and your actual workflows must not differ. Otherwise, your tasks will not be marked.
The assessment assesses the following learning outcomes:
Enjoy 24/7 customer support for any queries or concerns you have.
Phone: +1 213 3772458
Email: support@gradeessays.com