Designing a Project Portfolio Dashboard [Part 1 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 will focus on user needs & design. Part 2 on Excel implementation.
Background
As you may know, we sell a set of Excel Project Management templates. These templates help plan, track, manage & report a project right from Excel.
While these templates good, they have one limitation. They work for one project at a time. Many customers have asked me if I come up with a project portfolio dashboard that can tell what is going on in a set of projects in one view.
And that is where we begin.
Excel for Project Managers program is open, Please join today
My dear friends & readers of Chandoo.org,
We are so happy to announce Excel for Project Managers program for your consideration. Please read this short page to understand the benefits of this course & to sign-up. Or visit our sales page for details.
Who is this course for?
Well, I am sure you know the answer. This course is aimed at Project Managers, Business Analysts, Project Leads and people aiming for various project management roles. This course also helps project sponsors, people working in reporting & financial analysis of projects.
To enjoy this course, you should be familiar with various aspects of Excel (preferably Excel 2007 or 2010). This course is not aimed at absolute newbies of Excel.
Excel for Project Managers is coming up next Monday (14th), Details Inside…
Last week, we have announced about an upcoming online training program – Excel for Project Managers. Quite a few of expressed interest and shared ideas on how we should do this course. Finally, I am happy to announce the dates for this program and share details. Read on… Who is this program for? Well, there […]
Tell us what you would like to learn in our Excel for PMs course [Survey]
Few days ago, we announced about our upcoming Excel for PMs course. Quite a few of emailed me and told that you are looking forward for this.
Today I want to share our preliminary agenda for this course and take your help in fine-tuning it.
Commercial Aspects of Project Management
In 2005, fresh out of MBA School, I was put on managing an e-business transformation strategy project. It was then that realized that project management was a full time job (I always wondered before that why PMs were even paid a dime!). We created huge Project Management reports for the client, where were tracked and […]