![placeholder image to represent content](/_next/image?url=%2Fassets%2Fquiz_default_logo.jpg&w=256&q=75)
DAX Fridays! #173: 8 Best practices for Time Intelligence in Power BI
Quiz by Nitin Gholap
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1What 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.30s
- Q2Why 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.30s
- Q3What 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.30s
- Q4What should be the granularity of your calendar table?Day level.Minute level.It can be any level of detail that you need.Hour level.30s
- Q5What 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.30s
- Q6What 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.30s
- Q7Why 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.30s
- Q8What 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.30s
- Q9What 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.30s
- Q10Why 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.30s