ms. victoria ephanor manages a small product distribution company. because
ms. victoria ephanor manages a small product distribution company. because the business is growing fast, ms. ephanor recognizes that it is time to manage the vast information pool to help guide the accelerating growth. ms. ephanor, who is familiar with spreadsheet software, currently employs a small sales force of four people. she asks you to develop a data warehouse application prototype that will enable her to study sales figures by year, region, salesperson, and product. (this prototype is to be used as the basis for a future data warehouse database.) using the data supplied in the ch13_p2.xls file, complete the following seven problems:a. identify the appropriate fact table components.b. identify the appropriate dimension tables.c. draw a star schema diagram for this data warehouse.d. identify the attributes for the dimension tables that will be required to solve this problem.e. using a microsoft excel spreadsheet (or any other spreadsheet capable of producing pivot tables), generate a pivot table to show the sales by product and by region. the end user must be able to specify the display of sales for any given year. (the sample output is shown in the first pivot table in figure p13.2e.)f. using problem 2e as your base, add a second pivot table (see figure p13.2e) to show the sales by salesperson and by region. the end user must be able to specify sales for a given year or for all years and for a given product or for all products.g. create a 3-d bar graph to show sales by salesperson, by product, and by region.
Price Type: Negotiable
Total Proposals: 10
1 Current viewersl
94 Total views
Proposals Reputation Price offered
- 8 Jobs 6 Reviews $0 in 0 Day