Price Analyzer (PA)
This presentation is the property of its rightful owner.
Sponsored Links
1 / 7

Price Analyzer (PA) PowerPoint PPT Presentation


  • 45 Views
  • Uploaded on
  • Presentation posted in: General

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 .

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Price analyzer pa

Price Analyzer (PA)

Presented by :

Yudith Carmazzi

Sulakshman Madala

Vikas Reddy Vellakonda


Price analyzer pa

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


Price analyzer pa

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


Price analyzer pa

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


Price analyzer pa

Why 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

  • How Oil prices affect the number of seats available in the plane

  • Prices for most frequent days traveled

  • Least and Most efficient fuel efficient planes

  • Number of travelers per airline


Price analyzer pa

Dimensions

  • Airplane Data ( air plane type, airline, seats avail, seats occupied)

  • Date (Year, Quarter, Month, Day)

  • Crude Oil Prices (crude oil price)

  • Flight Routes (Departure City, departure state, arrival city, arrival state, miles traveled)

Fact Tables

  • Number of Customers Travelled

  • Revenue Generated

  • Routes

  • Planes Size

  • Number of miles traveled


Price analyzer pa

Questions?


  • Login