Since more than 1 year I’m following EnterpriseDNA (meanwhile becoming a member to support this excellent platform).
I’m using Excel, PowerBI, PowerQuery…on a daily basis. I’m (normally) also familiar with creating effective data models (dimension -> fact tables).
But this time I’m a bit lost.
I have 3 dimension tables:
- Sites (Address data of construction sites)
- Employees (personal data)
- Degrees (well…degrees)
and mainly 1 facts table:
- SiteHrs (holds data of employees’ hours worked on Sites)
So far so good, BUT…
the hourly rates depend on the employee’s degree.
And this can change over time (one always starts as a beginner, than becomes advanced and finally ends up being a master). So there is a time dependancy.
I cannot integrate the table HourlyRates (See screenshot) into my model.
I’m thinking now about this since 2 days and no solution will come to my mind…
Every hint is welcomed.