Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to model comparible store sales for retail data

2 posters

Go down

How to model comparible store sales for retail data Empty How to model comparible store sales for retail data

Post  dav Fri May 20, 2011 5:35 pm

I am looking for suggestions for how to model comp store sales (vs. non-comp) in a retail data warehouse. One of the requirements is to be able to take any store status of comp (comp, just opened, temporary close, etc) at a point in time and use that value as the basis for comparison for this year vs. last year.

Any suggestions would be much appreciated.

dav

Posts : 2
Join date : 2011-05-20

Back to top Go down

How to model comparible store sales for retail data Empty Re: How to model comparible store sales for retail data

Post  ngalemmo Tue May 24, 2011 1:59 pm

If you collect sales information at its lowest level, doing comparative sales is a simple query problem, not a design problem. Building aggregates will help performance.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

How to model comparible store sales for retail data Empty Re: How to model comparible store sales for retail data

Post  dav Tue May 24, 2011 2:22 pm

thanks for your reply. yes, we are collecting at the lowest level, but since comp status can change daily, i'm interested in a typical data model to handle reporting. how have you seen it modeled effectively?

dav

Posts : 2
Join date : 2011-05-20

Back to top Go down

How to model comparible store sales for retail data Empty Re: How to model comparible store sales for retail data

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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