Metadata

Click the link above to submit your assignment.

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.

Instructors, training on how to grade is within the Instructor Center.

Assignment 3: The Importance of Metadata

Due Week 4 and worth 100 points

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.

Write a three to five (3-5) page paper in which you:

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.

Your assignment must follow these formatting requirements:

This course requires use of new Strayer Writing Standards (SWS). The format is different than other Strayer University courses. Please take a moment to review the SWS documentation for details.
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow SWS or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

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.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric can be found here.