Warehouse Concepts Question:

Download Questions PDF

Data warehousing deals with all aspects of managing the development, implementation and operation of a data warehouse or data mart including meta data management, data acquisition, data cleansing, data transformation, storage management, data distribution, data archiving, operational reporting, analytical reporting, security management, backup/recovery planning, etc. Business intelligence, on the other hand, is a set of software tools that enable an organization to analyze measurable aspects of their business such as sales performance, profitability, operational efficiency, effectiveness of marketing campaigns, market penetration among certain customer groups, cost trends, anomalies and exceptions, etc. Typically, the term ?business intelligence? is used to encompass OLAP, data visualization, data mining and query/reporting tools.Think of the data warehouse as the back office and business intelligence as the entire business including the back office. The business needs the back office on which to function, but the back office without a business to support, makes no sense.

As explained , Data warehouse contains the data or data mart which final product of all the process like meta data management , acquire , data cleansing , transformation and load other process as mentioned above. Business intelligence are set of software which connects to data mart to do various reporting useful for the business or good running of the company. All the business decision are taken based on the data warehousing reporting. Hope this make sense.