Data Warehouse & Data Mining for Microsoft related products

ETL Tools: IBM Datastage

Informatica PowerCenter

Teradata ETL Automation

OLAP (On-line Analytical Processing)

Microsoft related products: SSAS

Olap--rolap--molap

Related (to find):

OLAP (On-line analysis processing) is a kind of software technology that enables analysts, managers, or executives to access information quickly, consistently and interactively from multiple perspectives to gain a deeper understanding of the data.

The goal of OLAP is to satisfy the decision support or meet the specific query and report requirements in multidimensional environment, and its technical core is the concept of "dimension".

"Dimension" (dimension) is the angle that people observe the objective world, and it is a kind of high-level classification. "Dimensions" generally contain hierarchical relationships, which can sometimes be quite complex. By defining several important attributes of an entity as multiple dimensions (dimension), the user can compare the data on different dimensions. Therefore, OLAP can also be said to be a collection of multidimensional data analysis tools.

Basic Multidimensional Analysis operations for OLAP include drillthrough (roll up and drill down), slices (slice) and dice (dice), and rotation (pivot), drill across, drill through, and so on.

* Drill-through is to change the dimension of the level, transformation analysis of granularity. It consists of an upward drilling (roll up) and a downward drill (drill down). Roll up is a dimension that summarizes low-level detail data to a higher level of aggregated data, or reduces the number of dimensions, while drill down is the opposite, from summarizing data to detail data to observing or adding new dimensions.

* Slices and cubes are concerned with the distribution of the metric data on the remaining dimensions after selecting the value on a portion of the dimension. If the remaining dimension is only two, it is a slice; if there are three, it is diced.

* Rotation is the direction of the transformation dimension, that is, rearranging dimension placement (for example, row and column swaps) in a table.