I am looking for information in the same area. I would love to have a dashboard that shows resource capacity etc. Have you been able to make any progress?
I have made some progress with this. I am in the process of finalizing our data set up and dashboards that will enable us to see our resource pool for project work, assigned projects, and available hours.
We set up an excel spreadsheet that has a few tabs, I should note that we use HP's PPMC product for time tracking and we export reports from it to give us actual hours tracked to projects and work. So our excel is set up with a tab for "Assigned hours," "Available hours," and "Actuals Hours_[month]."
On the Assigned Hours tab we have configured that each assigned resource has a row in the workbook that shows their time forecast to the project and hours for each month over the year. We include a bunch of other description-based stuff such as what their role on the project is, project start/end dates, and type of work etc.
The Available Hours tab lists all our resources, the department they sit in, their job titles/roles, and then their available hours per month (which is a straight forward calculation of 8 hrs per day * Business Days in the month). I think we could likely due without this tab and create a table calculation but I'm not sure about how to do that yet, so for now this method works. In order to gain a truer sense of availability we are using the "Assignments" tab to also "assign" vacation time and time spent on non-project work that would reduce a resource's availability.
From the data in these two tabs I'm able to create bar on bar charts in tableau to show resource availability, distribution of work, and types of work etc. When I pull in the actual hour tabs for each month I can then create visualizations on utilization and how we did with our forecasting.
It's not perfect, but it's a start for us. Once I have it up and running I can share the set up.
I know this is an old thread, but was wondering what your finalized dashboard looked like?