DATA Analysis 337

Practice Sheet Dimension Modeling Design the data warehouse for a restaurant chain: The data warehouse has to allow the owner to analyze daily Sales with respect to the Menu items, food category, date/time and restaurant location. The owner needs to analyze: o The food with respect to its cost, category, name. o Ingredients with respect to cost, weight, expiration date o Suppliers with respect to name, address, type, total sales o the employee with respect to their experience level, years with the restaurant, name, and job name o The store with respect to their location (city, state, zip code), opening date, number of employees, square footage. o The owner is interested in learning more about the quantity, total sales, discounts and tips. Identify facts, dimension, attributes and any measures related to facts. Make sure you include your keys in the schema. Draw a star schema. Focus