Nicole Thaete DAT 300 Project Two - Gap Analysis Visualization

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

300

Subject

Electrical Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

2

Uploaded by ProfFlower9270

Report
DAT 300 Project Two Template: Gap Analysis REFERENCE NO. ITEM CURRENT STATE DESIRED STATE 1 KCM document 2 KCM spreadsheet 3 Database Format 4 Database 5 Merge KCM data and NM data 28th Month: Late entry with incorrect amount Corrected amount of motors needs to be entered Data errors and missing data in several rows Enter all corrected and missing data in the correct rows KCM data: scientific format NM data: standard format KCM data to convert to standard format Not Compatible: KCM in defunct AS400 database; NM in Microsoft SQL Compatible and Standardized: KCM to be formated to SQL format KCM data to become a part of NM data
s ACTION ITEMS Data Analyst Data Analyst Data Analyst Final gap analysis to see if all needs have been met ASSIGNED TO KCM Manager and Data Analyst Collect data from the KCM manager in charge, enter the corrected data in the 28th month KCM Manager and Data Analyst Collect the corrected and missing data from the KCM manager in charge and enter in correct rows Convert the KCM data from scientific format to standard Extract, Transform, and Load (ETL) process for KCM data in the SQL server to match the NM data
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help