Question: David Suker the inventory manager for a marketing research company

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


View Solution:


Sale on SolutionInn
Sales0
Views242
Comments
  • CreatedDecember 03, 2014
  • Files Included
Post your question
5000