1 / 14

Jeff Rix

Jeff Rix. Navya Karuturi . Vineela Tatineni. Business Background. Motor Company is a global automotive industry founded in Dearborn, Michigan. It is the second largest automaker in the U.S , which has consistently outran its own record performance past 10 years.

floria
Download Presentation

Jeff Rix

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. Jeff Rix Navya Karuturi Vineela Tatineni

  2. Business Background Motor Company is a global automotive industry founded in Dearborn, Michigan. It is the second largest automaker in the U.S , which has consistently outran its own record performance past 10 years. It is a wide spread company expanded over all the four regions. It has a wide range of vehicle types.

  3. Business Needs To help management keep track on the following : • What dealership has the lowest sales in each state? We could determine which dealerships to close first to reduce overhead. • What vehicle types sell the most in each region? We would know what types of vehicles to provide in each region. • What vehicle name sells the most in each state? We would know to order more of that product in that state. • What quarter has the highest sales? We would know when to order more vehicles for the dealerships.

  4. Business needs What region sells the most in each quarter? We could use this data to find out where we would like to create new dealerships. What vehicle type is selling the least in each state? We would know to order less of that product in that state. What quarter is least successful by state? We could enhance marketing in that quarter.

  5. Business Dimensions Vehicle Date_Time Dealership Business Fact Vehicle_Fact

  6. Vehicle Table

  7. Dealership Table

  8. Date_Time Table

  9. Fact Table:

  10. Hierarchies From Lower Level to Higher Level

  11. Hierarchies: Date_Time Hierarchies: • Day • Week • Month • Quarter • Year

  12. Vehicle Hierarchies: Vehicle Vehicle_Make Vehicle_Type Vehicle_Year Dealership Hierarchies: Dealership Dealership_City Dealership_State Dealership_Region

  13. Any Queries ?? Thank You !

More Related