DAT 390 DAT390 DAT/390 ENTIRE COURSE HELP – UNIVERSITY OF PHOENIX

Description

DAT 390 DAT390 DAT/390 ENTIRE COURSE HELP – UNIVERSITY OF PHOENIX

DAT 390 Week 1 Apply U.S. Student Aid Initial Database Schema

DAT 390 Week 2 Apply U.S. Student Aid Initial Database Schema and Query Recommendations

DAT 390 Week 3 Apply U.S. Student Aid Data Warehouse Development

DAT 390 Week 4 Apply U.S. Student Aid Data Warehouse Evaluation

DAT 390 Week 5 U.S. Student Aid Data Debrief

DAT 390 DAT390 DAT/390 ENTIRE COURSE HELP – UNIVERSITY OF PHOENIX

DAT 390 Week 1 Apply U.S. Student Aid Initial Database Schema

You are assigned a project to evaluate higher education student aid data from the U.S. government to answer the following questions:

•           Which schools generate the highest amount of debt for the average student who attends?

•           What is the employment rate for the students who graduate from this school?

You will complete this cumulative project throughout the course This week, you will complete an initial review of the data and prepare an initial database schema and data discrepancy recommendation.

Download the following spreadsheets or CSV files:

•           School Code List (this link is not working for some reason but luckily I have this file from a recent previous class):

2021FedSchoolCodeList.xlsx

•           Most current spreadsheets for Loan Volume, Grant Volume, and Campus-Based Volume

•           Gainful Employment Information

Develop a database schema diagram based on the data tables you downloaded. Use Microsoft® Visio® to display your diagram. Your diagram should include:

•           The identification of metadata that needs to be included in each table

•           Annotation of the diagram to identify where there may be schematic discrepancies between the data sources

Summarize your recommendations for resolving anticipated discrepancies and identify which strategy you would use to validate the data quality in a Microsoft® Word document.

Note: You will use the downloaded files and your drafted schema in the Week 2 individual assignment, U.S. Student Aid Database Schema and Query Recommendations.

Submit your Microsoft® Visio® file and Word® file.

DAT 390 DAT390 DAT/390 ENTIRE COURSE HELP – UNIVERSITY OF PHOENIX

DAT 390 Week 2 Apply U.S. Student Aid Initial Database Schema and Query Recommendations

This week you will continue your work on the project to evaluate higher education student aid data. You will test your recommended U.S. Student Aid database schema, build the database, and develop the business intelligence queries that will enable you to answer the following questions:

•           Which schools generate the highest amount of debt for the average student who attends?

•           What is the employment rate for the students who graduate from this school?

Revise the schema you submitted in Week 1 per your instructor’s feedback.

Test your schema by completing the following tasks:

•           Define the database tables you will need and group the tables by function. Document your tables in an annotated Microsoft® Visio® diagram.

•           Develop the SQL queries needed and populate the tables from the data downloaded for your Week 1 assignment. Your assignment should:

•           Define an appropriate strategy to optimize and incorporate best practices in to the SQL that you created.

•           Document your SQL and metadata in Microsoft® Visio® or Microsoft® Excel®.

•           Capture screenshots of each query result.

Note: You may “mock” up the SQL statement and query results if you do not want to download a database.

Document your results as a 1-page Microsoft®Word document that:

•           Describe your SQL, populated tables, and the best practices you used to develop your SQL queries

•           Include the SQL statements and corresponding screenshots of each query result

Compress your revised diagram(s), testing results documentation, and .SQL files into a ZIP folder.

Submit your assignment.

DAT 390 DAT390 DAT/390 ENTIRE COURSE HELP – UNIVERSITY OF PHOENIX

DAT 390 Week 3 Apply U.S. Student Aid Data Warehouse Development

This week you will continue your work on the project to evaluate higher education student aid data. You will transform your operational data structure and schema into a data structure and schema for a data warehouse, which will be exclusively used for reporting.

Develop a plan to integrate this new data warehouse with an internet application. Include in your plan:

•           A description of the transformation process

•           A schema diagram identifying the changes needed

•           Revise the diagram you submitted in Week 2 per your instructor’s feedback.

•            Specific integration plans

Document your plan as either:

•           A 1- to 2-page Microsoft® Word document

•           A 6- to 7-slide Microsoft® PowerPoint® presentation with detailed speaker notes

Note: It is recommended that you select the delivery method of a Microsoft® PowerPoint® presentation or a Microsoft® Word document to use consistently throughout your weekly assignments.

Compress your revised diagram and your plan into a ZIP folder.

Submit your assignment.