logo Hurry, Grab up to 30% discount on the entire course
Order Now logo
1210 Times Downloaded

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Alan DuderMarketing
(5/5)

585 Answers

Hire Me
expert
Blake BarnesEngineering
(5/5)

675 Answers

Hire Me
expert
MAHIMAStatistics
(/5)

850 Answers

Hire Me
expert
Nawaaj KhanEducation
(5/5)

825 Answers

Hire Me
Others
(5/5)

Define the problem and perform an Exploratory Data Analysis

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Description

Context:

AllLife Bank wants to focus on its credit card customer base in the next financial year. They have been advised by their marketing research team, that the penetration in the market can be improved. Based on this input, the Marketing team proposes to run personalised campaigns to target new customers as well as upsell to existing customers. Another insight from the market research was that the customers perceive the support services of the back poorly. Based on this, the Operations team wants to upgrade the service delivery model, to ensure that customers queries are resolved faster. Head of Marketing and Head of Delivery both decide to reach out to the Data Science team for help

Objective: To identify different segments in the existing customer based on their spending patterns as well as past interaction with the bank.

Dataset:  ALLLife bank

Data Description: Data is of various customers of a bank with their credit limit, the total number of credit cards the customer has, and different channels through which customer has contacted the bank for any queries, different channels include visiting the bank, online and through a call centre.

Apply the concepts and techniques you have learned in the previous weeks and summarize your insights at the end.

Key Questions:

1. Perform EDA.

2. Apply Clustering Algorithms and mentions how many clusters are formed ?

3. How are these segments different from each other?

4. What are your recommendations to the bank on how to better market to and service these customers?

Submission Guidelines :

1. There are two parts to the submission: 

        1. A well commented Jupyter notebook [format - .ipynb]

        2. A presentation as you would present to the top management/business leaders [format - .ppt /.pptx]

Criteria                                                                                    Points

Define the problem and perform an Exploratory Data Analysis

1. Problem definition, questions to be answered - Data background and contents Univariate analysis  

2. Bivariate analysis 7

Illustrate the insights based on EDA Key meaningful observations on individual variables and the relationship between variables 7

Data pre-processing

1. Prepare the data for analysis 

2. Feature Engineering 

3. Missing value Treatment 

4. Outlier Treatment 

5. Duplicate observations check and removal if found 4

Applying K-means clustering algorithms

1. Apply K-means 

2. Elbow curve 

3. Silhouette Score 

4. figure out appropriate number of cluster 10

Applying Hierarchical clustering

1. Apply Hierarchical clustering with different linkage methods  

2. Plot dendrograms for each linkage methods 

3. Choose appropriate number of cluster 10

"Compare cluster K-means clusters and Hierarchical clusters - Perform cluster profiling - Derive Insights"

1. Compare clusters obtained from k-means and hierarchical clustering techniques 

2. Perform cluster profiling 

3. Insights about different clusters 7

Actionable Insights & Recommendations

1. Conclude with the key takeaways for the business 

2. What would your business recommendation. 5

Report - Overall quality

"- Structure and flow - Crispness - Visual appeal - All key insights and recommendations covered?" 5

Notebook - Overall

"- Structure and flow - Well commented code" 5

                                                                                 Points 60

(5/5)
Attachments:

Expert's Answer

1210 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme