WPC 300 FINAL TEST PAPER QUESTIONS
AND SOLUTIONS EXPERT VERIFIED STUDY
CONTENT
●● Analytic
Answer: Learns by analyzing, uses step by step procedure, values
quantitative and models, builds mathematical models, seeks optimal
solution
●● Data extraction
Answer: Extract data from primary/secondary source
●● Data transformation
Answer: Transform/clean data into proper format or structure for the
purpose of querying and analysis
●● Data load
Answer: Load data into final target database, more specifically as
operational data store, data mart or data warehouse
●● Descriptive Modeling
Answer: Basic plots of variables
Find patterns in data
, Descriptive statistics
Correlations
Outliers
Sampling
Some data mining techniques - clustering
●● Explanatory modeling
Answer: Develop model to understand a (causal) relationship
●● Predictive analysis
Answer: Linear regression
Data mining
Classification
Decision tree
Association rule (market basket analysis)
Text mining
Simulation
●● Problem Framing
Answer: Tell an interesting and complete story, find an appropriate
solution framework, routinize the procedure
AND SOLUTIONS EXPERT VERIFIED STUDY
CONTENT
●● Analytic
Answer: Learns by analyzing, uses step by step procedure, values
quantitative and models, builds mathematical models, seeks optimal
solution
●● Data extraction
Answer: Extract data from primary/secondary source
●● Data transformation
Answer: Transform/clean data into proper format or structure for the
purpose of querying and analysis
●● Data load
Answer: Load data into final target database, more specifically as
operational data store, data mart or data warehouse
●● Descriptive Modeling
Answer: Basic plots of variables
Find patterns in data
, Descriptive statistics
Correlations
Outliers
Sampling
Some data mining techniques - clustering
●● Explanatory modeling
Answer: Develop model to understand a (causal) relationship
●● Predictive analysis
Answer: Linear regression
Data mining
Classification
Decision tree
Association rule (market basket analysis)
Text mining
Simulation
●● Problem Framing
Answer: Tell an interesting and complete story, find an appropriate
solution framework, routinize the procedure