Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Real time business intelligence at continental airlines

11/10/2021 Client: muhammad11 Deadline: 2 Day

Case Study 1: Continental Airlines Flies High With Its Real-Time Data Warehouse

Due Week 4 and worth 60 points
Read the End of Chapter 3 Application Case entitled, “Continental Airlines Flies High With Its Real-Time Data Warehouse,” located in the textbook.
Write a three- to four-page paper in which you:
Examine the Continental Airlines Go Forward plan and its business benefits.
Explain why it is important for an airline to use a real-time data warehouse.
Examine the major differences between the traditional data warehouse and a real-time data warehouse, as was implemented at Continental Airlines.
Identify strategic advantages that Continental Airlines can derive from the real-time system as opposed to a traditional information system and explain why.
Assess the factors that contributed to the successful implementation of the real-time data warehouse.
Propose at least two ways that Continental Airlines can enhance the established data warehouse system in the future.
Use at least three quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
This course requires use of new Strayer Writing Standards (SWS). The format is different from other Strayer University courses. Please take a moment to review the SWS documentation for details.
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow SWS or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
Describe the role of data warehouses in the context of DSS.
Develop a decision support solution to solve a proposed business problem.
Use technology and information resources to research issues in data mining.
Write clearly and concisely about Decision Support and Business Intelligence topics using proper writing mechanics and technical style conventions.
Click here to view the grading rubric.
By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution's policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.

End-of-Chapter Application Case Continental Airlines Flies High with Its Real-Time Data Warehouse As business intelligence (BI) becomes a critical component of daily operations, real-time data warehouses that provide end users with rapid updates and alerts generated from transactional systems are increasingly being deployed. Real-time data warehousing and BI, supporting its aggressive Go Forward business plan, have helped Continental Airlines alter its industry status from “worst to first” and then from “first to favorite.” Continental airlines (now a part of United Airlines) is a leader in real-time DW and BI. In 2004, Continental won the Data Warehousing Institute’s Best Practices and Leadership Award. Even though it has been a while since Continental Airlines deployed its hugely successful real-time DW and BI infrastructure, it is still regarded as one of the best examples and a seminal success story for real-time active data warehousing.

Problem(s) Continental Airlines was founded in 1934, with a single-engine Lockheed aircraft in the Southwestern United States. As of 2006, Continental was the fifth largest airline in the United States and the seventh largest in the world. Continental had the broadest global route network of any U.S. airline, with more than 2,300 daily departures to more than 227 destinations.

Back in 1994, Continental was in deep financial trouble. It had filed for Chapter 11 bankruptcy protection twice and was heading for its third, and probably final, bankruptcy. Ticket sales were hurting because performance on factors that are important to customers was dismal, including a low percentage of on-time departures, frequent baggage arrival problems, and too many customers turned away due to overbooking.

Solution The revival of Continental began in 1994, when Gordon Bethune became CEO and initiated the Go Forward plan, which consisted of four interrelated parts to be implemented simultaneously. Bethune targeted the need to improve customer-valued performance measures by better understanding customer needs as well as customer perceptions of the value of services that were and could be offered. Financial management practices were also targeted for a significant overhaul. As early as 1998, the airline had separate databases for marketing and operations, all hosted and managed by outside vendors. Processing queries and instigating marketing programs to its high-value customers were time-consuming and ineffective. In additional, information that the workforce needed to make quick decisions was simply not available. In 1999, Continental chose to integrate its marketing, IT, revenue, and operational data sources into a single, in-house, EDW. The data warehouse provided a variety of early, major benefits.

As soon as Continental returned to profitability and ranked first in the airline industry in many performance metrics, Bethune and his management team raised the bar by escalating the vision. Instead of just performing best, they wanted Continental to be their customers’ favorite airline. The Go Forward plan established more actionable ways to move from first to favorite among customers. Technology became increasingly critical for supporting these new initiatives. In the early days, having access to historical, integrated information was sufficient. This produced substantial strategic value. But it became increasingly imperative for the data warehouse to provide real-time, actionable information to support enterprise-wide tactical decision making and business processes.

Luckily, the warehouse team had expected and arranged for the real-time shift. From the very beginning, the team had created an architecture to handle real-time data feeds into the warehouse, extracts of data from legacy systems into the warehouse, and tactical queries to the warehouse that required almost immediate response times. In 2001, real-time data became available from the warehouse, and the amount stored grew rapidly. Continental moves real-time data (ranging from to-the-minute to hourly) about customers, reservations, check- ins, operations, and flights from its main operational systems to the warehouse. Continental’s real-time applications include the following:

 Revenue management and accounting  Customer relationship management (CRM)  Crew operations and payroll  Security and fraud  Flight operations

Results In the first year alone, after the data warehouse project was deployed, Continental identified and eliminated over $7 million in fraud and reduced costs by $41 million. With a $30 million investment in hardware and software over 6 years, Continental has reached over $500 million in increased revenues and cost savings in marketing, fraud detection, demand forecasting and tracking, and improved data center management. The single, integrated, trusted view of the business (i.e., the single version of the truth) has led to better, faster decision making.

Because of its tremendous success, Continental’s DW implementation has been recognized as an excellent example for real-time BI, based on its scalable and extensible architecture, practical decisions on what data are captured in real time, strong relationships with end users, a small and highly competent data warehouse staff, sensible weighing of strategic and tactical decision support requirements, understanding of the synergies between decision support and operations, and changed business processes that use real-time data.

Questions for the End-of-Chapter Application Case 1. Describe the benefits of implementing the Continental Go Forward strategy. 2. Explain why it is important for an airline to use a real-time data warehouse. 3. Identify the major differences between the traditional data warehouse and a real-time data warehouse, as

was implemented at Continental. 4. What strategic advantage can Continental derive from the real-time system as opposed to a traditional

information system? Sources: Adapted from H. Wixom, J. Hoffer, R. Anderson-Lehman, and A. Reynolds, “Real-Time Business Intelligence: Best Practices at Continental Airlines,” Information Systems Management Journal, Winter 2006, pp. 7–18; R. Anderson-Lehman, H. Watson, B. Wixom, and J. Hoffer, “Continental Airlines Flies High with Real-Time Business Intelligence,” MIS Quarterly Executive, Vol. 3, No. 4, December 2004, pp. 163–176 (available at teradatauniversitynetwork.com; H. Watson, “Real Time: The Next Generation of Decision-Support Data Management,” Business Intelligence Journal, Vol. 10, No. 3, 2005, pp. 4–6; M. Edwards, “2003 Best Practices Awards Winners: Innovators in Business Intelligence and Data Warehousing,” Business Intelligence Journal, Fall 2003, pp. 57–64; R. Westervelt, “Continental Airlines Builds Real-Time Data Warehouse,” August 20, 2003, searchoracle.techtarget.com; R. Clayton, “Enterprise Business Performance Management: Business Intelligence + Data Warehouse = Optimal Business Performance,” Teradata Magazine, September 2005, and The Data Warehousing Institute, “2003 Best Practices Summaries: Enterprise Data Warehouse,” 2003.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Writer Writer Name Offer Chat

Writers are writing their proposals. Just wait here to get the offers for your project...

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Mgt 3810 - Reasons why nursing is not a profession - Advantage of gram stain over simple stain - Reply 2 different discussions - Gc column selection guide - Similarities and differences between jainism and sikhism - 3.84 miles in km - Heat capacity of benzoic acid - Beaker picture and uses - Human resource - Chief petty officer selectee leadership course 2019 - HW - Vendor management plan template - Specific governance plan that exists at a company - Grade 12 creative writing module - The following information is available for crane company - Saving sourdi literature to go - Where was jesus crucified theo 104 - Backpacks vs briefcase carroll summary - Regular and irregular verbs list with spanish translation - Kotter’s 8-Step Change Model Chart - Solve the following pair of simultaneous linear equations - First Essay: First Essay Topic: the image below, present an argument based on your analysis of that material artifact or artifacts (in this case, what does it tell us, what does it not tell us, how does it tell us about the society in question). - Bell case interview - Mckesson hr - Leadership traits of martin luther king jr - The albatross poem analysis kate bass - Evaporation and intermolecular attractions lab answers - Verizon PowerPoint - Provider connections early intervention - Mugin 3m uav - M&m dyes for each color - Silver nitrate and copper experiment - Table 1 galaxies to be classified answers - Ib myp math curriculum - Halal ice cream in australia - Accounting rules - Bornavirus in birds symptoms - Http www cliffsnotes com study_guide - Lds new testament institute student manual - Choose a sample crime product - Book review - Capstone Fall Prevention Program Project Literature Review - Calculating time and distance - Oedipus rex chorus quotes - What effect does leasing have on a firm's balance sheet - Domestic violence in sports statistics - Benefits of office automation system - Leadist - Ib areas of interaction - Introduction of distributed database system - Excel guided project 9 3 - 1 page - Heart rate experiment variables - Faber castell 2 83n manual - Slope of perpendicular line calculator - Co2 volume at stp - Bus8 - Where are fire extinguishers located - What is an isoprofit line - Danger of a single story summary - The outsiders book characters - Racq car seat fitting - Alpha boarding kennels macclesfieldispm 15 declaration form - Skinpen by bellus medical for sale - Dress code for endoscopy - Thio free perm kit - Tom swift said it this way supposedly d 55 answers - Cap chap 3 - Left lower lobe collapse sail sign - Carmex leveraging facebook for marketing research - People experiencing overpayment inequity are most likely to - Review on the alchemist - Urgent 3 - 3 fellers bakery case study - If the tension developed in either cable ab or ac - Intermediate accounting chapter 23 statement of cash flows solutions - Artist resale royalty australia - Rhetorical situations and their constituents by keith grant davie - Being an audience centered public speaker - Ibm spss modeler crisp dm guide - Greg doucette cookbook 2.0 - Education should be free for everyone argumentative essay - Homework c9 2 recall 1 - Millward brown digital google vehicle shopper path to purchase study - Acu early entry closing date - 39 rm williams drive walkley heights - A6 - Is boron shiny or dull - Ethics and accountability in public administration - Correct entry to replenish a petty cash fund - Medical assessment unit western general edinburgh - Motive means and opportunity a guide to fire investigation - Practical management science excel files - Trade potential index - How important is it to trace costs appropriately explain - Discussion 5A - Discussion (course - Bussiness Continuation Plan & Disaster Recovery Plan ) - Formative assessment strategies ppt - Citric acid titration method