100% GRADE - DAT 300 - PROJECT 2 EXCEL FILE

DAT 300 Project Two Template: Gap Analysis

REFERENCE NO. ITEM CURRENT STATE
Two datasets from different sources and an
1 Prepare data Databases are incompatible
additional Word document from Kansas City.
2 Databases Warehouse
Formats in 2uses a Microsoft
datasets SQL server
are incompatible
3 Format Kansas City uses AS400 database
Warehouse uses numeric, and Kansas City uses
Kansas City reports the number of motors sold,
4 Data value scientific format.
while National
Kansas Motors
City dataset has reports
a missing thedata
inventory
on line
5 Missing data
3. And
Kansas City late entry
dataset hasforthree
the 28th
errorsmonth
on line 8,
6 Error Kansas City data has rounding issues due to
18, 25
7 Rounding issues Datausing the28th
of the scientific
monthformat in the
of Kansas AS400
City dataset
8 Possible false data database
might be an error because of it's extremely low
9 Merge two datasets Twonumber
datasetsof are
motors
storedsold (286)
seperately