________________________________________________________________

Opening up the data warehouse
________________________________________________________________

________________________________________________________________ INFT13-320 Advanced Database Assignment 2 – Semester 122 ________________________________________________________________

Prepared by: Ryan Mouritz Prepared for: Bruce Vanstone Due Date: Friday 29 June 2012, 16:00

________________________________________________________________
Ryan Mouritz Page 1 of 14

________________________________________________________________ Contents
Introduction ..................................................................................................................................................................................3 Relevance .......................................................................................................................................................................................4 Risks ..................................................................................................................................................................................................6 Implementation ...........................................................................................................................................................................7 Recommendations .....................................................................................................................................................................8 Conclusion .....................................................................................................................................................................................9 Appendices .................................................................................................................................................................................10 Appendix 1.............................................................................................................................................................................10 Appendix 2.............................................................................................................................................................................11 Appendix 3.............................................................................................................................................................................12 Appendix 4.............................................................................................................................................................................13 References..................................................................................................................................................................................14

________________________________________________________________
Ryan Mouritz Page 2 of 14

________________________________________________________________ Introduction
Already displayed by the organisations current implementation of data warehousing for business intelligence, it is clear that it has an extensive area of coverage within the organisation which is used to harness the power of data to make informed decisions and guide future business practices. These in turn, further enhance the company’s growth. There are however shortcomings in the current implementation of data warehousing and the extent to which it is usable beyond executive decision making. As such powerful methods of business intelligence become easier to use, access should be available to employees from the executive level through to the level of daily operations management as well as to external partners in order to improve the efficiency of the supply chain and consequently the organization itself. As concluded by the Independent Oracle Users Group (IOUG) (McKendrick, 2011) in their report based