WPC 300 EXAM QUESTIONS WITH VERIFIED
ACCURATE ANSWERS
what is analytics? - Answers --Analytics is the process of developing actionable
decisions or recommendations for actions based on insights generated from historical
data
-According to the Institute for Operations Research and Management Science
(INFORMS)
-Analytics represents the combination of computer technology, management science
techniques, and statistics to solve real problems.
Agile Approach * - Answers -perform business discovery- what is the problem?
perform data discovery- find data to help us solve the problem?
prepare data- clean up data meaning format the data so we can analyze it easier
model data-
score and deploy
evaluate and improve
primary data - Answers -information that is collected for the first time. We did
everything in order to create the data
secondary data - Answers -information that already exists somewhere, having been
collected for another purpose. we did not have anything to do with creating this data
someone else created it and we are just using it.
Data Extraction - Answers -Extract/pick out data from primary/secondary source.
data transformation - Answers -transform/clean data into proper format or structure for
the purpose of querying and analysis
data load - Answers -load data into proper target database, more specifically an
operational data store, data mart or data warehouse.
ETL Process - Answers -1. then extract the data from the source
2. transform the data
3. and lastly load data into our destination.
ETL is time consuming and sometimes done in parallel. Several computation tools are
used to develop a robust ETL systems.
explanatory analytics - Answers -this is about looking into the past and determining
WHY a certain thing happened. This type of analytics usually revolves around working
on a dashboard.
Question: (1) Why did it happen? (2) How did it happen?
This is also known as Diagnostic analytics.
ACCURATE ANSWERS
what is analytics? - Answers --Analytics is the process of developing actionable
decisions or recommendations for actions based on insights generated from historical
data
-According to the Institute for Operations Research and Management Science
(INFORMS)
-Analytics represents the combination of computer technology, management science
techniques, and statistics to solve real problems.
Agile Approach * - Answers -perform business discovery- what is the problem?
perform data discovery- find data to help us solve the problem?
prepare data- clean up data meaning format the data so we can analyze it easier
model data-
score and deploy
evaluate and improve
primary data - Answers -information that is collected for the first time. We did
everything in order to create the data
secondary data - Answers -information that already exists somewhere, having been
collected for another purpose. we did not have anything to do with creating this data
someone else created it and we are just using it.
Data Extraction - Answers -Extract/pick out data from primary/secondary source.
data transformation - Answers -transform/clean data into proper format or structure for
the purpose of querying and analysis
data load - Answers -load data into proper target database, more specifically an
operational data store, data mart or data warehouse.
ETL Process - Answers -1. then extract the data from the source
2. transform the data
3. and lastly load data into our destination.
ETL is time consuming and sometimes done in parallel. Several computation tools are
used to develop a robust ETL systems.
explanatory analytics - Answers -this is about looking into the past and determining
WHY a certain thing happened. This type of analytics usually revolves around working
on a dashboard.
Question: (1) Why did it happen? (2) How did it happen?
This is also known as Diagnostic analytics.
