slide1
Download
Skip this Video
Download Presentation
Price Analyzer (PA)

Loading in 2 Seconds...

play fullscreen
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
slide1
Price Analyzer (PA)

Presented by :

Yudith Carmazzi

Sulakshman Madala

Vikas Reddy Vellakonda

slide2
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

slide3
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
slide4
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
slide5
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
slide6
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