How Business Intelligence Tools Are Used With Data Ware Houses: [Essay Example], 764 words GradesFixer

Haven't found the right essay?

Get an expert to write your essay!


Professional writers and researchers


Sources and citation are provided


3 hour delivery

This essay has been submitted by a student. This is not an example of the work written by professional essay writers.

How Business Intelligence Tools Are Used with Data Ware Houses

Download Print

Pssst… we can write an original essay just for you.

Any subject. Any type of essay.

We’ll even meet a 3-hour deadline.

Get your price

121 writers online

Download PDF


Business intelligence refers to software, hardware and practices applied in collecting data, processing it and analyzing it in order to assist managers in informed decision making. A Data Warehouse is composite storage area for data taken from several areas in the company.

Data warehousing is therefore a core module in business intelligence as it allows information to be stored in a common place, therefore enabling fast access and is often analyzed and used for making informed decisions by managers and other cooperate end users.

Best practices to be followed when designing a data warehouse for the use of business intelligence.


Make sure you have a high-level business sponsor not only during the building but also one that remains present even after the data warehouse has been built and is presented ready for use. The business sponsor ought to be communicating with other business partners. Data owners and handlers are obliged to establish full ownership pertaining the data there-in.

Room for growth.

Data is continually going to be added, therefore when designing it one should consider to leave enough room for incremental addition of data. To add on to that, you should also remember to retain the team of developers that assisted in building for this purpose.


Depending on the manner in which you want to design your required system, you should select experts experienced in that area to advice you on the best designing methods in addition to validating your resources and choice of technologies.

Minimized scope.

During the early steps in building, ensure you reduce the subject areas to be worked on so as to lower the investment in the initial build and assist in acquiring experience in a smaller area to be expanded later.

Loading the data warehouse.

Tools such as Utility Extract / Transformation / Load (ETL) software tool among other tools can be used to verify for example, the quality of data is maintained. The frequency in which to load data into the data warehouse is another element that should be considered.

Education and support.

One needs to avail the necessary information describing the new system including the techniques and modelling tools together with its structure and method of how to access information from the data warehouse. This is to be used by cooperate users of the system who may not be familiar with how it operates.

Future Modification.

One ought to ensure the modification process of the data warehouse is controlled and documented in detail.

Steps for implementing a data warehouse.

Carrying out a feasibility study.

The costs and benefits of implementing a data warehouse are defined as well as the elements that contribute to the successful implementation of the system. One puts into consideration the advantages and disadvantages of implementing the required system. The results of the feasibility study are presented to the managers in the company to decide on the sponsors. Tasks of each of the developer team members involved in the implementation are also defined.

Business line analysis.

This involves getting to familiarize with the organization for which the system is built, its operations and business requirements. The data warehouse scope is defined at this juncture.

Design of the data warehouse architecture.

The physical and logical foundation of the system to be built which includes the support architectures, data and technical structures necessary for implementation as well as the applications are designed.

Selection of the technological solution.

The best tools for use in implementing the data warehouse are chosen. The technical and business requirements for the implementation need to be put into consideration.

Project iterations planning.

User and technical requirements for the new system are redefined, the restrictions brought about by the present systems are also noted and documented.

Data Warehouse Modelling.

The database schema is achieved, metadata is defined and data source list is updated to include all the information necessary for the building and setting up of the new system.

Testing and implementation.

The developers test the system and later involve the users to use the system in an attempt to detect and eliminate any errors in the system.

Roll-out and deployment.

The system is the presented to the managers and other cooperate users for use.

Data warehouse maintenance techniques and strategies.

A data warehouse management system is used in the maintenance of the data warehouse.

Maintenance techniques and strategies include the following:

View Synchronization.

In this technique, any affected view definition is rewritten in the data warehouse whenever there is a schema change in thus making the current view definition undefined.

Incremental view maintenance.

This technique maintains the data warehouse extent every time a data update occurs within a source.

View Adaptation.

This technique enables the adaptation of the view extent incrementally after the view definition has been changed either directly by the data warehouse designer or indirectly by the view synchronization system.

Remember: This is just a sample from a fellow student.

Your time is important. Let us write you an essay from scratch

100% plagiarism free

Sources and citations are provided

Find Free Essays

We provide you with original essay samples, perfect formatting and styling

Cite this Essay

To export a reference to this article please select a referencing style below:

How Business Intelligence Tools Are Used With Data Ware Houses. (2019, Jun 27). GradesFixer. Retrieved October 26, 2020, from
“How Business Intelligence Tools Are Used With Data Ware Houses.” GradesFixer, 27 Jun. 2019,
How Business Intelligence Tools Are Used With Data Ware Houses. [online]. Available at: <> [Accessed 26 Oct. 2020].
How Business Intelligence Tools Are Used With Data Ware Houses [Internet]. GradesFixer. 2019 Jun 27 [cited 2020 Oct 26]. Available from:
copy to clipboard

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

    By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.


    Attention! this essay is not unique. You can get 100% plagiarism FREE essay in 30sec

    Recieve 100% plagiarism-Free paper just for 4.99$ on email
    get unique paper
    *Public papers are open and may contain not unique content
    download public sample

    Sorry, we cannot unicalize this essay. You can order Unique paper and our professionals Rewrite it for you



    Your essay sample has been sent.

    Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

    thanks-icon Order now

    Hi there!

    Are you interested in getting a customized paper?

    Check it out!
    Having trouble finding the perfect essay? We’ve got you covered. Hire a writer uses cookies. By continuing we’ll assume you board with our cookie policy.