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 , etc.

Business intelligence on the other hand is a set of 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, exceptions etc., Typically it is used to encompass OLAP, data visualization and data mining.

Related:

Data warehousing jobs

Data warehousing interview questions

Advertisements

One thought on “What is the difference between Data warehousing and Business intelligence

Comments are closed.