placeholder image to represent content

DAX Fridays! #173: 8 Best practices for Time Intelligence in Power BI

Quiz by Nitin Gholap

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What is the first tip for getting time intelligence calculations working properly?
    Use the date column from the sales table directly.
    Avoid using date columns from back-end tables.
    Create a calculated column for the date.
    Filter the date table to only include relevant dates.
  • Q2
    Why should you create a separate calendar table instead of using date columns from other tables?
    It improves the performance of your model.
    It ensures that the date column you use for the relationship is continuous and will not be affected by changes in other tables.
    It allows you to reuse the same date column for all of your time intelligence calculations.
    It saves you time by not having to create additional columns.
  • Q3
    What is wrong with using daytime columns as a column for the relationship from your fact table to your calendar table?
    They are difficult to maintain.
    Daytime columns compress poorly and can kill the performance of your model.
    They are not compatible with time intelligence calculations.
    They cannot be used to create hierarchies.
  • Q4
    What should be the granularity of your calendar table?
    Day level.
    Minute level.
    It can be any level of detail that you need.
    Hour level.
  • Q5
    What does marking a table as a date table do?
    It allows you to create new date columns.
    It converts all of the columns in the table to date format.
    It tells Power BI to check for errors in your date table, such as missing values or non-unique values.
    It improves the performance of time intelligence calculations.
  • Q6
    What is out-of-the-box time intelligence in Power BI?
    A set of functions that are specifically designed for working with time data.
    A way to disable time intelligence calculations.
    A hierarchy that Power BI automatically creates on all the date columns it finds.
    A best practice for time intelligence modeling.
  • Q7
    Why should you avoid using bi-directional relationships between your fact table and your calendar table?
    There is no reason to avoid using bi-directional relationships in this case.
    They can make your model more complex and difficult to understand.
    They can slow down the performance of your model.
    Bi-directional relationships can cause continuous data to disappear, which can break your time intelligence functions.
  • Q8
    What does the eighth tip recommend?
    Create separate calendars for different parts of your data.
    Make sure that the date columns you are using for the relationship between the fact table and the calendar table are compatible with each other.
    Set the data type of the date columns to text.
    Use filters to limit the date range of your calculations.
  • Q9
    What is the benefit of disabling automatic time intelligence hierarchies?
    Avoids problems with time intelligence calculations.
    Improves the performance of your model.
    Makes your model easier to understand.
    Allows for more complex time intelligence calculations.
  • Q10
    Why is it important to ensure the columns you use for relationships between tables are both date columns?
    Makes the relationships easier to create.
    Saves storage space in your model.
    Improves the data quality of both tables.
    Ensures time intelligence calculations work properly.

Teachers give this quiz to your class