Il est bien plus beau de savoir quelque chose de tout que de savoir tout d'une chose. [Blaise Pascal]

How Microsoft Project Server calculates Business drivers priorities

8 comments
As part of a series of articles I wrote on Portfolio Analysis within Microsoft Project Server 2013, there is another topic I was interested to understand. How Microsoft Project Server calculate business drivers prioritization.
To highlight this, I will reuse business drivers I have defined previously for my article on the EfficientFrontier:
  • Expand revenue of the Bobby Brown product line
  •  Increase product awareness among people between 13 and 18
  •  Increase the number of members of the VIP club
  • Introduction of new premium products
  • Reduce employee turn over
  • Reduction of support call waiting time

There are within Project Server 2013, two ways to prioritize business drivers:
  •  A “Calculated” method where an automatic pair comparison of each driver generates relative priority scores (the one we will see here),
  •  And a “Manual” method where users specify priority values for each driver directly.


To weight the drivers and define priority, the Analytic Hierarchy Process (or AHP) can be used. Its principle is to first decompose decisional problems into a hierarchy of more easily comprehended sub-problems, each of which can be analysed independently.
There are 7 levels of comparison:
  • Is extremely more important than
  • Is much more important than
  • is more important than
  • Is as important as
  • Is less important than
  • Is much less important than
  • Is extremely less important than

Using this method, drivers are compared two by two


At the end of the exercise, here is what we have:


To complete the matrix, let’s go back to the 7 levels of comparison:
  • Is extremely more important than
  • Is much more important than
  • is more important than
  • Is as important as
  • Is less important than
  • Is much less important than
  • Is extremely less important than

They are symmetric, 3 above “Is as important as” and 3 below. This means that if a driver A “is extremely more important than” a Driver B, then the Driver B “is extremely less important than” the Driver A. Of course, the driver A “is as important as” the Driver A J.
Here is the complete matrix:


Now is the key question, how to replace sentences such as “is as important as” by numbers, we can use to calculate the priority of each drivers.
It was quite simple via Bing (even if never find it on any Microsoft websites) to find the values of each, here they are:

Next steps is to simply replace text by values.


Now this is where it become funny, yes it is. Project Server use a statistical calculation method called eigenvectors. If, like me, this is not something you studied at school, or is not your bedside book, you might check http://en.wikipedia.org/wiki/Eigenvalues_and_eigenvectors. Was it clearer? No? Me neither J
Better option is to find either an online application to calculate them, like http://comnuan.com/cmnn01002/, or find Excel add in (I found an article on MrExcel.com where this tool is mentioned http://digilander.libero.it/foxes/SoftwareDownload.htm).
The system then normalize the eigenvectors. It calculates the sum of eigenvectors, each of them will be divided by this sum to normalize them and get the business driver priority. (E.g. Driver 1 => 0.89687/2.32503 = 38.57%).


Let’s check these results in Project Server…



Well, not so bad J

8 comments :

  1. In the event that you have the accreditation it will be certainly simpler to look for a vocation as a task or program chief.ExcelR PMP Certificationa

    ReplyDelete
  2. When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your.ExcelR pmp certification

    ReplyDelete
  3. Welcome to the party of my life here you will learn everything about me. GRE代考

    ReplyDelete
  4. This post is very simple to read and appreciate without leaving any details out. Great work!
    pmp certification

    ReplyDelete
  5. Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. Zorg Taxi Rotterdam

    ReplyDelete
  6. Hi there! Nice post! Please tell us when I will see a follow up! indoor car covers

    ReplyDelete
  7. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
    data analytics course in hyderabad

    ReplyDelete
  8. Reading your excellent writings is a genuine pleasure. You appear to put a lot of time and attention into your blog. I have it bookmarked and am eager to read more things from it. Continue your wonderful work.

    Advanced Programmatic Advertising

    ReplyDelete

Note: Only a member of this blog may post a comment.