1. Describe "active" data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is normally described? An active data warehousing‚ or ADW‚ is a data warehouse implementation that supports near-time or near-real-time decision making. It is featured by event-driven actions that are triggered by a continuous stream of queries that are generated by people or applications regarding an organization or company against
Premium Airline Southwest Airlines Avianca
Real Time Business Intelligence at Continental Airlines 1. Describe “active” data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is Normally described? Explain your answer. Answer: as shown in the case Continental senior management decided to invest in enterprise data warehouse that all employees could use for quick access to key information about the business and its customers. The data warehouse initial
Premium Data warehouse Data management Customer relationship management
Data Warehousing‚ Data Marts and Data Mining Data Marts A data mart is a subset of an organizational data store‚ usually oriented to a specific purpose or major data subject‚ that may be distributed to support business needs. Data marts are analytical data stores designed to focus on specific business functions for a specific community within an organization. Data marts are often derived from subsets of data in a data warehouse‚ though in the bottom-up data warehouse design methodology the data
Premium Data mining Data warehouse
Case Study > Data Warehousing Continental Airlines I. Executive Summary Table of Contents I II III IV V Executive Summary The Decision to Invest Implementation New Business Strategies ROI 2 4 6 9 19 20 Technical Appendix A Continental’s comeback from “Worst to First” is an airline industry legend. Now the company is engaged in a new initiative to move from “First to Favorite.” To support this ambitious initiative‚ Continental tapped into its Enterprise Data Warehouse and expanded it
Premium Customer relationship management Customer service Airline
Continental airlines case The biggest challenge that the continental Airlines is grappling with is with regards to their operational efficiency. Their previous decision of oursourcing key functions like reservations‚ payroll and EDS were causing a delay in flow of information thus hindering data based decision making in the company. Most decision thus were being made not by what data said but by the “hunch” or “intuition” which often proved wrong. Lack of real time data‚ complex system of booking
Premium Business intelligence Airline Data management
definition of Data Warehousing. Bill Inmon advocates a top-down development approach that adapts traditional relational database tools to the development needs of an enterprise wide data warehouse. From this enterprise wide data store‚ individual departmental databases are developed to serve most decision support needs. Ralph Kimball‚ on the other hand‚ suggests a bottom-up approach that uses dimensional modeling‚ a data modeling approach unique to data warehousing. Rather than building a single
Premium Data warehouse
Data warehousing is the process of collecting data in raw form for analyzing trends. The benefits to data warehousing are improved end-user access‚ increased data consistency‚ various kinds of reports can be made from the data collected‚ gather the data in a common place from separate sources and additional documentation of data. Potential lower computing costs‚ increased productivity‚ end-users can query the database without using overhead of the operational systems and creates an infrastructure
Premium Data warehouse Data mining Database management system
20 March 2013 Continental Airlines Takes Off with Real-time Business Intelligence * Describe “active” data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is normally described? Continental was in the beginning a disaster in doing business before Real-time IB; late flights‚ bad baggage handling and its lost‚ complaining customers because of delays‚ overbooking‚ lost of booking data etc and even unhappy
Premium Data warehouse Data mining Business intelligence
Continental Airlines Memo To: Lawrence Kellner From: Date: Re: The purpose of this memorandum is to address the profitability issues at Continental Airlines and to estimate the costs for 2009 to forecast the future outlook of the company. To address these issues‚ I used regression analysis to observe what effect the 11% reduction in flying capacity would have on the firm’s future operating costs. I also used the results from the regression analysis to verify the costs that‚ if reduced
Premium Costs Aircraft Airline
case case Continental Airlines: One Company’s Flight to Success In the last decade‚ Continental Airlines has had a spotty track record. The airline twice filed for bankruptcy‚ realized diminished performance culminating in a $613 million loss in 1994‚ and was ranked dead last in industry indicators such as on-time performance among the major carriers. During these years‚ employees at Continental had undergone several series of layoffs and withstood both wage cuts and delayed wage increases in
Premium Airline Continental Airlines Northwest Airlines