Questions from Analytics

Q: The advantages of a relational database include integrating business processes. Why

The advantages of a relational database include integrating business processes. Why is it preferable to integrate business processes in one information system, rather than store different business pro...

Q: In the ETL process, one important step to process when transforming

In the ETL process, one important step to process when transforming the data is to work with NULL, N/A, and zero values in the dataset. If you have a field of quantitative data (e.g., number of years...

Q: Among the advantages of using a relational database is enforcing business rules

Among the advantages of using a relational database is enforcing business rules. Based on your understanding of how the structure of a relational database helps prevent data redundancy and other advan...

Q: What is the purpose of a data dictionary? Identify four different

What is the purpose of a data dictionary? Identify four different attributes that could be stored in a data dictionary, and describe the purpose of each.

Q: Compare and contrast the profiling data approach and the development of standard

Compare and contrast the profiling data approach and the development of standard cost for a unit of production at a manufacturing company? Are they substantially the same or do they have differences?...

Q: Figures 3-1 through 3-4 suggest that volume and

Figures 3-1 through 3-4 suggest that volume and distance are the best predictors of “days to ship” for a wholesale company? Any other variables that would also be useful in predicting the number of “d...

Q: What is the difference between a supervised and an unsupervised approach?

What is the difference between a supervised and an unsupervised approach?

Q: The advantages of a relational database include limiting the amount of redundant

The advantages of a relational database include limiting the amount of redundant data that are stored in a database. Why is this an important advantage? What can go wrong when redundant data are store...

Q: What is the difference between training data sets and test (or

What is the difference between training data sets and test (or testing) data sets?

Q: How might the data reduction approach be used in auditing?

How might the data reduction approach be used in auditing?