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

  • What is Fact Table?
    Fact table stores the measures of the business process event and associates them with the descriptive context (dimension tables). So, there ...
  • Constraints and indexes of Fact and Dimension Table
    We usually implement the multi-dimensional data model in RDBMS or CUBE. Today, we focus on the Constraints and indexes in multi-dimensional ...
  • Different file encoding and formats
    Our ETL program need to handle different format and encoding coming from different sources. Below listed some common technical challenges. E...