DW - Data Warehousing & Modeling

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

Data scientist

A data scientist is a job title for an employee or business intelligence (BI) consultant who excels at analyzing data, particularly large amounts of data, to help a business gain a competitive edge. To do so, the employee is using statistical & data mining techniques.

Data Mashup

A data mashup is the integration of heterogeneous digital data from multiple sources for business purposes.

Data Latency

Data latency, in a data warehouse context, is the time between the creation of data in a source system and the exact time at which the same data is available for end users on the business intelligence platform.


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.

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.


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