To add to what I previously stated. If you're using an analysis tool, such as SSAS, you may have to "normalize" to a star or snowflake to take advantage of the things that "pivots" and the like can do. Just be aware that since it is for sales and sales are, by their very nature, "historical", how you handle changes to locations and product names will play a key role in what you can actually report. Type 1 or Type 2 SCDs or other historical reporting methods can play a very important role in that.