A pharmaceutical retail store manages its current sales, procurement, and materials availability at the store through Excel sheets. Owing to the increase in the number of branches in the city, the store manager is now finding this process of data maintenance tedious. She is now banking on the multidimensional model to manage its store operations.

She identifies the questions that need to be answered for its store operations:

Transcribed Image Text:

Sales by medicine and store location: How many medicines are to be ordered at the end of each month? Frequency of sales by time dimension: Identify when to re-order.