1 / 15

Vineela Tatineni

Jeff Rix. Navya Karuturi. Vineela Tatineni. s tar s chema. Extraction –Transformation-Loading. Extracted data of different vehicles region wise by external websites. Transformed and sorted accordingly Loaded the Data into Data Source and connected to the Analysis Services.

anja
Download Presentation

Vineela Tatineni

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 NavyaKaruturi VineelaTatineni

  2. star schema

  3. Extraction –Transformation-Loading • Extracted data of different vehicles region wise by external websites. • Transformed and sorted accordingly • Loaded the Data into Data Source and connected to the Analysis Services.

  4. Vehicle Data Source View

  5. Dimension Attributes for Dealerships

  6. Creating Hierarchy

  7. Total Sales of the Vehicles sold by each Region, state , City and Dealership Name

  8. Dimension Attributes for Date

  9. Total Sales For each Day, Month, Quarter and Year..

  10. Reports: Sales By Dealership sort by state

  11. Highest Sales By vehicle Type Determine Sales by State and Vehicle name

  12. Sales by Quarter Sales by Region for 4th Quarter

  13. Sales By Month for State [Houston]

  14. Conclusion : All the Business Needs For the Ford Company Are Fulfilled.

  15. Any Queries

More Related