DAT 390 Education Specialist |tutorialrank.com

1
DAT 390 All Assignments For more course
tutorials visit
www.tutorialrank.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
2
DAT 390 Week 5 U.S. Student Aid Data
Debrief ........................................
..................................................
........................... ......................
................... DAT 390 Week 1 Apply U.S.
Student Aid Initial Database Schema For more
course tutorials visit
www.tutorialrank.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

4

• 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.
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
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 For more course tutorials visit
www.tutorialrank.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
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 this school?

Revise the schema you submitted in Week 1 per
your instructors 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

7

• 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 MicrosoftWord
  document that
• Describe your SQL, populated tables, and the best
  practices you used to develop your SQL queries

8

• 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 Week
3 Apply U.S. Student Aid Data Warehouse
Development For more course tutorials visit
www.tutorialrank.com
DAT 390 Week 3 ApplyU.S. Student Aid Data
Warehouse Development
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 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 instructors feedback.
• Specific integration plans

Document your plan as either
10

• 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. ..........................
..................................................
......................................... ........
.................................
11
DAT 390 Week 4 Apply U.S. Student Aid Data
Warehouse Evaluation For more course tutorials
visit
www.tutorialrank.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.
Create a summary for your project sponsors to
inform them of the quality of data they can
expect from the new data warehouse.
12

• 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

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 weekly
assignments.
Submit your assignment. ..........................
..................................................
......................................... ........
................................. DAT 390 Week
5 U.S. Student Aid Data Debrief For more course
tutorials visit
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 project questions.
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 instructor
feedback. Document the following for the
project sponsors 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
15
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