GMC
New Member

Hello Everyone
I'm a newbie to the forum so here is a big Hello from Scotland -
The image above reads "Ceud Mile Failte" which in Gaelic means - One Hundred Thousand Welcomes
I work in IT and we have a daily report of all tickets that gives the number of hours of work that an analyst may have on a daily basis. Each ticket they have has an allotted time with it, so when the analyst completes the ticket they log the time it took them so I can report on this.
What i cannot do in excel is report on the demand v the capacity.
My company is pushing for ALL reports to be integrated with Power BI, so my manager has given me a task to create a Resource Utilization dashboard using this excel data so that we can easily see how much work has been allocated to an analyst and how much spare capacity they may have in that day/week.
We have over 100 analysts over different regions /timezones
I have watched many online tutorials and enrolled in 2 PBI Bootcamps but I cannot get a resolve to this query. If it helps anyone, I have seen exactly what I need on 1 of the tutorials however this was for a US medical centre and was an internal guide on how to use it but not how to build it.
I have reached out to them but it was a "no go". You can see the video here
I was wondering if:
1. any one can provide any guides on preparing such a report on PBI
2. there is any PBI/template that i can use and is available
Thank you so much in advance for your help.