EPM Team

The Catapult EPM team is responsible for delivering Microsoft project and portfolio management solutions. Their blog reflects team insights and real-world experiences developing world-class EPM solutions.
RSS Feed
Jul19

Two Cool Blog Posts For Today

I wasn’t planning on pushing anything out today, but a couple of really good blog posts on Project desktop caught my eye, and I wanted to make sure you all saw them:   1) Dale Howard from MS Project Experts on deploying the default 2000-2007 macros to Project 2010.  These macros have always been underused and underappreciated, but the Format_Duration macro has saved my project plans on many o...
Posted by Andrew Lavinsky on Monday, 19 Jul 2010 03:52.
0 Comments | Categories: Project Professional 2010

 
Jul11

Project Server At Houston Techfest 2010

Looks like I’ll be speaking on Project Server at the Houston Techfest on October 9, 2010.  (More Information)  We’ll see if that MVP designation makes everyone think I am smarter – or if it just unreasonably raises their expectations.  The event is free, so I can definitely guarantee that if you attend my presentation, you will at least get what you paid for. Hope to see some of you there…...
Posted by Andrew Lavinsky on Sunday, 11 Jul 2010 10:01.
0 Comments | Categories: Gratuitous Self-Reference, Project Server 2010

 
Jul11

Portfolio Analysis Under the Hood: Developing the Scatter Chart

This is the next post in a series describing how the Portfolio Analysis pieces of Project Server 2010 work under the hood.  This post will discuss how the Scatter Chart is calculated and provide an Excel model for assessing how it works.  I wrote this post as part of an exercise to make sure that I understand what’s going on in Project Server – as well as making an initial attempt to lay the pi...
Posted by Andrew Lavinsky on Sunday, 11 Jul 2010 09:49.
0 Comments | Categories: Portfolio Management, Project Server 2010

 
Jul7

Portfolio Analysis Under the Hood: Calculating Strategic Alignment

This is the next post in a series describing how the Portfolio Analysis pieces of Project Server 2010 work under the hood.  This post will discuss how the Strategic Alignment chart is calculated and provide an Excel model for assessing how it works.  I wrote this post as part of an exercise to make sure that I understand what’s going on in Project Server – as well as making an initial attempt t...
Posted by Andrew Lavinsky on Wednesday, 7 Jul 2010 08:05.
0 Comments | Categories: Portfolio Management, Project Server 2010

 
Jul2

Portfolio Analysis Under the Hood: Calculating the Efficient Frontier

This is the next post in a series describing how the Portfolio Analysis pieces of Project Server 2010 work under the hood.  This post will discuss how the Efficient Frontier is calculated for a portfolio of projects.  I wrote this post as part of an exercise to make sure that I understand what’s going on in Project Server – as well as making an initial attempt to lay the pieces out in a way tha...
Posted by Andrew Lavinsky on Friday, 2 Jul 2010 08:57.
1 Comment | Categories: Portfolio Management, Project Server 2010

 
Jul1

We Interrupt Your Normal Programming….

Well, a very pleasant surprise this afternoon when the plane landed and I checked my e-mail.  Lo-and-behold, it would appear as though I now can add three more letters to the IT alphabet soup already on my name card.  I am very excited about this.  To keep things in perspective, my kids couldn’t care less & my wife suggested I celebrate by mowing the lawn. Thank you everyone for the ongo...
Posted by Andrew Lavinsky on Thursday, 1 Jul 2010 08:18.
3 Comments | Categories: Project Management, Project Server 2010, Gratuitous Self-Reference

 
Jun28

Portfolio Selection Under the Hood: Forcing Projects In or Out

This is the next post in a series describing how the Portfolio Analysis pieces of Project Server 2010 work under the hood.  This post will discuss how portfolios are impacted by forcing in or out specific projects.  I wrote this post as part of an exercise to make sure that I understand what’s going on in Project Server – as well as making an initial attempt to lay the pieces out in a way that ...
Posted by Andrew Lavinsky on Monday, 28 Jun 2010 10:33.
0 Comments | Categories: Portfolio Management

 
Jun25

Portfolio Selection Under the Hood: Managing Cost Constraints

Here is the next post in my series describing how the Portfolio Analysis module works in Project Server.  I wrote this post as part of an exercise to make sure that I understand what’s going in Project Server – as well as making an initial attempt to lay the pieces out in a way that my clients would understand.  My goal is to develop an Excel-based model that takes the same inputs as Project Se...
Posted by Andrew Lavinsky on Friday, 25 Jun 2010 11:02.
0 Comments | Categories: Portfolio Management

 
Jun24

Excel Based Portfolio Optimizer Simulation v1 Release

DISCLAIMER: (Just to make sure this is clear, I am adding this disclaimer to the posting.)  The worksheet referenced below is not a competing product to Project Server 2010, and does not contain references to any proprietary code.  It was developed based on publicly available information as an Excel mock up of the server-side portfolio optimization calculations found in Project Server.  The g...
Posted by Andrew Lavinsky on Thursday, 24 Jun 2010 07:42.
5 Comments | Categories: Portfolio Management

 
Jun19

Pairwise Analysis Revisited

In my previous post, I gave an example of how Pairwise Analysis works, and presented a conceptual model in Excel of the driver and project prioritization engine within Microsoft Project Server 2010.  That model worked well with simple driver prioritization scenarios, but seemed to display a wide variance with Project Server calculations in more complex scenarios.  This left me unsatisfied, and ...
Posted by Andrew Lavinsky on Saturday, 19 Jun 2010 09:04.
1 Comment | Categories: Portfolio Management, Project Server 2010