Price Analyzer (PA)
Download
1 / 7

Price Analyzer (PA) - PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on

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 .

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Price Analyzer (PA)' - brooks


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)

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.

“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


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


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


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


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



ad