A screen shot of this comma-separated file is shown below.

Review this Source Data extract above and identify any issues with the raw data. (As needed, refer back to the ETL Overview document to help you identify issues.)

-  There are several issues that are problematic with this extract which need to be addressed. You will address these when you perform the steps below.

-  Note: you do not need to verify the validity of the amounts (e.g., American Airlines Group Inc. did in fact report cash of 2750000000 for 2018).

Transcribed Image Text:

Ticker,Name, Year, Cash, Accounts Receivables, Inventories, Total Current Assets, Total Depreciation, AAL, American Airlines Group Inc.,2016,3220000000,"1,600,000,000",1094000000,10300,(14200000000), AAL, American Airlines Group Inc.,2017,2950000000,"1,800,000,000",1359000000,9100,(15600000000), AAL, American Airlines Group Inc.,2018,2750000000,"1,700,000,000",1522000000,8600,(17400000000), AAPL,"Apple, Inc.",2016,20500 M,"15,800,000,000",2100000000,106900,-34200000000 AAPL,"Apple, Inc.",2017,20300 M,"17,900,000,000",4900000000,128600,-41300000000 AAPL,"Apple, Inc.",2018,25900 M, "23,200,000,000",4000000000,131300,-49100000000 ACY, Aerocentury Corp.,2016,2200000,4000000,0,6,-23000000, Corp.,2017,8700000,3800000,-,12,-14600000, ACY, Aerocentury Corp.,2018,1500000,4000000,0,5,-14700000, AEHR,Aehr Test Systems,2016,900 AEHR, Aehr Test Systems,2017,17800 AEHR,Aehr Test Systems,2018,16800 ACY, Aerocentury К,"500,000",7000000,9,-5700000, K,"4,000,000",6600000,29,-600өөөө, K,"2,900,000",9000000,29,-6400000, AHH, Armada Hoffler Properties Inc.,2016,21900000,"15,100,000",,0,-1396000 е, AHH,Armada Hoffler Properties Inc.,2017,19900000,"15,700,000", ,0,-164500өөө, AHH,Armada Hoffler Properties Inc.,2018,21300000, "19,100,0ее", ,0, -1888000 е, AMZN,Amazon.com Inc.,2016,19330000000,8340000000,11500000000,45780,-1333000000е, A M Z N,Amazon.com Inc.,2017,31750000000,16680000000,17170000000,162650,-33970000000, AM ZN, Amazon.com Inc.,2018,20520000000,13160000000,16050000000,60200,-23790000000, APVO, Aptevo Therapeutics Inc.,2016,9700 К,4300000,6600000,71,(6600000), APVO, Aptevo Therapeutics Inc.,2017,7100 K,2100000,1000000,95, (7500000), APVO, Aptevo Therapeutics Inc.,2018,30600 К,5200000,1800000,49,(8700000), APVO, Aptevo Therapeutics Inc.,2018,30600 К,5200000,1800000,49,(8700000), Ticker,Name, Year, Cash, Accounts Receivables, Inventories, Total Current Assets, Total Depreciation, AAL, American Airlines Group Inc.,2016,3220000000,"1,600,000,000",1094000000,10300,(14200000000), AAL, American Airlines Group Inc.,2017,2950000000,"1,800,000,000",1359000000,9100,(15600000000), AAL, American Airlines Group Inc.,2018,2750000000,"1,700,000,000",1522000000,8600,(17400000000), AAPL,"Apple, Inc.",2016,20500 M,"15,800,000,000",2100000000,106900,-34200000000 AAPL,"Apple, Inc.",2017,20300 M,"17,900,000,000",4900000000,128600,-41300000000 AAPL,"Apple, Inc.",2018,25900 M, "23,200,000,000",4000000000,131300,-49100000000 ACY, Aerocentury Corp.,2016,2200000,4000000,0,6,-23000000, Corp.,2017,8700000,3800000,-,12,-14600000, ACY, Aerocentury Corp.,2018,1500000,4000000,0,5,-14700000, AEHR,Aehr Test Systems,2016,900 AEHR, Aehr Test Systems,2017,17800 AEHR,Aehr Test Systems,2018,16800 ACY, Aerocentury К,"500,000",7000000,9,-5700000, K,"4,000,000",6600000,29,-600өөөө, K,"2,900,000",9000000,29,-6400000, AHH, Armada Hoffler Properties Inc.,2016,21900000,"15,100,000",,0,-1396000 е, AHH,Armada Hoffler Properties Inc.,2017,19900000,"15,700,000", ,0,-164500өөө, AHH,Armada Hoffler Properties Inc.,2018,21300000, "19,100,0ее", ,0, -1888000 е, AMZN,Amazon.com Inc.,2016,19330000000,8340000000,11500000000,45780,-1333000000е, A M Z N,Amazon.com Inc.,2017,31750000000,16680000000,17170000000,162650,-33970000000, AM ZN, Amazon.com Inc.,2018,20520000000,13160000000,16050000000,60200,-23790000000, APVO, Aptevo Therapeutics Inc.,2016,9700 К,4300000,6600000,71,(6600000), APVO, Aptevo Therapeutics Inc.,2017,7100 K,2100000,1000000,95, (7500000), APVO, Aptevo Therapeutics Inc.,2018,30600 К,5200000,1800000,49,(8700000), APVO, Aptevo Therapeutics Inc.,2018,30600 К,5200000,1800000,49,(8700000),

Answer rating: 100% (QA)

Answer 1 The raw data extract has several issues that need to be addressed Firstly the data is not consistent in terms of formatting For instance some ... View the full answer