Benefits Of Data Warehouse

0 Comment

Developers of these three technologies are recently integrating them into one package. This eradicates the need for specialists installing them after purchasing the database (Ling and Tamer, 2009). The research will establish the different areas of running businesses that this technology can be applied. Some of the areas to be checked are budgeting, sales forecasting and determining whether to produce a new product or not.The main objective will be establishing the benefits accrued by multinational businesses when they carry out data mining in their data warehouse. This information will be used in determining if these benefits can be passed to small scale businesses without the capability of purchasing this technology (O’Brien amp. Marakas, 2009).The research will establish the cost-benefit that businesses receive by using this technology. Cost-benefit will establish the opportunity cost of using this technology instead of manual data analysis using the stand-alone software.The data warehouse is a collection of data which helps management in decision making. The warehouse has the capability of providing an enormous amount of information at the same time. This makes it a better tool for use by businesses that are storing the amount of information about their production operation process. The data warehouse ability of integration with modern analysis tools like OLAP is an advantage to corporate. This helps in the timely and correct analysis of data, which can be used in decision making by managers (Agosta, 2004). OLAP are software tools that enable a data analyst to analyze data and view it from multiple perspectives. The multiple perspective help managers analyze different options of a problem before arriving at a conclusion. OLAP support activities like analyzing the financial trends in businesses. This would bring to the attention of a manager a production line that cost of production is rising without any additional benefits accruing from it. OLAP tools are easy to use and do not require massive investment because some of them can be used in desktop machines.