Forum Discussion

alalan's avatar
alalan
Frequent Visitor
4 years ago

Need Help in visualizing

Hi All, I am building HR dashboard for my organization and I have stuck at a road block and need you're wisdom to solve this. Question: I am collecting timesheet data of all employees working on ...
Need Help
Tips and Tricks
vivran22's avatar
vivran22
Community Champion
4 years ago

Hello alalan 

 

I do not think you need to create a separate table for the grouping, also the many-to-many relationship may not be helpful for filtering the fact table.

 

Is it possible to share the sample fact data/pbix file?

 

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

alalan's avatar
alalan
Frequent Visitor
4 years ago

Hi vivran22,

 

Thank you for coming forward to help. 

I am sorry, I cannot share the data due to confidentiality. 

 

I can help answering you to understand about the data structure in the fact table. 

 

Every employee works on different tasks on a particular project spending X hours. In a day, an employee works on different tasks of a project/s. The date is recorded as Trasaction date and hours are recorded as Total Hours. 

 

I have made a separate group by table from the fact table to segment employees into different OT categories. Since group by staff table is derived from the fact table it has many to many relationship. 

 

I hope this helps.