Dimensional modelling

View previous topic View next topic Go down

Dimensional modelling

Post  Moonpari on Wed Oct 05, 2011 1:15 pm

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.


Last edited by Moonpari on Sat Oct 08, 2011 2:39 pm; edited 1 time in total

Moonpari

Posts : 4
Join date : 2011-10-05

View user profile

Back to top Go down

Re: Dimensional modelling

Post  BoxesAndLines on Wed Oct 05, 2011 2:34 pm

I would ask the business.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Dimensional modelling

Post  Moonpari on Wed Oct 05, 2011 8:44 pm

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

Moonpari

Posts : 4
Join date : 2011-10-05

View user profile

Back to top Go down

Re: Dimensional modelling

Post  ngalemmo on Thu Oct 06, 2011 12:52 am

What do you mean by "case study"?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional modelling

Post  Moonpari on Thu Oct 06, 2011 1:06 pm

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.


Last edited by Moonpari on Thu Oct 06, 2011 3:25 pm; edited 1 time in total

Moonpari

Posts : 4
Join date : 2011-10-05

View user profile

Back to top Go down

Re: Dimensional modelling

Post  ngalemmo on Thu Oct 06, 2011 1:22 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional modelling

Post  Moonpari on Thu Oct 06, 2011 8:24 pm

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.

Moonpari

Posts : 4
Join date : 2011-10-05

View user profile

Back to top Go down

Re: Dimensional modelling

Post  ngalemmo on Fri Oct 07, 2011 2:39 pm

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).
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional modelling

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum