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...

  • BI/DW Best Practice #7 - Atomic grain base fact table
    If we are using dimensional data model, make sure to build atomic grain base fact tables. It is true that they takes more space and performs...
  • Outrigger Dimension
    It is a dimension table doesn't associate with fact table directly, but other dimension tables. We may have different scenarios to make ...
  • Extract: Performance Tips
    Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...