N/APosted on - 06/28/2011
Hello M. Smith is here. I have a problem in this question because this question confused me so please anybody can help me to tell me that the difference between Data warehousing and Business Intelligence. Also describe the difference between Data warehousing and Business Intelligence. I am waiting for a better and accurate answer. Thanks
Difference between Data warehousing and Business Intelligence
Hi Rizwan is here for your help.
Data Warehousing helps you store the data while business intelligence helps you to control the data for decision making, forecasting etc. Data warehousing using ETL jobs, will store data in a meaningful form. However, in order to query the data for reporting, forecasting, business intelligence tools were born. The management of different aspects like development, implementation and operation of a data warehouse is dealt by data warehousing. It also manages the Meta data, data cleansing, data transformation, data acquisition persistence management, archiving data. In business intelligence the organization analyses the measurement of aspects of business such as sales, marketing, efficiency of operations, profitability, and market penetration within customer groups. The typical usage of business intelligence is to encompass OLAP, visualization of data, mining data and reporting tools.
The difference between Data warehousing and Business Intelligence mean that Finite data can be considered as discrete data. For example, employee id, phone number, gender, address etc. If data changes continually, then that data can be considered as continuous data. For example, age, salary, experience in years etc.