How to model comparible store sales for retail data

View previous topic View next topic Go down

How to model comparible store sales for retail data

Post  dav on 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

View user profile

Back to top Go down

Re: How to model comparible store sales for retail data

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

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

View user profile http://aginity.com

Back to top Go down

Re: How to model comparible store sales for retail data

Post  dav on 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

View user profile

Back to top Go down

Re: How to model comparible store sales for retail data

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