Monday, September 28, 2020

BI/DW Best Practice #13 - Keep measures additive if possible

BI tools rollup the measures, so we keep the measures additive if possible. For example, we won't pre-calculate and keep the KPI "Unit per Transaction (UPT)" in single measure column as a ratio. Instead, we keep two measures, "Number of Units" and "Number of Transactions".

at
Labels: , ,
Location: 加拿大艾伯塔卡加利

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Extract: Performance Tips

Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...

  • Factless Fact Table
    Factless fact table is the fact table which log an business event but does not contain any measure fields. Typical use cases are the attenda...
  • Consolidated Fact Table
    Transactional Fact and Snapshot Fact tables are usually designed from the corresponding individual business process. Consolidated Fact table...
  • BI/DW Best Practice #10 - Handle unknown and null
    NULL columns sometime give unexpected query results to users in user point of view. It happens in filtering (i.e.  condition [COLUMN1 = 0 or...