SQL SERVER – Business Intelligence (BI) Basic Terms Explanation

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.

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 is abbreviation of Extraction, Transform, and Load.

OLAP is abbreviation of online analytical processing.

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

Business Intelligence, Data Warehousing
Previous Post
SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
Next Post
SQL SERVER – Importance of Master Database for SQL Server Startup

Related Posts

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


  • Larry Thomas
    May 7, 2008 8:37 pm

    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.



  • Definition for SQL BI is perfect.


Leave a Reply