Chapter 4 ADAS Exercise 4.xlsx

Difficulty: Level 2

When conducting a data analytics project, key decisions with respect to how the project is designed and how data is analyzed are guided by the Data Analytics Model. The purpose of this exercise is to review the Data Analytics Model using the Cost Analytics exercise. Complete the Cost Analytics exercise before starting this exercise. Place your answers to the following questions in the Chapter 4 ADAS Exercise 4 workbook.

1. Define each component of the DATA Analytics Framework.
2. Assess the data design elements of the Chapter 4 DA Exercise 2 workbook. Identify two design traits and explain how these traits align with your assessment of the DATA Analytics Framework.
3. Identify the data audits that were used in the project. Include the Excel features, formulas, or functions that were used to conduct these audits.
4. Explain how a data internal control was added to this project. Include in your explanation why this control was needed and what Excel features, formulas, or functions were used.

Cost Analytics exercise:

Hotel Occupancy and Cleaning Costs Hotel Occupancy and Cleaning Costs