Bi-kipedia Measure or metric A measure is a numeric expression, which can be used and displayed –by dimension- on reports and consist of base facts, aggregated values or mathematical functions. Jeudi, 17 juillet 2014
Bi-kipedia Fact table A fact table contains all numeric information for one single business process in context of multiple related dimensions.eg. a sales fact contains number of sold quantities, revenue, margin, etc. The granularity is ideally kept as low as possible in order to enable a variety of reports and analyses. Jeudi, 17 juillet 2014
Bi-kipedia Base table A base table is a synonym for a fact table. It contains data stored at the lowest level of detail. In this way the information can be combined with a multitude of dimensional information. Jeudi, 17 juillet 2014
Bi-kipedia Dimension table The attributes in a dimension table describe all the different specific properties or characteristics of this dimension. Most often -in a star schema- the dimension tables are de-normalized. Jeudi, 17 juillet 2014
Bi-kipedia Granularity Granularity is the level of detail at which the numerical data is stored in the fact tables within a data warehouse. Jeudi, 17 juillet 2014
Bi-kipedia Slice and dice The act of browsing the data using all different combinations of dimensions with the help of an OLAP tool in order to see the corresponding values or measures. Jeudi, 17 juillet 2014
Bi-kipedia OLAP - Online Analytical Processing OLAP stands for On Line Analytical Processing. OLAP tools offer the possibility to look at the data in a multi-dimensional way. It gives users the power to analyze data from different angles (dimensions) quickly, as aggregates are often precalculated and stored. Interacting with data through the use of OLAP tools is also known as "slice and dice”. Jeudi, 17 juillet 2014
Bi-kipedia Data cleansing - data cleaning - data scrubbing The process of cleaning up the data before loading them into a data warehouse by removing errors, incomplete information or inconsistency between sources. Jeudi, 17 juillet 2014
Bi-kipedia Data integrity Data Integrity stands for the process that guarantees quality, reliability, outcome, trustworthiness, stability and consistency of the data. Jeudi, 17 juillet 2014
Bi-kipedia Data Vault This is one method in which a database or data warehouse can be designed. Data sourced from different operational systems is stored in such a way that it can be completely traced in term of history. In the data vault architecture you can have three basic entities: hub, link and satellite. Jeudi, 17 juillet 2014