Sunday, 15 September 2013

Cube design sql server 2008

Cube design sql server 2008

i have a database that is related with direct marketing campaigns of a
Portuguese banking institution. The marketing campaigns were based on
phone calls. Often, more than one contact to the same client was required,
in order to access if the product (bank term deposit) would be (or not)
subscribed.
The columns provided are the following (column name,description):
age (numeric)
job : type of job (categorical:
"admin.","unknown","unemployed","management","housemaid","entrepreneur","student",
"blue-collar","self-employed","retired","technician","services")
marital : marital status (categorical: "married","divorced","single";
note: "divorced" means divorced or widowed)
education (categorical: "unknown","secondary","primary","tertiary")
default: has credit in default? (binary: "yes","no")
balance: average yearly balance, in euros (numeric)
housing: has housing loan? (binary: "yes","no")
loan: has personal loan? (binary: "yes","no") # related with the last
contact of the current campaign:
contact: contact communication type (categorical:
"unknown","telephone","cellular")
day: last contact day of the month (numeric)
month: last contact month of year (categorical: "jan", "feb", "mar", ...,
"nov", "dec")
duration: last contact duration, in seconds (numeric) # other attributes:
campaign: number of contacts performed during this campaign and for this
client (numeric, includes last contact)
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)
previous: number of contacts performed before this campaign and for this
client (numeric)
poutcome: outcome of the previous marketing campaign (categorical:
"unknown","other","failure","success") #Output variable (desired target):
y - has the client subscribed a term deposit? (binary: "yes","no")
My problem is that i can't decide which columns to use to make a cube .
Any help ?

No comments:

Post a Comment