Business intelligence is required everywhere and it is most importantly required in data warehousing due to the technologies that are getting used in it. It allows the applications and the practices to be performed according to the business rules and regulations. Business intelligence consists of collection, integration, analysis and the presentation of the information that is used to make business related decisions. This is also used to build business related system like decision support system that provide historical, current and predictive data that can be used in the favor of setting up the environment of the database system. It uses computer based techniques to extract the information from many resources and analyze it according to the industry. It is used to provide nearly accurate decision making system.