Case Study on Data Warehousing

Data Warehousing Case Study:

Data warehouse is the data base, which is created for the reporting and business analysis for the decision making in the organization. The information, which comes into the data base as a rule is available only for reading. The data is copied into the system in such a way to avoid any problematic situations with the analysis of the information and not to disturb the stability of the data base. As a rule, the information is put into the data base periodically, that is why its relevance can lag behind the online transaction processing system. There are several principles of the organization of the data warehouse. First of all, the data is united according to the field or themes they are describing.

Then, the data is united in such a way to satisfy the requirements of the organization in the whole, but not a certain single function of business.The data which comes into the warehouse can not be corrected. It comes from the outer sources and can not be changed or deleted. The information which is kept in the data warehouse can remain relevant only if it is bounded to the certain period of time. There are several sources of data: the traditional systems of the registration of operations; the definite documents; sets of data, etc. There are such operations, which can be practised in the warehouse: extraction of data, processing of data (preparation of the data for the storage), downloading, analysis and presentation of the results of the analysis.

Writing a data warehousing case study is quite a difficult process, because one should improve his knowledge on the whole topic and only than he will manage to complete a good case study on the definite problem. In order to research the problem which occurred in the case a student should collect information about the case site. When there is background information, a student will be able to analyze the reason of the problem and weigh its consequences. One should demonstrate his professional and critical thinking skills and brainstorm the most effective solutions to the problem. The solutions can be alternative to the ones, suggested in the case study.

Case study writing is quite a problematic process, because there is a list of the special requirements which should be met in the successful paper. It is obvious that an inexperienced student will never succeed in the writing process, so he should take advantage of the Internet and read a free sample case study on data warehousing there. Nearly every high-quality free sample case study on data warehousing and data mining is prepared by the professional writer online, so it is wise to improve one’s knowledge with this assistance.