Multiple projects tracking on one dashboard with excel data
- Estado: Closed
- Premio: $400
- Propuestas recibidas: 6
- Ganador: amwazeindia
Resumen del concurso
I am a project manager and my team have multiple projects to handle. Projects comprises of different customer with different project creation/allocation dates, start and completion dates.
This dashboard shall be able to showcase the number of ongoing projects, project overdue/delayed.
In sample data attached, there are multiple projects (customer sites), there can be one system used at one project site or multiple type of systems use at same site.
Important details for calculation and shown in dashboard as such:
1) Number of ongoing projects
2) Number of projects delayed
3) Numbers of projects cancelled
4) Number of projects completed within 6 months/1 year (It will be good if dashboard perimeter can be changed to 3 months or any other variants). This shall be Project start day minus Project End date)
5) Number of on-going projects - days calculated till date, from project start date. Rank of the project that is taking most days and months.
6) Days between job creation date and project start date.
7) Engineers who took lesser time to start a project (project start date - job creation date)
6) Number of projects per engineer
7) Engineers ranking on days took to complete a project.
8) Total project value.
9) Individual engineer project value
Any other not shown in sample data but good to have
1) by input of project completion forecast date in a field, project value forecast can be calculated.
Other good suggestion can be provided and i will up the payment
Additional feature if this data and dashboard can be simple use on iphone for presentation.
Comentarios del empleador
“Know exactly the requirement with few details given by contest holder. Nice design and good knowledge.”