UP TO 15 % DISCOUNT

Get Your Assignment Completed At Lower Prices

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
ANL303: Fundamentals of Data Mining Course Work, SUSS, Singapore: Credit card companies want to encourage their customers to make purchases using their credit cards
University Singapore University of Social Science (SUSS)
Subject ANL303: Fundamentals of Data Mining Course Work
Posted on: 3rd Apr 2024

ANL303: Fundamentals of Data Mining Course Work, SUSS, Singapore: Credit card companies want to encourage their customers to make purchases using their credit cards

Question 1

Credit card companies want to encourage their customers to make purchases using their credit cards because they earn fees and interest on those transactions. Individuals who have no card balance are not generating revenue for the credit card company since they are not using their cards for purchases. By sending promotional offerings to individuals with no card balance (i.e., zerobalance cardholders), the credit card company hopes to entice them to make a purchase. If they make a purchase, it will lead to the generation of revenue for the company.

Company ABC is a credit card company that often includes promotional offerings with their monthly credit card billings. The offers provide customers with an opportunity to purchase items, such as luggage, magazines, or jewellery. The dataset (credit_card_promotions.csv). contains customer information, such as age and income, obtained through their credit card applications with ABC. It also contains information about whether these customers have accepted various past promotional offerings sponsored by ABC. Details of the dataset are provided in Table 1.

Buy Custom Answer of This Assessment & Raise Your Grades

Fundamentals of Data Mining
Fundamentals of Data Mining

In this question, you are going to import the dataset to IBM SPSS Modeler and perform all data mining tasks (including data preparation, if any) using IBM SPSS Modeler.

(a) Identify the data quality issues in the dataset and perform data cleaning. In less than 100 words, briefly describe how the dataset is cleaned and becomes suitable for data mining using IBM SPSS Modeler. Provide necessary screenshot(s).

(b) Using the dataset obtained from part (a), perform data visualisation that can answer the following enquiries:
Enquiry 1: What are the top three most popular promotions among zerobalance cardholders?
Enquiry 2: Is it true that the average income for zerobalance cardholders is higher than the average income for nonzerobalance cardholders in both gender groups?

Provide one (1) graphical display for each enquiry to support your answers.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
(c) Sending promotional materials to everyone is wasteful. ABC has decided to target their marketing efforts more effectively, specifically by aiming to encourage card usage and generate revenue from individuals with no card balance. To achieve this goal, they would need to identify the subgroup of customers who are likely to have no card balance.


(i)
Construct a kmeans model that can provide insights into the characteristics of customers likely to have no card balance. Describe how you identify your model as the final best model. For the model that you have chosen, provide the screenshot of the model’s outputs (showing the cluster summary, and the cluster comparison) and describe the profile of each cluster.

(ii) Discuss how you identify the target customers for ABC based on the clustering results.

(d) Based on part (c), ABC has identified the target customer group for their promotional offerings. Only the target group would be sent promotional information. Construct an association rule mining model that can help ABC understand customer preferences among the promotional offerings within the target group.


Pick two (2) rules that you find interesting. Describe them in terms of support, rule support and confidence, and discuss insights that can help ABC generate revenue.

In your answer, provide screenshots that show clearly (i) which fields are selected for the analysis and their roles, (ii) the parameters used in the algorithm, and (iii) the association rules that you picked for discussion.

(e) Assume that ABC has authorised a new life insurance promotion similar to the previous life insurance promotion. This new life insurance promotion is exclusive for new cardholders who have not had a chance to take advantage of a previous promotion. Based on the dataset described in Table 1, assess the suitability of association analysis for identifying the profile of new cardholders likely to accept the new life insurance promotion.

If it is suitable, discuss (i) which field(s) listed in Table 1 should be included as the antecedent and consequent; (ii) if any data preparation task should be done.

Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Get Help By Expert

Need help with your ANL303: Fundamentals of Data Mining Course Work? Look no further! Assignment Help Singapore offers expert assistance for Singapore students. Whether you require assistance with assignments or need someone to write my report, our team of skilled professionals is here to support you. Focus on mastering your course while we take care of the rest

Categories:-
Tags:-
Answer
Recent Solved Questions
No Need To Pay Extra
  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00
    Per Page
  • Consultation with Expert

    $35.00
    Per Hour
  • Live Session 1-on-1

    $40.00
    Per 30 min.
  • Quality Check

    $25.00
  • Total
    Free

New Special Offer

Get 30% Off

UP TO 15 % DISCOUNT

Get Your Assignment Completed At Lower Prices

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now
My Assignment Help SG Services
My Assignment Help SG

Rated 4.9/5 Based on 22945 Singaporean Students