Introduction Data warehouses are used to contain data used to support decision making. Data accumulated by a
Fantastic news! We've Found the answer you've been seeking!
Question:
1. You are required to design a Data Warehouse Schema and populate it with data extracted from the various operational sources you will have identified.
2. Explain with justification the approach you would have used in arriving at the Data warehouse Design.
3. Explain with justification the key Extraction, Transformation and Loading routines used as part of building and populating your Data Warehouse.
4. Using appropriate aggregations and suitable OLAP operations, demonstrate some of the reporting that could be done from the Data Warehouse by showing an example roll up, slice, dice, pivot, drill down and other suitable reporting queries.
5. Design at least two data marts suitable for use by the organization Sales Function and Finance functions.
6. A Report that discusses all you design and implementation decisions and shows your overall view of how data warehouses are used in organizations.
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: