Required When you are finished loading the data, you should answer these simple questions to make sure you loaded the data correctly (by testing for completeress 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 tervices Technology 5. What company had the most sales over the three-year period and what was the total amount of those sales? 2 Realize for many situations, extracting, transforming, and loading (ETL) the data can account for over 80 percent of the time in the entire data analysis process. This case simplifies this process so you can focus on developing other aspects of an analytics mindset. Also, the process does not always strictly follow the ETL format. Some transfomation can happen before or after data is loaded into a tool for analysis. Used with permission (1) 2016 Ernst \& Young Foundation (US). Required When you are finished loading the data, you should answer these simple questions to make sure you loaded the data correctly (by testing for completeress 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 tervices Technology 5. What company had the most sales over the three-year period and what was the total amount of those sales? 2 Realize for many situations, extracting, transforming, and loading (ETL) the data can account for over 80 percent of the time in the entire data analysis process. This case simplifies this process so you can focus on developing other aspects of an analytics mindset. Also, the process does not always strictly follow the ETL format. Some transfomation can happen before or after data is loaded into a tool for analysis. Used with permission (1) 2016 Ernst \& Young Foundation (US)