What is the difference between data warehousing and business intelligence? - Data warehousing

What is the difference between data warehousing and business intelligence?

Data warehousing relates to all aspects of data management starting from the development, implementation and operation of the data sets. It is a back up of all data relevant to business context i.e. a way of storing data.

Business Intelligence is used to analyze the data from the point of business to measure any organization’s success. The factors like sales, profitability, marketing campaign effectiveness, market share and operational efficiency etc are analyzed using Business Intelligence tools like Cognos, Informatica, SAS etc.

What is the difference between data warehousing and business intelligence?

Business Intelligence: BI is a blend of technologies and applications for gathering, integrating, storing, analyzing and providing the access to the data to enterprise uses for better decision making in an enterprise. BI is a combination of decision support system, online analytical processing, query and reporting, statistical analysis, forecasting and data mining. BI is a group of collection for knowledge and data mart and data warehousing.

Data warehousing: Data warehousing is all about dimensional modeling by extraction, conform delivering for building data warehouse that are subject oriented, non volatile and time variant.

Data warehouse is a RDBMS. It designs analysis and transformation processing.
Describe dimensional Modeling - Data warehousing
Dimensional modeling is a design concept which is used by designers of building data warehouses. The data is stored in two types of tables...
What is snapshot with reference to data warehouse? - Data warehousing
Snapshot refers to a complete visualization of data at the time of extraction. It occupies less space and can be used to back up and restore data quickly...
Data warehousing: What is Data warehousing?
What is Data warehousing? - A data warehouse can be considered as a storage area where interest specific or relevant data is stored irrespective of the source...
Post your comment