Analytics mindset Implementing the DuPont Mothod Part I: Extract, transform and load the data (the ETL process) The data for this case was extracted from company financial statements posted online from credible sources. The extraction of the data from the online sources was performed for you and the data has been loaded into the Excel file. That is, you can assume that the web scrapper accurately and completely extracted the information and loaded it into Excel. Most of the transformation work has been done for you as well. You will be required to do some transformation to analyze the data once it has been loaded into the appropriate analysis tool (e.g.. you will need to compute the ratios Involved in the DuPont Method). You should load the data into an analytics tool for analysiswo will be using Tableau In this case. Hint when loading the data Into Tableau, you need data from both the income statement and the balance shoot tabs. Make sure that you link the Income and balance sheet data correctly by matching the data on both ticker symbol and year. Required When you are finished loading the data, you should answer those simple questions to make sure you loaded the data correctly (by testing for completeness and accuracy). 1. What are the combined total assets of all companies for all years? 2 How many different companies are listed in the dataset? 3. How many different companies are there in each Industry Capital goods Finance Public utilities Transportation Consumer services Technology 4. What are the total sales for each Industry in 2013 (do not round your answers)? Capital goods Finance Public utilities Transportation Consumer services Technology 5. What company had the most sales over the three-year period and what was the total amount of those sales? 14 Analytics mindset Implementing the DuPont Mothod Part I: Extract, transform and load the data (the ETL process) The data for this case was extracted from company financial statements posted online from credible sources. The extraction of the data from the online sources was performed for you and the data has been loaded into the Excel file. That is, you can assume that the web scrapper accurately and completely extracted the information and loaded it into Excel. Most of the transformation work has been done for you as well. You will be required to do some transformation to analyze the data once it has been loaded into the appropriate analysis tool (e.g.. you will need to compute the ratios Involved in the DuPont Method). You should load the data into an analytics tool for analysiswo will be using Tableau In this case. Hint when loading the data Into Tableau, you need data from both the income statement and the balance shoot tabs. Make sure that you link the Income and balance sheet data correctly by matching the data on both ticker symbol and year. Required When you are finished loading the data, you should answer those simple questions to make sure you loaded the data correctly (by testing for completeness and accuracy). 1. What are the combined total assets of all companies for all years? 2 How many different companies are listed in the dataset? 3. How many different companies are there in each Industry Capital goods Finance Public utilities Transportation Consumer services Technology 4. What are the total sales for each Industry in 2013 (do not round your answers)? Capital goods Finance Public utilities Transportation Consumer services Technology 5. What company had the most sales over the three-year period and what was the total amount of those sales? 14
