Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I`m new to power query, this mock sample data is based on a marketing campaign to find out the results of how many samples opened a term deposit after the campaign, and to create visuals to view what categories of data show the biggest uptake by ranking via matrix and bar charts, pie charts.
Attribute Information:
# bank client data:
1 - age (numeric)
2 - job : type of job (categorical: "admin.","unknown","unemployed","management","housemaid","entrepreneur","student", "blue-collar","self-employed","retired","technician","services")
3 - marital : marital status (categorical: "married","divorced","single"; note: "divorced" means divorced or widowed)
4 - education (categorical: "unknown","secondary","primary","tertiary")
5 - default: has credit in default? (binary: "yes","no")
6 - balance: average yearly balance, in euros (numeric)
7 - housing: has housing loan? (binary: "yes","no")
8 - loan: has personal loan? (binary: "yes","no")
# related with the last contact of the current campaign:
9 - contact: contact communication type (categorical: "unknown","telephone","cellular")
10 - day: last contact day of the month (numeric)
11 - month: last contact month of year (categorical: "jan", "feb", "mar", ..., "nov", "dec")
12 - duration: last contact duration, in seconds (numeric)
# other attributes:
13 - campaign: number of contacts performed during this campaign and for this client (numeric, includes last contact)
14 - pdays: number of days that passed by after the client was last contacted from a previous campaign (numeric, -1 means client was not previously contacted)
15 - previous: number of contacts performed before this campaign and for this client (numeric)
16 - poutcome: outcome of the previous marketing campaign (categorical: "unknown","other","failure","success")
17 - y - has the client subscribed a term deposit? (binary: "yes","no")
_________________________________________________________________________________________________________________
I was trying to create an IF statement to convert the hasTermDeposit results to a 0 or 1 so I could use them as values in a matrix in visuals.
I also attempted to add a column and convert yes to 1 and no to 0 in Power Query so I could count that column in visuals.
Thank you, any feedback is helpful.
in power query created hasTD to convert no to 0 and yes to 1.
also not sure why my talbe name is not being recognized in the DAX formula or the column names.
Hello @jitterbug777 ,
2 points :
Have a good day
User | Count |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |