Business Intelligence: BI is a broad cateogry of applications and technologies for gathering, integrating, storing, analysing and providing access to data to help enterprise users make better business decisions. BI Applications includes the activities of decisions support systems, query and reporting, online analytical processing, statistical analysis, forecasting and Data Mining.
Datawareshousing:
Datawarehousing is a process of dimensional modeling by Extraction, Clean, Conform and Delivering to build Dataware houses which are subject oriented, time variant, non volatile.
Regards, Ravi Kumar Garre ravi_kumar_garre@yahoo.co.in
Above answer was rated as good by the following members: jayasrisan
RE: what is the difference between Datawarehousing and...
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.
RE: what is the difference between Datawarehousing and...
Hi friends
Dataware house is a relational database and it design analysis and transformation processing.
Datawarehousing is a subject oriented integrated timevarient and nonvolatile collection of the data the support and management of the decision making process.
Business Intelligence is collection of datawarehousing datamart and knoweledge.
RE: what is the difference between Datawarehousing and...
Business Intelligence: BI is a broad cateogry of applications and technologies for gathering integrating storing analysing and providing access to data to help enterprise users make better business decisions. BI Applications includes the activities of decisions support systems query and reporting online analytical processing statistical analysis forecasting and Data Mining.
Datawareshousing:
Datawarehousing is a process of dimensional modeling by Extraction Clean Conform and Delivering to build Dataware houses which are subject oriented time variant non volatile.
Regards Ravi Kumar Garre ravi_kumar_garre@yahoo.co.in
RE: what is the difference between Datawarehousing and BusinessIntelligence?
Data Warehousing: It is a process that includes the extracting the data (from source systems) cleaningtransforming and delivering them to the Data Warehouse (databases) for the loading purpose. DWH is a database which is subject oriented non volatile and time variant.
Business Intelligence: In the simplest form BI can be defined as the process of converting the information contained in the DWH into knowledge and using that knowledge for the business gain purpose.
1 
0