DAT 300 Project Two Gap Analysis

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

300

Subject

Electrical Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

5

Uploaded by JusticeMetalRabbit26

Report
DAT 300 Project Two Template REFERENCE NO. ITEM 1. Extract Data Dataset from KC Motors 2. Transform the Data Dataset from KC Motors 3. Load the Data Dataset from KC Motors 4. Outline process for future data integration Dataset from KC Motors
e: Gap Analysis CURRENT STATE Data is stored in a Database that is incompatible with National Motors Databse The Data received from KC Motors is incomplete/improperly formatted for import Data is stored in KC Motors Database Data is loaded into KC Motors defunct database
DESIRED STATE Ability to extract data that can be used and transformed Have data that is complete and properly formatted for the integration with National Motors Add the legacy KC data to National Motors Database Newly obtained data from KC Motors should be directly loaded into the National Motors database
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
Analyst Analyst Analyst Analyst 2 ASSIGNED TO
ACTION ITEMS Extract the data from the KC Motors database and load into Excel or equivalent spreadsheet software 1. Review the KC Motors data set in Excel (or equivalent) to obtain missing values, address error values 2. Obtain missing values 3. Address error values 4. Add unique identifiers for data points 5. Update data formatting to match target database After transforming dataset as outlined above, import the KC Motors dataset into the National Motors database Data from KC Motors should be regularly imported to the National Motors database, and not loaded into the AS400 database previously used by KC Motors.

Related Documents

EET-117_LAB 5 23W.docx
EET-117 LAB 6 F21.docx
ELEC 2501 LAB 2.docx
BIO208LW Lab Report 2 Urinalysis - Writing Guideline and Rubic (8).docx
Lab 7.pdf
Lab 5.pdf
Week #9 Assignment.docx
CAM.docx
Integrated Gradients.docx
Testing CNN.docx
Physics Lesson 10 Problem Set 4.docx
Physics Lesson 10 Problem Set.docx
Recommended textbooks for you
Text book image
Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning
Text book image
EBK ELECTRICAL WIRING RESIDENTIAL
Electrical Engineering
ISBN:9781337516549
Author:Simmons
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Electricity for Refrigeration, Heating, and Air C...
Mechanical Engineering
ISBN:9781337399128
Author:Russell E. Smith
Publisher:Cengage Learning
Text book image
Electric Motor Control
Electrical Engineering
ISBN:9781133702818
Author:Herman
Publisher:CENGAGE L
Text book image
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:9781337900348
Author:Stephen L. Herman
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning
Text book image
EBK ELECTRICAL WIRING RESIDENTIAL
Electrical Engineering
ISBN:9781337516549
Author:Simmons
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Electricity for Refrigeration, Heating, and Air C...
Mechanical Engineering
ISBN:9781337399128
Author:Russell E. Smith
Publisher:Cengage Learning
Text book image
Electric Motor Control
Electrical Engineering
ISBN:9781133702818
Author:Herman
Publisher:CENGAGE L
Text book image
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:9781337900348
Author:Stephen L. Herman
Publisher:Cengage Learning
SEE MORE TEXTBOOKS