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

  • 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 #12 - Manage data integrity
    The data warehouse / data mart are usually implemented in RDBMS. RDBMS provides lots of features to manage data which are useful for both op...
  • Audit Dimension
    In traditional data modeling, we usually add "created date", "last modified date", "created by" and "last...