Project Management

Please login or join to subscribe to this thread

Dashboard Reporting on a Program with over 50 IT projects.

linkedin twitter facebook   Governance   PMO  
avatar
Nelly Tio IT Team Leader| Canada Revenue Agency Ottawa, Ontario, Canada
Hello,

Does anyone have any suggestions or sample/examples of how to dashboard report for sr management on a program with 50-100 IT projects using Excel or MS Project? Our organization has implemented project gating, and the dashboard must show the progress by gates rather than phases.

Thanks
Sort By:
< 1 2 >
avatar
alan rossney Project Manager| jacobs Engineering Dublin, Dublin, Ireland
Dec 18, 2015 2:03 PM
Replying to Nelly Tio
...
Thanks.

Alan - Can you give me more info on web accessible spreadsheets?
I was thinking of a simple dahsboard tabling KPI's for each of the projects.Excel will allow sorting and filtering by any column. I was thinking it could be posted on an internal sharepoint page where multiple PM's could check out the file, update and check back in. But, this could be done (without checkin/out facility) at any network location or intranet page on an internal web server. If you talk to your IT crowd they may be able to make the spreadsheet accessible on a server that has broad access....hope that help
avatar
Sergio Luis Conte Helping to create solutions for everyone| Worldwide based Organizations Buenos Aires, Argentina
I am in the same environment like you, using stage gate governance model. We use xcell spreadsheet in the past and now we are using a centralized PPM tool that generates Business Object reports. I was in charge to change the reporting system (the first one) when I start working in my actual company. The first thing I did (because I am an old man so I have a lot of experience seing towers of papers inside top management people offices) is trying to understand our stakeholders by making an stakeholder analysis to create an environment where "what you need is what you get". If was not easy but it had great result in terms of customer satisfaction. We publish information for more than 250 projects.
< 1 2 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"The purpose of art: to make the unconscious conscious."

- Richard Wagner

ADVERTISEMENT

Sponsors