DW - Data Warehousing & Modeling

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 construction of a partial system to demonstrate some aspect or aspects of the intended system behavior in order to gain user acceptance or to establish technical feasibility.  

Pivot table

Pivot tables enable you to look at data from several dimensions. Such capability is provided in numerous decision support applications under various function names. For example, in a spreadsheet or database, a pivot table provides these views and enables quick switching between them.

Percentage of total

Displaying data in a table as a percentage of that particular data’s total, using the percentage (%) of row and percentage (%) of column calculation. 
For example, a user can summarize ‘Sales in a specific region’ as a percentage of ‘Total Sales.’


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.

Master Data Management

Master Data Management (MDM) is a set of tools and processes that aim to deliver a single clean and consistent view of each master data entity (product, customer, employee, financial accounts, etc.) that exists within the organization


Levels are an implementation of the hierarchies that represent the level of detail viewed in a dimension. As an example, for a time dimension hierarchy, we have levels for year, quarter, and month.

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.


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