Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
Help me please to decide which approach is better for model performance and an easy way to analyze data for the contact center.
Separate date time column and create date integer key and time integer key in fact table , after that connect these keys to separate dimDate and dimTime tables? Won't this approach complicate analyses (slow and complicated measures)?
or leave one DateTime column fact table as is?
Working hours, login time, etc. have to be calculated for each person and aggregated.
Thank you in advance for you answers and explanations!
The literature says to use separate date and time calendar tables to reduce the cardinality. Even with the added measure logic overhead that is still significantly faster than if you had to deal with a datetime calendar table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |