Recommendations for Data Warehouse Concept - Literature review Example

? Recommendations for Data Warehouse Concept Recommendations for Data Warehouse Concept Executive Summary The main aim of various business organizations is to be the leading producer of goods and services offered to their customers in order for the organization complete with competitors in the competitive market. In order for organizations to achieve these desire, organizations through their management, should make sure that they come up with proper strategies that reflects better solutions in meeting various goals of the organization. Due to the introduction of the information technology, through the invention of computer technology, it is better for organizations to implement these technologies in order for them to have better operation of the organization. In the process of using these technologies, these organizations will have the opportunity to increase the rate of production and quality products, hence, better services to their clients. In the process of using various techniques of information technology, organizations should make sure that they define problems on the ground by identifying some of the impacts of the situation to the organization. The organization should also make sure that they allocate funds for the development of the project in the process of system development and implementations are completed in time. In addition, organizations should make sure that they involve various members of the organization in system development and implementation in order for the organization to avoid the rejection of the system during the testing process by the users. Therefore, it is good for organizations to make use of this technological advancement in order to produce better services to their customers. Introduction Following the introduction of information technology in the business market, it has resulted to various impacts in business organizations in relations to various activities of the organization. Through the introduction of information technology, organization have better chances of producing goods and services of high quality and quantity, production of timely products and services to their customers, and have an easy reach of their customers. In addition, the introduction of information technology as eases communication in various organizations because through the technology advancement, these organizations are able to coordinate by having easy communication among them. These communications are kept easy because they are in the position of having easy, faster and low cost communications, especially through the internet as compared to the manual system of communications such as postal services that were expensive and were not good for instance decision making as they took time to pass information from one location to another. Moreover, through the use of information technology, business organization information is kept safely as the information access are controlled through a database system with governs by rules and regulations that controls access to the information. Description of Data Warehouse There are various activities that take place in every organization in order for the processing of services to be completed. Therefore, there is the need for data collection, data analysis, and process and data storage in regards to the organization. Not all the available data are public, therefore, there are some of the data that are private and need to be kept safely from un-authorize users. In order for any organization to be in the position of keeping their information safely, there is a need for the introduction of the data warehouse (Haggerty & Meister, 2003). Data Warehouse is a form of database system that help various organizations in the collection of data, data analysis, data reporting and storage of data safely so that they stored data can only be available to genuine users. Therefore, this is the central position that helps users to integrate data from various sources for them to be analyzed for the accurate outputs to be generated. Data analysis involves various complex activities such as collection of data from different sources, analyzing these data although they may contain conflicting information about the matter being addressed. In order for organizations to make sure that they the introduce data warehouse as the system for collection and analyzing of the collected data for the production of timely and accurate information. Apart from the timely information, through the use of data warehouse, these organizations that use the system will be in the position of dealing with complex data analyzing that would not be possible through the use of manual system of data analysis (Haggerty & Meister, 2003). Consequently, for any organization to be able to operate within their plans and objective as far as data analysis is concerned, it is important for the organizations to introduce the use of data warehouse to facilitate faster processing of information. Data warehouse is also important because it would help in the production of information that can be used in instant decision making as the results would be readily available. Lastly, these organizations, through their managers, should have in mind that in order for the system to produce better results, they should employ potential workers who have better skills in the use of the system and be able to involve system users during system development. Importance of Data Warehouse to Canada Tire Cooperation According to the information on the Canada Tire Cooperation concerning their data collection and processing, there are various challenges that the organization faces in use of the manual system of data processing and analysis. Some of the challenges faced are the production of inaccurate information through difficulty in dealing with complex data, the management of the organization believes that the current workforce of the organization fit for the use of a manual system, hence, detailing the process of introducing systems that reflect current system in the market, and the problem of timely production as the process used is slow (Haggerty & Meister, 2003). In order for the organization to be able to solve these problems, there is a need for the organization to introduce the use of data warehouse within the organization to cater for data collection and analysis. Therefore, through the use of data warehouse, Canada Tire Cooperation will be in the position of a database system that is responsible for the collection of different data from various sources. Due to the fact that data analysis needs proper data comparisons from different information in order for the accurate data to be produced, the use of data warehouse will help the organization in comparing different data and come up with accurate information as compared to the manual system used by the organization (Haggerty & Meister, 2003). Through the manual process, most of the analysis is done by human beings. These people are prone to error; therefore, it may lead to the production of inaccurate information. Therefore, the use of data warehouse in the analysis of complex and different data is of grate importance because the system will only require for accurate data to be entered into the system for the system to produce accurate results. Hence, data warehouse system of data analysis becomes the best system for Canada Tire Cooperation because it deals with more data analysis that would be necessary for accurate information for the organization to operate within the set objectives. Data security is one of the main aims of Canada Tire Cooperation because the organization deals with large volumes of data of which most of the data dealt with are private and confidential. Therefore, the organizational management must make sure that private data that are used during data analysis are safe both during the analysis and storage stage, where the information produced are stored for future use. The current organization, which is partly manual methods of data analysis and storage, are not good for the security of data as most of the data are open and can be easily accessed by strangers (Haggerty & Meister, 2003). Therefore, the organization should make sure they introduce the system of data warehouse that would be used in the analysis and storage of data. With the use of data warehouse as the central system of the collection and processing of data, the organization will make sure that the data dealt with and the information kept is kept safely. One of the ways in which the system of data warehouse will be of benefit to Canada Tire Cooperation is that the system will require a system administrator who will be responsible for various activities in order to maintain the security of data of the organization. The database administrator of the data warehouse will ensure that he or she comes with proper rules and regulation that users should be adhered to in the process of collecting, processing, analyzing and storage of data of the organization (Haggerty & Meister, 2003). The administrator will introduce the use of usernames and passwords in the access of information in the database. Therefore, through these usernames and passwords, users of the system will be required to access the information in the database by using the username and passwords as their identities. Through the use of these identifications, the organization will have control of the data stored in the database because it will help in access denial to un-authorized users of the database who may access information for malicious gain. It is the desire of every organization to produce goods and services that are as per the expectation of their clients. This process can only be triggered through the use of data warehouse for the Canada Tire Cooperation as the system will helps in the production quality and accurate information from the process of data analysis as the system only require for the users to feed accurate data for accurate information to be produced. Therefore, the organization should make sure they have skilled personnel accurate entry to be performed. Another importance of introducing data warehouse to Canada Tire Cooperation is the need for timely information for clients and for decision making within the organization (Haggerty & Meister, 2003). Through the use of a data warehouse system as the current information technique in storing information about the organization, Canada Tire Cooperation will solve any problem of delay as experienced in the use of their current system of data analysis. This will increase their chances of producing accurate and timely results as per the expectation of their customers. The process of data communication is very essential for any organization data deals with data processing and analysis because after the analysis, this information needs to be transferred from one location to another without being interfered with. Therefore, for the organization to make sure that the process of communication is achieved, there is a need for the organization to introduce data warehouse. Data warehouse allows the use of communication systems such as internet services that facilitate faster communication of data to various departments of the organization (Haggerty & Meister, 2003). In addition, through the use of information technology, especially internet services in data communication, information passed through the internet are secure because the organization, through their data administrator, the organization will be able to encrypt the organization passed making it difficult for hackers to access the information. Moreover, internet services will help the organization to pass information at a faster rate as long as an accurate medium of transmission is selected. Therefore, through the introduction of data warehouse in Canada Tire Cooperation, the organization will be in the position of solving various problems facing the organization. Ways in which Data Warehouse need to be implemented in Canada Tire Cooperation For the introduction of the new system, data warehouse, to be implemented in the working premises of Canada Tire Cooperation, there are various factors and procedures that should be put in place for the system to operate well. Therefore, in order for the implementation of the new system to be achieved, the organization should make sure that they use compatible hardware and software that are in the market (Haggerty & Meister, 2003). This move is very important because through the use of these peripheral devices, it will help in the maintenance of the system as the system will require regular checks and maintenance. Moreover, in the process of using the available devices in the market, the organization will in the best position in repairing the system. Therefore, Canada Tire Cooperation should make sure they go for better and user friendly devices. Another important factor in the process of implementation that the organization should put in the place is the process of implementing. For the organization to realize better implementation process, the organization should make sure that the process of implementation should be gradual in order for full implementation to be achieved. Therefore, a parallel process of system implementation should be applied, which is the process of testing both the older and the new system and the results noted. If the results of the new system are better than the old system, the organization should do away with the old system for the new system to be used by the organization (Haggerty & Meister, 2003). On the other hand, the organization should make sure that during system development they involve other members of the organizations such as workers and other system users. By involving system users in the system development, the organization will be in the position of preventing some of the rejection of the organization during system implementation. In the presence of system rejection by system users, the organization shall have lost especially in its spending because the process of designing and developing of a system is costly. Recommendations and Conclusion Need for better services by Canada Tire Cooperation to their clients in relations to the current development in information technology is of better chances for both the organization and their end product users. Due to the facts that the organization deals with a large volume of data processing and analysis, Canada Tire Cooperation should make sure they develop new system for their operations. Therefore, through the introduction of data warehouse, the organization will be in the best position of producing accurate within a short period of time as compared to the manual system of data analysis. Moreover, as per the security of data, information used in the collection of data and the process of data analysis is secure as the information is controlled through a database system. Therefore, it is important for the introduction of data analysis through the use of data warehouse should be encouraged by organizations for them to provide better services to their clients. References: Haggerty, N., Meister, D. (2003). “BUSINESS INTELLIGENCE STRATEGY AT CANADIAN TIRE”. Richard Ivey School of Business. Pp. 1-25. Read More