Design Data warehouse schema to analyse to effect of promotion activites versus sales in different retail store of Reliance fresh and in different geographies like state district, state and region. How item sale is affected by the promotions at each store, in each state and across the entire country. Reliance fresh puts some of their products on promotional sales from time to time. There may be a large number of different types of promotions like coupon sales, end-of-the-aisle display, buy-two-get-one-free, etc. Identifying the fact table(s), dimension table(s), their attributes and measures along with the primary key and foreign key relationships.
Design Data warehouse schema to analyse to effect of promotion activites versus sales in different retail store of Reliance fresh and in different geographies like state district, state and region.
How item sale is affected by the promotions at each store, in each state and across the entire country.
Reliance fresh puts some of their products on promotional sales from time to time. There may be a large number of different types of promotions like coupon sales, end-of-the-aisle display, buy-two-get-one-free, etc.
Identifying the fact table(s), dimension table(s), their attributes and measures along with the primary key and foreign key relationships.
Step by step
Solved in 5 steps with 1 images
