Dimensional Data Modeling - Metrics - Key Performance indicators (KPI)

Star Schema


A (performance) metric is an calculated and aggregated measure of activities of:

Metrics are numeric values.

A metric gives a way of quantitatively and periodically measuring, assessing, controlling or selecting.

It has standard unit such as :

  • meter or mile for length,
  • or gram or ton for weight,
  • or systems of measurement,

Metrics Soup

In Business Intelligence, Metrics or KPI ?

In a Business Intelligence context, metrics are often referred to as :

  • key performance indicators (KPI)
  • key quality indicators (KQI)

One difference that we can made between metrics and KPI is that:

  • a metric is a measure of business activity.
  • whereas the key performance indicator (KPI) are the most important and relevant metrics often associated with a target.

Data Rule and Metrics

A data rule is like a metrics definition. It is an indicator, so you should create data rules that are important things to measure with regards to the business strategy (KPI), to the data quality (KQI), …


  • Roce
  • Roi
  • Customer loyalty
  • Profitability
  • Short and long term performance

to define action such as Investissement on:

  • new product
  • process
  • it
  • human
  • market
  • customer

Cobra effect when settings goals

You are exposed to the Cobra effect when you set objectives, and in particular when you choose indicators to measure the achievement of these objectives.

For example, if we choose to measure the effectiveness of customer support by looking at the number of telephone calls made, we encourage the employees who do the support to spend less time per call… and not to solve the problems that submitted to them by customers.



Discover More
CSS - Relative Sizing (Length)

Relative Sizing is when you are using a length units that is relative to another length property. Style sheets that use relative units will more easily scale from one medium to another (e.g., from a...
Card Puncher Data Processing
Dashboard and Analytics

A suite of products which help users track and analyze key business metrics via management dashboards, scorecards, and alerting. These products allow goals to be set around metrics and assigned to owners;...
Data System Architecture
Data Analysis - Reporting Query

Reporting queries are query: executed periodically to create well-known, pre-defined metrics that will answer questions the financial and operational health of a system (business). Although...
Dataquality Metrics
Data Quality - Metrics

Very often these metrics are named dimension but it is an abuse language, it acts rather in a dimensional model as attribute of the data rules. Timeliness refers to the time expectation for...
Utah Teapot
Data Visualization - Balanced Scorecard / Tableau de Bord

The Balanced Scorecard is a performance management framework. Design of a Balanced Scorecard ultimately is the identification of a small number of financial and non-financial measures and attaching targets...
Lie Factor
Data Vizualisation - Metrics to measure the quality of a Graphic

This page shows some metrics that can be calculated on a graphic in order to scan their pertinence. Low is bad High is good Good interval is:
Data System Architecture
Data Warehouse

A data warehouse is a large central data repository of current, history and summarised data coming from operational and external sources used primarily for analysis. s is large historical databases for...
Star Schema
Dimensional Data Modeling - Measure

In a dimensional model, a measure is a quantitative attribute of a fact (in a fact table) that is not a foreign key that creates a relationship to a dimension. A measure permits to quantify. A calculated...
Card Puncher Data Processing

(CREATE, ALTER, DROP) (GRANT, REVOKE) (SELECT, UPDATE, INSERT, DELETE) (COMMIT, ROLLBACK) NLS (National Language Support) UDML is the abbreviation for Universal Database Markup Language ...
Data System Architecture
Logical Data Modeling - Additive Attribute

An additive attribute is an attribute with a numeric value that can be logically added (You can therefore aggregate over) In dimensional data, the most command additive attribute are called measure...

Share this page:
Follow us:
Task Runner