- 08/01/2019 at 2:59 pm #416141
Our team developed a homegrown dashboard which directly imports from MSProject into excel, but it takes alot of work to create, update and maintain.
The metrics include by project name – % of tasks complete, # of tasks at different states/kanban, gantt chart high level, # of risks and issues opened….
Is there a third party offering that provides a dashboard sourced from MS Project?08/22/2019 at 10:48 am #416310
All the metric elements can be easily done with a copy and paste operation from a defined view in MSP into an excel sheet. Then you can have a second sheet which does all the calculations and presents the results. In this way the only “operation” is a simple copy and paste.
The Gantt chart is harder – if it is truly simple, one-item-per-line you could use a stacked chart to make a Gantt chart however if the desired picture is more complex then this will not work. Alternatives would be to make a view in MSP which shows what you want and then copy and paste it into your “display” sheet.
I use SummaryPro to make simple to maintain “plan on a page” summaries but that’s not surprising as this is what I developed it to do. It can’t make charts etc showing % of tasks delivered – I would always use the method show at the head of this reply for that.
A more advanced option is to look at something like PowerBI to reach into the MSP database and do all the data manipulation which will have the advantage that you will be able to provide greater flexibility is terms of what is displayed on the dashboard allowing your users to dig into the data in more details however it will not do a complex Gantt view…
Miles09/13/2019 at 5:56 am #416517
Deltek’s Acumen Fuse might be a good alternative.