Please enable JavaScript.
Coggle requires JavaScript to display documents.
DW and OLAP & BPM (Types of Data Warehouse (Operational Data Stores…
DW and OLAP & BPM
-
-
3 types of SCDs
Type 1
- Do not track changes
- Overwrites the previous dim info with the current dim info
- Impossible to determine state of the dim members in the past
- Result in inaccurate analysis
Type 2
- Track changes
- 4 supplementary attributes must be added to the dim to track history of the dim:
- SCD Original ID, SCD Start Date, SCD End Date & SCD Status
Type 3
- Do not track entire history of the dim member
- Tracks only current & original state of a dim member
- Implemented using 2 additional members: SCD Start Date & SCD Initial Value
Balanced Scorecard (BSC)
Financial, Customer, Internal Process, Learning & Growth
Columns: Strategic Map, Objectives, Measures, Targets & Initiatives
Identifying Initiatives
-
How to do it? See if an strategic objective is supported by any current initiative or not. Also, see if any initiative is supported by any strategic objective or not. If it not, it can be eliminated unless it is needed for normal operation and maintenance
3 schemas
- Star Schema (5 sides - centre: fact table)
- Snowflake Schema
- Constellation Schema (a variation of star schema)
-
Measure: is a numeric quantity expressing some aspect of the organisation's performance e.g. sales, quantity, revenue etc.
Dimension: is a categorization used to spread out an aggregate measure to reveal its constituent parts e.g. time, location dim
In snowflake schema, dimensions are normalized into multiple related tables through concept of hierarchies
In snowflake schema, foreign keys in the fact table point to the lowest level of each hierarchy
In Constellation Schema, there is more than 1 fact table
Measures & Dimensions
- Measure is a property on which calculations (e.g. sum, avg, max, min, count) can be made
- Dimension is a structure that categorizes measures in order to enable users to answer biz qns. (how you want to analyze them)
Key Components of BPM
- A set of integrated, closed-loop mgt & analytic processes, supported by technology, that addresses financial as operational activities
- Tools for biz to define strategic goals & then measure/manage performance against them
3 Types of Fact
Additive, Semi-additive & non-additive
-