I need an excel expert to build Resource Capacity vs Demand Dashboard

I am working on creating a capacity model for my team. Its number of hours that each resource is working on for each task in a month. I need capacity vs demand for each of the resources , by month, by quarter. I can get on a quick call to explain the attached excel sheet that I have created so far, it has the basic dashboards I have built so far, but need help to build better visuals.

I need to create a capacity model for our project team. I already have a version of it ready but I am not satisfied with it.


1. Create a dashboard of team capacity vs Demand by quarters.(this needs rework, I have a version of this dashboard, and will show you what I expect it to look like, I have an example dashboard)

2. Create a view showing demand by quarter across whole team

[login to view URL] a view showing capacity by quarter across whole team

Since most of the work is already done, I expect the project to be finished within 1 day( but for an excel expert it should not take more than a few hours to complete this)

We will need to get on a call to discuss once, so I can clearly communicate my needs.

Habilidades: Processamento de dados, Gestão de projetos, Excel, Agendamento de Projeto, IT Project Management

Sobre o Cliente:
( 0 comentários ) Jersey City, United States

ID do Projeto: #33133276

Concedido a:

(29 Comentários)

10 freelancers estão ofertando em média $116 nesse trabalho

(175 Comentários)
(60 Comentários)
(103 Comentários)
(5 Comentários)

Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right now and can assure the best service from my end. Waiting for your good respo Mais

$30 USD in 2 dias
(0 Comentários)

I have 10 Years Experience in IT and work as IT Professional Hopefully it will be bitter for both me and Your company to give this opportunity to me please Inform me Through chat for Further Details.

$100 USD em 1 dia
(0 Comentários)

hello, I have extensive experience in more than eight years working actively in the area. I currently manage several projects and would like to help you on this one as well. I work with seriousness and efficiency. co Mais

$95 USD em 1 dia
(0 Comentários)

Hi David, I will build a dashboard and provide you with a satisfactory dashboard. I am a certified data analyst skilled in excel,power bi, tableau and sql. I’ve worked on several similar projects. I can deliver quality Mais

$200 USD in 5 dias
(0 Comentários)

Hi, I checked your requirement, I am Expert in Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dynamically with VBA Codes. Knowledge About J Mais

$200 USD in 2 dias
(0 Comentários)