Hello Tableau experts I need a dashboard example for analysis here is a description and data attached. Can be any chart or table or chart and table. Thank you for the help.
You are provided with 1.5 years of customer behaviour data from an anonymous bank. This consists of customer personal details (Customer Personal Details.csv) and the products of the bank they have subscribed to (Customer Products.csv).
The data starts at 2015-01-28 and has monthly records of products a customer has, such as "credit card", "savings account", etc. These products are the columns named: ind_(xyz)_ult1 etc.
Like many situations you will face as an analyst, the stakeholder doesn’t know what information the data has within it. You are to analyse the data to tell us what is happening in the business.
· Have there been any significant changes in Customer Behaviour or product holdings?
· What could be some of the drivers of this change?
· What would you recommend the bank does next?
The table is partitioned for this column
Employee index: A active, B ex employed, F filial, N not employee, P pasive
Customer's Country residence
The date in which the customer became as the first holder of a contract in the bank
New customer Index. 1 if the customer registered in the last 6 months.
Customer seniority (in months)
1 (First/Primary), 99 (Primary customer during the month but not at the end of the month)
Last date as primary customer (if he isn't at the end of the month)
Customer type at the beginning of the month ,1 (First/Primary customer), 2 (co-owner ),P (Potential),3 (former primary), 4(former co-owner)
Customer relation type at the beginning of the month, A (active), I (inactive), P (former customer),R (Potential)
Residence index (S (Yes) or N (No) if the residence country is the same than the bank country)
Foreigner index (S (Yes) or N (No) if the customer's birth country is different than the bank country)
Spouse index. 1 if the customer is spouse of an employee
channel used by the customer to join
Deceased index. N/S
Addres type. 1, primary address
Province code (customer's address)
Activity index (1, active customer; 0, inactive customer)
Gross income of the household
segmentation: 01 - VIP, 02 - Individuals 03 - college graduated
Más particular Account
particular Plus Account