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.

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 (http://blog.SQLAuthority.com) , SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download

About these ads

3 thoughts on “SQL SERVER – Business Intelligence (BI) Basic Terms Explanation

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

    Like

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s