Companion content

Insert your email address and press Download for access to the files used in this book.
Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter)

By pressing the Download button you are agree to our Privacy Policy.

Errata corrige

To ensure the ongoing accuracy of this book and its companion content, we have reviewed and confirmed the errors listed below. If you find a new oversight, please report it to us.

  • Page 40: Fact table instead of dimension

    Replace “dimension” with “fact table” in the second-last paragraph in the page. It should be:

    In the previous example, you learned the basics of multiple fact table handling. There, you had two over-denormalized fact tables and, to make the model a better one, you had to revert to a simpler star schema. In this next example, we analyze a different scenario, again using Sales and Purchases.

    Edited on Mar 24, 2018
  • Page 79: Date in Figure 4-31

    In Figure 4-31 the date for the first row (Easter 2009) should be April 12, 2009 (it is now December 4, 2009).

    Edited on Mar 24, 2018
  • Page 193: Code error, ISBLANK should be used instead of ISEMPTY

    The right code of the PriceRange calculated column is the following:

    Sales[PriceRange] =
    VAR ResultValue =
        CALCULATE (
            IFERROR ( VALUES ( PriceRanges[PriceRange] ), "Overlapping Configuration" ),
            FILTER (
                AND (
                    PriceRanges[MinPrice] <= Sales[Net Price],
                    PriceRanges[MaxPrice] > Sales[Net Price]
        IF ( ISBLANK ( ResultValue ), "Wrong Configuration", ResultValue )

    In the paragraph after the code sample the function name ISEMPTY must be replaced with ISBLANK.

    Edited on Sep 28, 2018