A Case Study: Opening Up The Data Warehouse '

Submitted By RyanMouritz1
Words: 2523
Pages: 11
Open Document
________________________________________________________________

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
Show More

Related Documents: A Case Study: Opening Up The Data Warehouse '

Proposal: Book Design and Olde Lyrical Records Essay

vise versa. As your business partner and friend I have put together a proposal of the informational systems that will be beneficial for us as we begin our adventure of opening Olde Lyrical Records. OBJECTIVE Research the various information systems. Decide on which type of information systems would be best for our company to start up with and choose specific systems to purchase. Learn how each new system works and what part of the business the system is used for. Implement new systems into everyday…

Words 686 - Pages 3

Business Problems In Bi Center Case Study

alerts, events and courses offered. - In our university we collect data from all the different educational institutions around the country and by using data mining models like TreeNet we look at the metadata to see if our business strategy can be improved for more student inflow Reference: “data Mining Goes to Hollywood!” - We use PSAW statistical analysis and data mining software for student and faculty data analysis. Using data mining we can identify if same student is enrolled for different…

Words 1116 - Pages 5

Risk Management and Warehouse Building Project Essay

Warehouse Building Project 1 Warehouse Building Project Warehouse Building Project 2 After close review of everything that you would like me and my company to do for you and your company we have come up with the following information and data for you. Having an import export business takes careful planning, reliable suppliers and great line of communication between everyone involved in the company. I have received your list of items you would like to have covered and…

Words 2103 - Pages 9

Essay on Introduction To Section Access Rev 1 1

document This document serves a compliment to the information on Section Access in the QlikView Reference Manual and is aimed towards users who are new to Section Access, to use it in addition to the Developer training and reference manual or just to brush up on old knowledge. The examples are designed for QlikView Developer 9 but the script will work in QlikView Developer 8.50 SR3 and later. **Note that this document does not cover the usage of Section Access for the thin clients (Plugin, Java and Ajax)…

Words 3003 - Pages 13

DSS TMS paper

including carriers, suppliers, customers, and LSP across a logistics e-marketplace (Ross 316). The TMS product can then be used as a central dashboard that enables a collaborative network of customers and carriers. TMS is also closely aligned with Warehouse Management System (WMS). No other supply chain application offers so many ways to save money and increase value. Companies are then able to utilize their TMS to achieve several goals, such as reducing costs through better route planning, improved…

Words 1400 - Pages 6

Supply Chain Mananger Essay

different brands as Volkswagen, Audi, SEAT, Skoda, Volkswagen Commercial Vehicles, Bentley, Bugatti, Lamborghini and Scania. The group range from small and low- consumption vehicles to luxury cars. Commercial vehicles offer heavy trucks, spanned pick- ups and buses. Their Global brand sold and distributed vehicles in 153 countries with 62 production plants in 15 European countries and seven in the Americas, Asia and Africa. Around the world nearly 400,000 employees produced 30,000 vehicles per day or…

Words 1267 - Pages 6

311 646 Assignment 1 Semester 1 2015 Essay

mark divided by three to get your mark out of 25. Your lecturer will discuss with you how you should hand the assignment in This Assignment involves preparation of a formal report on the financial performance and the financial position of THE WAREHOUSE GROUP LIMITED. INSTRUCTIONS: 1. This assignment is to be presented as a formal report to your client, therefore a suitable standard of structure and presentation is expected. 2. The report must be bound in a manner that allows the marker to easily…

Words 1858 - Pages 8

Big Data Challenge Essay

The Big Data Challenges CIS 500 Dr. Robert Joseph 10/27/2013 Today’s day and age you can find innovative technology that you wouldn’t have imagined a decade ago. New technology is everywhere, from Smart televisions, smart phones, even in the vehicles that we drive, technology has been upgraded and constructed into almost everything we utilize in a daily basis. The use and implementation of this new technology has allowed us as humans to take a step back, in a sense, and rely mostly on the…

Words 791 - Pages 4

Rfid: Rfid and Rfid Tag Technology Essay

Today RFIDs are used especially by retail shops to significantly increase the efficiency of the process chain of getting a product from its manufacture to its point of sale, with RFID data are transferred without physical contact in addition RFID helps to identify shipping units in an instant valuable information is recorded and utilized in an international scale, saving retails from a huge time consuming that was before created by all the manual actions. Process that in the past had to be carried…

Words 566 - Pages 3

Essay about Cost Management Analysis

Propose several energy efficient alternatives for the new store Value chain of WOW Supermarkets Inbound Logistics Operations Outbound Logistics Marketing Sales Services • Fuel (From warehouse to supermarket) + Salary + COGS = $30M (Fixed) • Fuel (From producer to warehouses) + Insurance + Truck maintenance = $1M (Variable) • Utility + Rent+ Insurance + Salary = $4M (Fixed) • Utility + Office supplies + Wages + Maintenance = $0.3M (Variable) • Delivery expenses = $0.2M…

Words 629 - Pages 3