The data analysis is based on DVM-Car dataset, a UK automotive market based research dataset created for business analytics and applications purposes.
I have made use of 'Basic table', 'Sales table', 'Price table' from the dataset to depict consumer analytics and sales modelling.
Basic Table : This table is mainly for indexing other tables. It includes 1,011 generic models from 101 automakers.
Sales Table : It contains 20 years car sales data of the UK market(based on the government released statics of new car registrations).In sum, it covers the sales of 773 car models from 2001 to 2020.
Price Table : This table contains the entry-level (i.e.,the cheapest trim price) new car prices of 647 models across years.
Jingming Huang, Bowei Chen, Lan Luo, Shigang Yue, Iadh Ounis (2021). "DVM-CAR: A large-scale automotive dataset for visual marketing research and applications". In: ArXiv e-prints (Aug.2021). arXiv: 2109.00881