Jeremy Cottino

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

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.

8 commentaires

Understanding the Efficient Frontier

The Efficient Frontier is a concept defined by the Nobel Prize winner HarryMarkowitz as part of an article published in 1952 named “Portfolio Selection”. He stated that an optimal portfolio is the one that delivers the best possible return for a given level of risk or investment. Applied to portfolio analysis, the Efficient Frontier is represented as a curve, and plots strategic value (as a percentage) against Portfolio Cost. It might happen, often when you choose to force-out some projects, that the portfolio selection scenarios is plotted under the curve, which mean that the portfolio is not optimal.
0 commentaires

My first PMI Swiss Chapter speech about Project Server

Tuesday, 9. Sep. 2014, I had the chance to be the speaker for a special event of the PMI Swiss chapter. The presentation was given in Lausanne at the Olympic Museum and the subject was:
How can Microsoft Project Server help you achieve your business objectives?
2 commentaires

Delete a project on Project Server (PWA) 2013

Doing all your tests, you might have a lot of “Test Project 1”, “My new test project”, “aaaa project” on your project center… This is how to delete one project.
Click on the Settings button, and click on PWA Settings.


PWA Settings page is displayed.


Under Queue and Database Administration, click on the Delete Enterprise Objects link.


To delete a project, select Projects on the section What do you want to delete from Project Web App?
You might also want to Delete draft and published projects. You also have the opportunity to Delete the connected SharePoint sites.

Note that if you don’t delete the associated SharePoint site, you will receive an error the next time you will create a project with the same name as the deleted one, while publishing the site.

Click on Delete and that’s it. Be careful as deleted projects cannot be retrieved.
0 commentaires

Demand management and ideation in Project Server 2013

In this article, I want to share with you how we manage demands in my company. By using a SharePoint list to collect project ideas and initiatives, we are able using a very simple Project Server 2013 out of the box feature, to create a project and manage it.

Create a SharePoint list to collect
The first step consists in creating a new SharePoint custom list. For those who are not familiar with SharePoint, here is the “HowTo”.
Click on the “Add lists, libraries and other apps.” Image on the PWA home page. If this default web-part is not present, you can access the same page by clicking on the settings button, then Site content. Finally on the site content page, click on add an app.


On the [Site Contents: Your Apps] page, click on Custom List.


1 commentaires

Create an Enterprise Project Type with Project Server 2013

Starting with a definition, what is an Enterprise Project Type (EPT)?
This is the definition I found on office.microsoft.com website:
In Microsoft Project Web App, an enterprise project type (EPT) represents a wrapper that encapsulates phases, stages, a single workflow, and Project Detail Pages (PDPs). Each EPT represents a single project type.
The schema below explains what an EPT contains and the hierarchy of each elements:


From bottom to top, to create an EPT, you first need to create Enterprise Custom Fields, Project detail pages (that might contains custom web-parts), workflow (with phases that contain stages) and finally the EPT.

15 commentaires

Using PERT to calculate task duration in Microsoft Project

What is the PERT technique?
Following the definition found in Wikipedia, "the Program (or Project) Evaluation and Review Technique is a method to analyze the involved tasks in completing a given project, especially the time needed to complete each task, and to identify the minimum time needed to complete the total project."

For those who passed or are preparing for the PMP exam, you should know the famous formula to calculate the expected duration of a task. This is also known as the "three point estimate".
Calculation of the expected time (TE): the best estimate of the time required to accomplish a task, accounting for the fact that things don't always proceed as normal (the implication being that the expected time is the average time the task would require if the task were repeated on a number of occasions over an extended period of time). The formula is:

TE = (O + 4M + P) ÷ 6

46 commentaires