Week 4 – u.s. student aid data warehouse evaluation | DAT390 Database Integration With Other Systems…

This week you will continue your work on the project to evaluate higher education student aid data. You will evaluate your data warehouse data to ensure it can provide consistent, accurate query data, and provide an update to the project sponsors.

Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the ability to provide consistent query data.

Create a summary for your project sponsors to inform them of the quality of data they can expect from the new data warehouse.

Include the following information in your summary:

• Your data evaluation strategy
• Specific data evaluation queries
• Sample results per query
• Summary of findings

Document your summary as either:

• A 10-slide Microsoft® PowerPoint® presentation with detailed speaker notes
• A 2- to 3-page Microsoft® Word document