jocelyn0207 / datawarehouse-for-passenger-car-price-analysis-and-statewise-stolen-reports Goto Github PK

This project forked from 2012vaibhav/datawarehouse-for-passenger-car-price-analysis-and-statewise-stolen-reports

Developed Data warehouse for visualisation of data i.e. Used car prices and new car prices including the car theft figures in different states of USA. The objective was to analyse the percentage change in the price of an old car with respect to the new car. Technologies used: MS SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau Applications: • Analysis of New car price for resale purpose after a few years. • Upgradation of vehicle detection systems according to high-risk areas. • Analysis of the number of cost theft with respect to the cost of the car. Video link of execution with explanation is available.