1 / 12

DAT 390 Success Begins / snaptutorial.com

DAT 390 Week 1 Apply U.S. Student Aid Initial Database Schema<br><br> <br><br>DAT 390 Week 2 Apply U.S. Student Aid Initial Database Schema and Query Rec<br>

Richhard45
Download Presentation

DAT 390 Success Begins / snaptutorial.com

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DAT 390 All Assignments For more classes visit www.snaptutorial.com 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

  2. ************************************************ DAT 390 Week 1 Apply U.S. Student Aid Initial Database Schema For more classes visit www.snaptutorial.com 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? •

  3. 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 •

  4. 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 Week 2 Apply U.S. Student Aid Initial Database Schema and Query Recommendations

  5. For more classes visit www.snaptutorial.com 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. •

  6. 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.

  7. ************************************************ DAT 390 Week 3 Apply U.S. Student Aid Data Warehouse Development For more classes visit www.snaptutorial.com DAT 390 Week 3 ApplyU.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.

  8. 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.

  9. ************************************************ DAT 390 Week 4 Apply U.S. Student Aid Data Warehouse Evaluation For more classes visit www.snaptutorial.com DAT 390 Week 4 Apply U.S. Student Aid Data Warehouse Evaluation 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.

  10. 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-page Microsoft® Word document 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. Submit your assignment.

  11. ************************************************ DAT 390 Week 5 U.S. Student Aid Data Debrief For more classes visit www.snaptutorial.com The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices you used to develop the database and the reporting tools used to answer the project questions. Refer to the U.S. Student Aid Data assignments you completed throughout this course to prepare your debrief report. Previous assignments may need to be revised with instructor feedback. Document the following for the project sponsors:

  12. An explanation of the schema selected to develop the database, including: A summary of any schema discrepancies you found and how you resolved them The process and considerations you used to select the best schema for the database The strategy you used to optimize and incorporate best practices into the SQL used to develop the databases, including strengths and weaknesses of the techniques you used The strategy used to transform from one schema to another The challenges encountered while preparing the data for analysis The strategy used to clean the data The tools you selected for integrating various database elements, including the strengths and weaknesses of these tools Screenshots, diagrams, and other images as needed to support your summary Practices you will replicate or avoid in similar projects based on your experiences with this project Present your summary as either: A 10- to 12-slide Microsoft® PowerPoint® presentation with detailed speaker notes A 3- to 4-page Microsoft® Word document ************************************************

More Related