Forum Discussion
Star Schema Question
Hi, I cannot seem to grasp the concept of Star Schema. Here is my very basic model at this time. I am not sure it's even enough for a Star Schema right now? I need to figure out # of HR Complai...
Unknowncharacte Let me ask you this question which will lead to the design:
- 5 complaints opened in Jan 2023
- out of 5, 2 completed in Jan 2023, 2 completed in Feb 2023 and 1 is not completed.
Overall 4 completed / 5 total = 80% completed.
Now think you are viewing this at the monthly level:
Jan 2023 - 5 complaints opened - what you want here, still 80% since you are looking at all opened in Jan which are closed doesn't matter when or which month.
How do you want to see the data at the lowest granulaity, like day/month/quarter/year?
Granularity will start on monthly level and will be aggregated up.