iOLAP Training | Business Intelligence Terminology

iCenter login

company

services

products

training

contact

Business Intelligence Terminology


		Data Warehousing
		BI Terminology





		iOLAP Sevices

		iOLAP Products


		iOLAP e-Newsletter


		Contact Us

		Request a Quote

		Schedule a Demo



		Get Answers Fast


Send this page to a friend


home > training > bi terminology

Terminology

A - D | E - H | I - L | M - P | Q - T | U - Z

Market Basket
A specific type of analysis that is focused on how multiple items within a single purchase experience (Market Basket) relate to one another. (Example: How often do people who purcahse diapers also purchase beer?).

Metadata
Data used to describe the properties of other data.

Metric
A numeric expression that is displayed on a report and is comprised of Facts and mathmatical functions.

MOLAP
Multi-dimensional Online Analytical Programming is an OLAP strategy that stores pre-summarized data in a propriatary file or “cube” structure instead of a relational database.

Natural Key
A strategy of using meaningful codes as your primary database table keys as opposed to using artificial or Surrogate keys. (Example: Defining primary key for day attribute using date/time data types.)

Normalize
Breaking out a data structure into mulitple tables by removing redundancy. (Example: Seperating a single Denormalized time reference tables that includes Year, Month and Days into three tables.)

Operational Data Store (ODS)
Typically a copy of a transactional or operational database struture that contains only current or near term data. Often used to stage data prior to processing into a Data Warehouse.

Partition
Strategy of breaking a single relational database table along a specific Attribute into multiple smaller tables to reduce the size of the data-set queries must process against. (Example: Splitting a single table of year sales data across twelve tables of monthly sales data.)

Physical Data
Model Physical Data Models graphically represent your relational database structure including all tables, columns, relationships, keys and indexes.

Primary Key
One or more columns in a table that contians values used to uniquely identify each row or record in that table.

Project
Highest level of intersection between data warehouse, metadata repository and user community. It contains reports, metrics, filters, and functions.

Back Next