Reference no: EM132525103

This assignment contains two (2) sections: Written Report and PowerPoint Presentation. You must submit both sections for the completion of this assignment.

Section 1: Written Report

Imagine that the CIO comes to you with a frustrated look on his face. He has realized that metadata is a key foundational piece of a data warehouse. He asks you to write a report that emphasis the importance of metadata, the types of metadata, and the impact of metadata on the ETL process. He shows you an article that states that faulty metadata will lead to poor information from the data warehouse. The executive team is eager to move forward but the risk of faulty metadata is making the CIO apprehensive. He reiterates that the report will be used to explain metadata to the company's management team. He reminds you that the team comprises of technical and nontechnical stakeholders. In your report, you must show why metadata is a major building block for a data warehouse and how it impacts ETL.

1. List and explain three (3) differences between data dictionaries used in database management systems and metadata that is used in data warehousing.

2. Identify three (3) primary reasons why metadata are important in a data warehouse.

3. List three (3) significant differences between business and technical metadata. Explain why each difference is relevant.

4. Identify and explain three (3) significant points that show the impact of metadata on the ETL process. Be sure to state where in the ETL process the impact would occur. 

5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Section 2: PowerPoint Presentation

In addition to the report, the CIO asks you to create a PowerPoint that can be used to illustrate the concepts from your report to the company's management team.

Create a ten (10) slide PowerPoint presentation in which you:

6. Illustrate the concepts from your written report in Section 1 of this assignment.

7. Create bulleted speaking notes for the CIO's reference in the notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.

8. Use a professional style to graphically convey the information.

The specific course learning outcomes associated with this assignment are:

Describe the significance, use, and types of meta-data and meta-modeling.

Use technology and information resources to research issues in data warehousing.

Write clearly and concisely about topics related to data warehouse planning using proper writing mechanics and technical style conventions.