Dimensional Modelling is a design technique used to organize data in a way that is…