Introduction. Business intelligence refers to software, hardware and practices applied in data collection, processing and analysis in order to assist managers in informed decision making. A Data Warehouse is a composite area for storing data from multiple company areas. Say no to plagiarism. Get a tailor-made essay on "Why Violent Video Games Shouldn't Be Banned"? Get an original essay Data warehousing is therefore a fundamental module in business intelligence as it allows information to be stored in a common place, therefore allowing quick access and is often analyzed and used to make informed decisions by managers and other collaborating end users . Best practices to follow when designing a data warehouse for business intelligence use. Sponsorship. Make sure you have a high-level corporate sponsor not only during construction but also one who remains present even after the data warehouse is built and presents itself ready for use. The corporate sponsor should communicate with other business partners. Data owners and managers are obliged to establish full ownership of the data they contain. Room for growth. Data will be continually added, so when designing you should consider leaving enough space for incremental addition of data. In addition to that, you should also remember to maintain the team of developers who assisted you in creating it for this purpose. Competence. Depending on how you want to design the required system, you should select experts who are knowledgeable in that area to advise you on the best design methods as well as validate your resources and choice of technologies. Scope reduced to a minimum. During the early stages of construction, be sure to narrow down the subject areas to work on to reduce the initial construction investment and assist in gaining experience in a smaller area to expand later. Loading the data warehouse. Tools such as the Utility Extract/Transformation/Load (ETL) software tool, among other tools, can be used to verify, for example, whether data quality is maintained. How often to load data into the data warehouse is another element that should be considered. Education and support. You need to have the necessary information describing the new system, including modeling techniques and tools along with its structure and method of accessing information from the data warehouse. This is to be used by cooperating users of the system who may not be familiar with its operation. Future changes. It must be ensured that the data warehouse modification process is controlled and documented in detail. Steps for implementing a data warehouse. develop a feasibility study. The costs and benefits of implementing a data warehouse are defined, as well as the elements that contribute to the success of the system implementation. The advantages and disadvantages of implementing the required system are taken into account. The results of the feasibility study are presented to company executives to decide on sponsors. The tasks of each of the development team members involved in the implementation are also defined. Business line analysis. This involves familiarizing yourself with the organization for which the system was created, its operations and business requirements. At this juncture the scope of the data warehouse is defined. Design of the data warehouse architecture. The physical and logical foundations of the system to be built are designed which include the.