Case Study Overview The airline industry is impacted by changes in its external environment from political, economic, social, technological, environmental, and legal factors. These aren't controlled directly by the companies in the industry, but the companies nevertheless might be forced to alter their business models, pricing, revenue, and cost structures, etc. in response to changing conditions. Knowledge of external environmental trends can help predict opportunities and risks. Knowledge of ratio analysis can help assess what is working in a company's strategy to adapt to changing conditions. In this case study, we will look at the financial statements of a couple of different major players in the airline industry, as well as international routes companies are flying out of the U.S. The focus will be on knowledge of PowerBi, practice with PowerBi functions and creating visualization. Case Study Resources DATA OVERIEW There are two data sources for this project that are included as resources: Delta_Airlines_Financial_Statements.xlex Departures_fy_2015_and_2016_Student.xlex The financial statements for Delta Airlines were obtained from the U.S. Securities and Exchange Commission through the Electronic Data Gathering, Analysis, and Retrieval system (EDGAR). Since 1934, the SEC has required disclosure in forms and documents. In 1984, EDGAR began collecting electronic documents to help investors get information that can be downloaded. Financial statements for publicly traded companies are available through the site: http:://www.sec.gowedgar/searchedgar/companysearch html. The Departures data set includes information provided by the U.S. Department of Transportation to the public concerning international aviation: http: //www.transportation.gow policy/aviation-policy/us- international-air-passenger-and-freight-statistics-report. U.S. International Air Passenger and Freight data is confidential for a period of six months, after which it can be released. The data provided includes nonstop commercial traffic traveling between U.S. airports and international cities. (Caveat: Note that global air travel systems are comprised of complex, ever