Dimensional modelling

I have created a dimensional model for inventory of products. I have added quantity on hand in fact table, what else can be useful for strategic information analysis?

It is a periodic snapshot fact table.

I would ask the business.

This is for a case study and its not actual business.

What do you mean by "case study"?

It is not a real business just a case study to understand different business processes. So, in actual there is no customer who has requested the data mart. It is just for the purpose of understanding how the inventory case study works.

Ok.

Inventory is usually maintained by SKU (Stock Keeping Unit). Each item would have a unique SKU ID which represents the item and the unit of measure. Variations to the item will have different SKUs.

Inventory is counted by whatever the inventory unit is for that item. Usually it is by case, but could be pallet or each or some other unit. You maintain unit of measure conversion factors for each SKU so you can express inventory in different units than the one in which it is counted. You do not store counts for each unit, nor is a SKU counted in some unit other than the inventory unit. If the warehouse maintains the same item in different units, (they break open cases to handle small orders) they usually assign a different SKU so that separate counts can be maintained.

Thank you so much for your response. What type of queries can be run for strategic information analysis purpose? I am sorry for asking but I am completely new to this and its hard for me to understand.

Having a single fact table containing inventory counts is not exactly a hotbed of analytic knowledge. A capable system would need more data. However, you can do analysis of inventory turn rates, and you can also use it to project tax liabilities (some states have an 'inventory tax', based on the amount in inventory on a particular date).