DW - Data Warehousing & Modeling


Alerts and notifications refer to any automated signals or short messages that may be sent through a SMS, an email or an indicator in a dashboard or report. They are a call to action after a specific event has occurred. They are also used to assign tasks or inform the recipients about certain urgent issues. Alerts can be the result of the outcome of a report or specific queries.

Role-based security

A role-based security is a user-level security feature that allows you to restrict access to a certain feature in the system based on the user role.

In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks.


Ranking is the process of positioning items such as individuals, groups or items on an ordinal scale in relation to others.

A ranking can be obtained by evaluating each item in the collection in such a way that any two items can then be compared to see which should come higher in the ranking. Obviously, two different objects can have the same ranking.


The state of a database when all repeated values within the database have been removed by creating more tables. Relational OLTP systems are usually highly normalized. Data warehouses typically are not highly normalized.

Normalizing data is a process defined by E.F. Codd and boils down to structuring the data into separate and multiple tables to avoid redundancy in the data.

Information discovery

Information discovery denotes the middle section of enterprise Performance Management and Data Services. It allows decision-makers to access, navigate, analyze, format and share information within the organization. It primarily comprises the Business Intelligence platform, the components of query and analysis, as well as reporting and dashboarding functionalities.

Dimensional hierarchy

A dimensional hierarchy denotes how data is organized at various levels of aggregation. An analyst uses a dimensional hierarchy to identify various trends at one level, drill down to lower levels to detect causes for these trends, and roll up to higher levels to see the effects the trends have on the whole business.


This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment.

Data Quality

Data quality pertains to aspects such as availability, completeness, accuracy, consistency, relevance and timeliness of data. High data quality is essential to business intelligence’s role as a means of decisional support.

Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems.


S'abonner à RSS - DW - Data Warehousing & Modeling