Project Portfolio Analysis and Reporting Capability Using MS Project Data

I am looking for a solution that provides multi-project  analysis and reportiing capabilities using Microsoft Project Server 2007 data files, similar to what is available in Primavera.  This involves opening multiple projects, up to and including the entire portfolio (currently between 20-30 projects, and 20K to 30K total number of tasks) and performing analysis based in selected critieria, based on changing business needs.  For instance, reviewing Mechancial Engineering tasks for all projects, analyzing projects assigned to a specific Project Manager or evaluating the impact of future (i.e. potential work) on the portfolio.  Note: Although it would be ideal to achieve this functionality using MS Project, an Add-in appication or even a solution separate from MS Project (i.e. exporting MS Project data to another application) is under consideration as long as we get the functionality that we are looking for.  Any ideas or expereiences, good or bad?  

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts