Business Intelligence
Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it did, to decide on courses of action based on past data, and to accurately forecast future results.
Data Warehouse
A single structure that usually, but not always, consists of one or more cubes.
Data Mart
A defined subset of a data warehouse, often a single cube from a group. It represents one business unit.
Cube
A storage structure used by classic data warehousing products in place of many. Cube usually present data that is aggregated, rather than each individual item. Cubes present a summarized, aggregated view of enterprise data, as opposed to normalized table sources that present detailed data.
Decision Support System
The term’s broad definition can mean anything from a read-only copy of an online transaction processing (OLTP) database to a group of OLAP cubes or even a mixture of both.
ETL
ETL is abbreviation of Extraction, Transform, and Load.
OLAP
OLAP is abbreviation of online analytical processing.
OLTP
OLTP is abbreviation of online transactional processing.
Reference : Pinal Dave (https://blog.sqlauthority.com) , SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
3 Comments. Leave new
Hi,
I’m interested by your definition of BI. I’ve found the same quote in a BI book and that says it’s quoting from MS. I can’t find the quote on the MS site. Is that where you got it from?
Thanks for your help
Tim
I would like to find more information about calling MS Analysis Services (2005) cubes from within Coldfusion 8. Have you ever done it?
I program for the US Army.
Thanks,
Larry
Definition for SQL BI is perfect.