25-09-2013, 03:47 PM
BUSINESS INTELLIGENCE
BUSINESS INTELLIGENCE.pptx (Size: 158.47 KB / Downloads: 12)
What is Business Intelligence?
The new technology for understanding the past & predicting
the future …
BI is broad category of technologies that allows for
• gathering, storing, accessing & analyzing data to help business users make better decisions
• analyzing business performance through data-driven insight
What is Business Intelligence?
It provides historical ,current and productive view of business operation.
The goal of modern business intelligence is to support better business decision-making , Thus it called decision support system(DSS).
ETL tools
ETL tools (Extract, Transform, Load) are used to pull data from source database, transform the data so that it is compatible with the data warehouse and then load it into data warehouse.
DATA WAREHOUSE
A Data Warehouse is a "Subject-Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making". Data Warehouses tend to have these distinguishing features: (1) Use a subject oriented dimensional data model; (2) Contain publishable data from potentially multiple sources and; (3) Contain integrated reporting tools.
DATA MART
The emphasis of a data mart is on meeting the specific demands of a particular group of knowledge users in terms of analysis, content, presentation, and ease-of-use. Users of a data mart can expect to have data presented in terms that are familiar