H
Hung
Hi,
We had a project server with all the projects from different groups.
We can conduct some queries against the whole database to get the data
directly for our report.
The question is: from the director level, what should we prepare and extract
to see if all project are in good progress or not and how their target finish
has been updated comparing to last week? This is regardless their PM update
or not their plans in Project professional.
Say it in another way, our boss wants to see the list of projects that were
late from their last week schedule and/or if the finish dates were changed.
We planned to obtain this by:
- Saving a baseline weekly (say every Friday) for all projects directly in
Project server using a store procedure to read the database and write into a
baseline
- Then everytime the boss wants to see the progress, then run the report to
query the main milestones and compare the value of last week baseline
against current dates and/or the change in completion %.
Is there any better way to do that?
Thanks
We had a project server with all the projects from different groups.
We can conduct some queries against the whole database to get the data
directly for our report.
The question is: from the director level, what should we prepare and extract
to see if all project are in good progress or not and how their target finish
has been updated comparing to last week? This is regardless their PM update
or not their plans in Project professional.
Say it in another way, our boss wants to see the list of projects that were
late from their last week schedule and/or if the finish dates were changed.
We planned to obtain this by:
- Saving a baseline weekly (say every Friday) for all projects directly in
Project server using a store procedure to read the database and write into a
baseline
- Then everytime the boss wants to see the progress, then run the report to
query the main milestones and compare the value of last week baseline
against current dates and/or the change in completion %.
Is there any better way to do that?
Thanks