Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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

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).

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),

Step by Step Solution

3.42 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students explore these related Accounting questions