1 / 22

Price Analyzer (PA)

Price Analyzer (PA). Presented by : Yudith Carmazzi Sulakshman Madala Vikas Reddy Vellakonda . News About Crude Oil prices and Airlines Industry. Facts : . In the latest Lundberg Survey, folks paying the lowest average price were in Tucson, Arizona, at $3.41 a gallon .

cloris
Download Presentation

Price Analyzer (PA)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Price Analyzer (PA) Presented by : Yudith Carmazzi Sulakshman Madala Vikas Reddy Vellakonda

  2. News About Crude Oil prices and Airlines Industry Facts: In the latest Lundberg Survey, folks paying the lowest average price were in Tucson, Arizona, at $3.41 a gallon. “This doesn't mean that we will get there," she said. "Crude oil will decide.” – CNN “Airlines are on pace for another year of deep losses because of rising jet fuel costs.” – NY Times

  3. Problems found in the Airline Industry • Fluctuating Gas prices - Gas prices have been fluctuating a lot over the past 5 years as a result of the constant increase in the international crude oil prices • Increase in Competition - Like any other major industry, the survival of the Airline industry depends up on keeping themselves in top with their competitors • Slow economy – With the impact of the great recession and a slow recovery, There is a real slow economic activity among the individuals and the business customers • Seasonal Increase in Demand

  4. About US • VYM is Leader in Developing Customized decision making systems for the Business • Started in 1992 at Houston, TX with 25 employees • Has a global footprint with 4 offices and development centers in US, India and Singapore • VYM have over 200 employees as on October 5, 2010 • Our major client base includes governmental agencies, airline industry, consumer watchdog groups and airline customers

  5. With Data Warehouse We should be able to answer the following questions: • How Oil prices affected the number of travelers • Prices for most frequent flight route • The most traveled routes • Most traveled airlines

  6. SNOWFLAKE SCHEMA

  7. Data Dictionary

  8. Dimensional Hierarchy

  9. Data Model

  10. Airplane Maker Data Airplane Data

  11. Location Data Airline Carrier Info – Competitor Data

  12. List of Routes Time Table

  13. Airline Facts Data

  14. DIMENSION IMPLEMENTATION

  15. CUBE IMPLEMENTATION

  16. DIMENSIONS USED IN CUBES

  17. BOWSER SHOWING FARES PER ROUTE USING TIME HIERARCHY

  18. BOWSER SHOWING MOST TRAVELLED AIRLINES USING TIME HIERARCHY

  19. BOWSER SHOWING MOST TRAVELLED ROUTES USING TIME HIERARCHY

  20. BOWSER SHOWING PRICES FOR THE ROUTES USING TIME HIERARCHY

  21. BOWSER SHOWING CHANGE IN NUMBER OF CUSTOMERS PER CHANGE IN OIL PRICES USING TIME HIERARCHY

  22. Questions?

More Related