• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Resource Utilization Dashboard

GMC

New Member
84031
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.
 
View attachment 84031
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.

Hope you are doing well,

I'm interested in the same Dashboard above, did you manage to purchase it?

KR
 
View attachment 84031
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
coreball
Thank you so much in advance for your help.
I'm also looking to buy this console. Please give me more information.
 
Back
Top