Reference no: EM133246011

This task defines a report as a collection of data that answers a real-world business question. The report contains two distinct sections that differ in the granularity of the data they present and how directly they support the answering of the business question of interest. The Detailed section will contain all data that informs the answers to the question, and the Summary section will include contains relevant aggregated data that provide the answer to the business question. For example, if the business question of interest in the context of a computer factory is focused on the number of the computers manufactured in the past six months, the detailed portion of a report could contain details on each individual computer made, while the summary portion contains only the total number of computers made in each factory.

A. Summarize one real-world business report that can be created from the attached Data Sets and Associated Dictionaries.

1. Describe the data used for the report.

2. Identify two or more specific tables from the given dataset that will provide the data necessary for the detailed and the summary sections of the report.

3. Identify the specific fields that will be included in the detailed and the summary sections of the report.

4. Identify one field in the detailed section that will require a custom transformation and explain why it should be transformed. For example, you might translate a field with a value of 'N' to 'No' and 'Y' to 'Yes'.

5. Explain the different business uses of the detailed and the summary sections of the report.

6. Explain how frequently your report should be refreshed to remain relevant to stakeholders.