David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker has heard that his friend, Ephanor, has developed a spreadsheet-based data warehouse model that she uses in her analysis of sales data. Suker is interested in developing a data warehouse model like Ephanor’s so he can analyze orders by department and by product. He will use Microsoft Access as the Data Warehouse DBMS and Microsoft Excel as the analysis tool.
a. Develop the order star schema.
b. Identify the appropriate dimension attributes.
c. Identify the attribute hierarchies required to support the model.
d. Develop a crosstab report (in Microsoft Access), using a 3-D bar graph to show sales by product and by department