1 / 15

DAT 390 Education Specialist |tutorialrank.com

DAT 390 Education Specialist |tutorialrank.com

sumathi23
Download Presentation

DAT 390 Education Specialist |tutorialrank.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 AllAssignments For more course tutorials visit www.tutorialrank.com DAT 390 Week 1 Apply U.S. Student Aid Initial DatabaseSchema DAT 390 Week 2 Apply U.S. Student Aid Initial Database Schema and QueryRecommendations DAT 390 Week 3 Apply U.S. Student Aid Data Warehouse Development DAT 390 Week 4 Apply U.S. Student Aid Data WarehouseEvaluation

  2. DAT 390 Week 5 U.S. Student Aid DataDebrief ..................................................................................................................... ......................................... DAT 390 Week 1 Apply U.S. Student Aid InitialDatabase Schema For more course tutorialsvisit www.tutorialrank.com • DAT 390 Week 1 Apply U.S. Student Aid Initial DatabaseSchema • You are assigned a project to evaluate higher education student aid data from the U.S. government to answer the followingquestions: • 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 thisschool?

  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 discrepancyrecommendation. • Download the following spreadsheets or CSVfiles: • School Code List (this link is not working for some reason but luckily I have this file from a recent previousclass): 2021FedSchoolCodeList.xlsx • Most current spreadsheets for Loan Volume, Grant Volume, and Campus-BasedVolume

  4. Gainful EmploymentInformation • 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 datasources Summarize your recommendations for resolving anticipated discrepancies and identify which strategy you would use to validate the data quality in a Microsoft® Worddocument.

  5. Note: You will use the downloaded files and your drafted schema in the Week 2 individual assignment, U.S. Student Aid Database Schema and QueryRecommendations. Submit your Microsoft® Visio® file and Word®file. ..................................................................................................................... ......................................... DAT 390 Week 2 Apply U.S. Student Aid InitialDatabase Schema and QueryRecommendations For more course tutorialsvisit www.tutorialrank.com DAT 390 Week 2 Apply U.S. Student Aid Initial Database Schema and QueryRecommendations 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 followingquestions:

  6. 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 thisschool? Revise the schema you submitted in Week 1 per your instructor’s feedback. • Test your schema by completing the followingtasks: • 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:

  7. Define an appropriate strategy to optimize and incorporate best practices in to the SQL that youcreated. • Document your SQL and metadata in Microsoft® Visio® or Microsoft®Excel®. • Capture screenshots of each queryresult. Note: You may "mock" up the SQL statement and query results if you do not want to download adatabase. • Document your results as a 1-page Microsoft®Word documentthat: • Describe your SQL, populated tables, and the best practices you used to develop your SQLqueries

  8. Include the SQL statements and corresponding screenshots of each queryresult Compress your revised diagram(s), testing results documentation,and .SQL files into a ZIPfolder. Submit yourassignment. ..................................................................................................................... ......................................... DAT 390 Week 3 Apply U.S. Student AidData Warehouse Development For more course tutorialsvisit www.tutorialrank.com DAT 390 Week 3 ApplyU.S. Student Aid Data WarehouseDevelopment

  9. 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 forreporting. • Develop a plan to integrate this new data warehouse with an internet application. Include in yourplan: • A description of the transformationprocess • A schema diagram identifying the changesneeded • Revise the diagram you submitted in Week 2 per your instructor’s feedback. • Specific integrationplans Document your plan aseither:

  10. A 1- to 2-page Microsoft® Worddocument • A 6- to 7-slide Microsoft® PowerPoint® presentationwith detailed speakernotes 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 weeklyassignments. Compress your revised diagram and your plan into a ZIPfolder. Submit yourassignment. ..................................................................................................................... .........................................

  11. DAT 390 Week 4 Apply U.S. Student AidData Warehouse Evaluation For more course tutorialsvisit www.tutorialrank.com DAT 390 Week 4 Apply U.S. Student Aid Data WarehouseEvaluation 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 projectsponsors. Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the ability to provide consistent querydata. Create a summary for your project sponsors to inform them of the quality of data they can expect from the new datawarehouse.

  12. Include the following information in your summary: • Your data evaluationstrategy • Specific data evaluationqueries • Sample results perquery • Summary offindings • Document your summary aseither: • A 10-slide Microsoft® PowerPoint® presentation with detailed speaker notes • A 2-page Microsoft® Worddocument

  13. 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 weeklyassignments. Submit yourassignment. ..................................................................................................................... ......................................... DAT 390 Week 5 U.S. Student Aid DataDebrief For more course tutorialsvisit www.tutorialrank.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 projectquestions.

  14. 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 instructorfeedback. Document the following for the projectsponsors: An explanation of the schema selected to develop the database, including: A summary of any schema discrepancies you found and how you resolvedthem The process and considerations you used to select the best schema for thedatabase 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 thedata 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

  15. Present your summary aseither: A 10- to 12-slide Microsoft® PowerPoint® presentation with detailed speaker notes A 3- to 4-page Microsoft® Worddocument

More Related