You have an opportunity to implement a Data Warehouse at the Broadway Café. However, the cost of building one is high, so you must make some decisions. Using what you know from your readings, answer the following questions.
Dimension Value |
Dimension Value |
Product Price |
Weather |
Customer Gender |
To Go or Dine In Order |
Quantity Sold |
Stock Market Closing Price |
Order Date |
Employee Number |
Payment Method |
Promotion Number |
Product Cost |
Customer Age |
Order Time |
Customer Religious Affiliation |
Exchange Rate |
Manufacturer or Vendor Number |
Interest Rate |
Music Playing in Store |
Season |
Customer Name |
Customer’s Political Affiliation |
Product Number |
Store Hours |
Customer Language |
Commission Policy |
Traffic Report |
Capture your answers in a Word doc or Excel spreadsheet. Make sure that all 3 questions are clearly answered and marked.
Submit your completed assignment using this assignment link.