Data Warehouse and Business Intelligence in Order Essay

Download this Essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Essay:

Data Warehouse and Business Intelligence

In order to write a paper on the similarities and contrast between data warehouse and business intelligence, we need to first define each term before finding the similarities and contrasts between the two.

Data Warehouses

Data warehouse are used for storing data for archival, analysis, and security purposes. The warehouses themselves are made up of one or many computers (i.e. servers) that are connected together into one giant computer (network system).

The data warehouse is more than a 'storing house' or archival system. It also serves as a place for categorizing and 'tidying' the data, thereby making it easy and convenient for the user to get hold of in his day-to-day business. This is essential for the business for in order to make effective decisions it needs to be able to access the right data in a speedy manner. Doing so helps the organization in its decision support system (DSS) which refers to the facts, trends, or other patterns that are needed for the organization to make relevant decisions. In fact, the entire data warehouse discipline was created in the late 1980s (by two IBM researchers Barry Devlin and Paul Murphy) due to the fact that organizations were hunkering under the redundancy of information that they were accumulating and burying their heads in as well as the consequent challenge of forming effective decisions. The problem was exaggerated for large organizations or for those that were linked to others. Many times, businesses lost huge amounts of money in their efforts to accumulate and retrieve the necessary information. The process of gathering, sorting through, revamping, and integrating data was time-consuming and costly, aside from which the data had to be constantly checked, corrected and modified (Inmon, 2005). Data warehouses came about as a result.

Data warehouses come in four different categories. These are:

1. Offline Operational Data Warehouses where data from an online system is copied and pasted into an offline system to be used at the user's convenience.

2. Offline Data Warehouses which is also an offline system that stores data for users to share. Data on this system is updated frequently on a daily, weekly, or monthly basis.

3. Real Time Data Warehouse is a virtual base where data is updated continuously as each new influx of data is fed into it.

4. Integrated Data Warehouses are data warehouses that are integrated with other systems thereby enabling users to access various systems simultaneously. The result is that various systems can pool together in order to process reports and explore various data. (Tech-FAQ Data Warehouse).

Data warehouses have both their advantages and disadvantages. The advantages include the fact that employees and shareholders of a certain organization can have equal access to the same pool of data accessing it for reports, analysis, and decision making. By storing data in one common place, data warehouses also make it easier to conduct development and research for the organization and help the users be on the same page regarding key business concerns.

A further advantage is that pooling the data in one place helps users better regulate and clean the data in order to maintain its consistency and currency. The fact that most data warehouses are integrated also enable users to accumulate diverse pieces of data (such as regards human resources, finance, IT, accounting, etc.) and tie them together towards the needed objective.

On the other hand, data warehouses are difficult to set up and run. These activities are time consuming, and the data stored in the warehouse needs to be continuously checked and assessed making this an expensive and supplementary tasks.

Systems are also always modified and introduced making current systems possibly incompatible with the data which also requires that users need to update the system alongside with the necessary training. This adds to expenditure of time and expense.

Lastly, security is often a concern particularly with data that is relayed over an open system such as the Internet (Tech-FAQ Data Warehouse). Hackers and viruses proliferate and data is vulnerable to attack and exposure.

Business Intelligence

Business Intelligence (BI) first developed in the 1960s and evolved through the 1980s stemming form the from the decision support systems (DSS) that were really computer-aided models used for decision-making and planning. Howard Dresner coined the term in 1989 to refer to "concepts and methods to improve business decision making by using fact-based support systems." (Power 2007)

Business Intelligence (BI) has become the umbrella term used for the variety of software applications…[continue]

Cite This Essay:

"Data Warehouse And Business Intelligence In Order" (2012, October 17) Retrieved December 9, 2016, from

"Data Warehouse And Business Intelligence In Order" 17 October 2012. Web.9 December. 2016. <>

"Data Warehouse And Business Intelligence In Order", 17 October 2012, Accessed.9 December. 2016,

Other Documents Pertaining To This Topic

  • Business Intelligence & Organisational Change

    2003, pg. 3191). While the human analysis component of this definition is important, very little research has looked at it in any level of detail. Combining the various BI definitions we will use the following definition for BI in this research: Business Intelligence consists of the use of analytical technologies and data stores by people in an organization to analyze business problems and produce related business recommendations to improve

  • Data Warehouse a Strategic Weapon of an Organization

    Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to

  • Data Warehouse a Strategic Weapon of an Organization

    Growth Aided by Data Warehousing Adaptability of data warehousing to changes Using existing data effectively can lead to growth Uses of data warehouses for Public Service Getting investment through data warehouse Using Data Warehouse for Business Information Ongoing changes in Data Warehousing The Origin of Data Warehousing and its current importance Relationship between new operating system and data warehousing Developing Organizations through Data Warehousing Telephone and Data Warehousing Choose your own partner Data Warehousing for Societal Causes Updating inaccessible data Data warehousing for investors Usefulness

  • Data Warehouse Case Study VF

    From Supply Chain Efficiency to Customer Segmentation Focus Because of this focus on supply chain forecasting accuracy and efficiency, the need for capturing very specific customer data becomes critical. The case study portrays the capturing of segmentation data as focused on growing each of the brands mentioned that VF relies on this data to base marketing, location development and store introductions, and pricing strategies on. In reality, the data delivered for

  • Business Intelligence Creating Implementing and Using Business

    Business Intelligence Creating, Implementing and Using Business Intelligence in Clinic and Resort Cases In the process of effective decision making for improving opportunities and performance of a business, a vital role is played by Business Intelligence (BI). Business Intelligence Systems understand the environments of organizations and follow a systematic information process. These systems have huge development costs but are widely created, implemented and used in mid-sized organizations, hospitals, resorts and hotels. The

  • Business Intelligence Project Plan and Requirements for

    Business Intelligence Project Plan and Requirements for a Data Warehouse Requirements Analysis In defining the data warehouse requirements for the university data warehouse, the process areas most often relied on to serve the students, faculty, suppliers and broader community need to first be taken into account. The effectiveness of a data warehouse is directly related to the level of accuracy, clarity and precision it contributes to each role in an organization (Bara, Botha,

  • Data Mining in Business Research

    The ability to parse through the many records of transactions, customer contacts, and many other items stored electronically creates the foundation for data mining's definition. Data mining specifically is defined as the process of data selection, exploration and building models using vast data stores to uncover previously unknown patterns, insights, and observations that lead to strategies for effective differentiation and growth. Central to the development of data modeling is the creation of data and prediction models based

Read Full Essay
Copyright 2016 . All Rights Reserved