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