Accounting Question

Overview

1. 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 each individual in the table has held a full-time job), what would be the effect of the following?
   • Transforming null and n/a values into blanks
   • Transforming null and n/a values into zeroes
   • Deleting records that have null and n/a values from your dataset
   (Hint: Think about the impact on different aggregate functions, such as COUNT and AVERAGE.)
2. Chapter 2 - What is the theme of each of the six questions proposed by the Institute of Business Ethics? Which one addresses the purpose of the data? Which questions address how the risks associated with data use and collection are mitigated? How could these two specific objectives be achieved at the same time?
3. Why is it better to extract data from a data warehouse than a production or live system directly?
4. Would an auditor view heterogeneous systems as an audit risk? Why or why not?