Analysis information modeling chapter 6

ACFM 329

7 types Algorithm

1. within table numeric calculation

2. within table text calculation

3. within table classification

4. across table calculation

5. single column aggregation

6. filtered aggregation

7. measure hierarchy

Fact/transaction/event

Dimension: who/when/what

What is information modeling

Generating additional knowledge

Algorithm

Link the input of facts and the output of useful information.

Data (input) for one application can also be information (output) for another application

can be complex or simple

Calculated column

are those values that are calculated for each cell in the column (per record)

Measure

An aggregate 

Structured approach

Two goals of Creating measures and Dimensions

1. to create rich set of measures for the fact table

2. to create a rich set of dimensions

Dimension Tables

can describe specific characteristics of transactions: who participated, what was involved