Before i get started on my assignment, I have to figure out how to organize these into a fact table connected to dimension tables.
A Coffee Store is collecting the following information:
1. Product Type (ex: coffee, espresso, herbal tea, tea, etc.)
2. Product Description (ex: Columbian, Cafe latte, Mint, Darjeeling, etc.)
3. Product ID (ex: 1,2,3,4, etc.)
4. Type (ex: regular, decaf, etc.)
5. Area Code (for store location, such as 203, 206, 209, 210, etc.)
6. State (for store location, such as, Connecticut, Washington, California, Texas, etc.)
7. Market (location of the store in markets such as East, West, South, etc.)
8. Market Size (ex: small, major, etc.)
9. Profit (ex: measured in dollars)
10. Margin (ex: measured in dollars)
11. Sales (ex: measured in dollars)
12. COGS (ex: measured in dollars)
13. Budget Profit (ex: measured in dollars)
14. Budget Margin (ex: measured in dollars)
15. Budget Sales (ex: measured in dollars)
16. Budget COGS (ex: measured in dollars)
Could someone possibly provide some help in this that has more knowledge on it?