Jeremy Cottino

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

How to remove (blank) values in an Excel Pivot Table

You can call it perfectionism, but I hate when my reports are not looking good. One of the most irritating element are those (blank) text you may have on your Excel pivot tables.

15 commentaires

Managing risks and issues with Project Server 2013 (or Project Online)

As part of your projects’ management, you will most probably have to manage risks and issues.
The goal of this article is to show how risks and issues (but also documents or deliverables) can be managed within Project Server 2013 (or Project Online) and linked with Projects, Tasks or any other assets.
Before we start, let see how the Project Management Institute (PMI) defines issue and risk:
Issue: A point or matter in question or in dispute, or a point or matter that is not settled and is under discussion or over which there are opposing views or disagreements.
Risk: An uncertain event or condition that, if it occurs, has a positive or negative effect on one or more project objectives.
Project Management Institute. (2013). A guide to the project management body of knowledge (PMBOK® guide) – Fifth Edition.

In fewer words, risks might occur and we need to manage this eventuality, where issues are events that are already happening and we need to manage consequences.

My project
For the demo, we will use a simple project called [Related items project], that has the following schedule.

14 commentaires

Use baseline and track your work

Let me tell you this story of a project manager; he spent time with his team to compile their project planning, then proudly print it on A0 page, and pin it on the wall behind his desk. This is for me one of the most common mistakes a beginner does on project management. Why? Because the time you print the schedule and pin it on the wall, the schedule is not anymore up to date. You planning is alive, people will make work and progression on some tasks, others tasks might be delayed… It is important to track the work done in order to answer the question “how are we progressing compared to original plan?”.
A snapshot of the original plan should be saved in order to allow later comparison. This is what we call the Baseline.

Once your original planning is done, you can save your first baseline, by clicking on Project > Set Baseline > Set Baseline.


2 commentaires

How to estimate effort, duration or cost?

The practice of estimating in project management is one of the most challenging. Whether you’re trying to figure out project effort, duration or cost, given the inherent uncertainty of projects and their uniqueness, we often end up “guesstimating.” This article provides techniques to use in order to be as accurate as possible in doing your estimates. While I focus on effort estimation, the same techniques apply to duration or cost estimation.
Let’s start with a reminder about how project time management is articulated, according to the PMI® PMBOK® Guide & Standards, Fifth Edition:


2 commentaires

Understanding resource engagements

Resource engagements, which is one of the new feature available in Project Online, is the way Project Managers and Resource Managers agree on resource allocations (for more information about new features of Project in 2016, please check my previous blog article: What’s new in Project 2016).
The resource engagement feature substitutes the resource plan feature you might know from the previous version of Project Online or Project Server. Projects’ resource plans will be migrated to resource engagements. It’s important to note that only published resource plans will be migrated, so before you start, publish all your resource plans.

In order to use resource engagement, the feature needs to be activated. When you connect to your Project Online tenant, you see this message (only admins see it):
4 commentaires

What’s new in Project 2016

During the Microsoft Ignite Conference Keynote Address in May 2015, the Office 2016 Public Preview for Consumers and Enterprise customers was announced. The final release is broadly available since the end of September 2015. So what about Project? Here was the official announcement from Microsoft:
Project 2016 is […] available online as part of Office 365. The new service side features […], are being rolled out into Project Pro for Office365 and Project Online right now. The new […] features will be available to on-premises customers in the spring of 2016 when Project Server 2016 is released.
Let’s see those new features in details:
0 commentaires

Project Virtual Conference 2015 session: Successful business value realization with Lean Startup and Project Online

Friday October 23rd, I had the chance to be speaker at the first Project Virtual Conference http://projectvirtualconference.com/.
As introduced by the conference team: “Project Virtual Conference 2015 is the first-ever online conference that is dedicated to Microsoft Project, Project Server and Project Online, that will run for a continuous 24 hours”.
The Project Virtual Conference 2015 in numbers is 1400+ registered attendees, from 76 different countries, and 61 sessions (the list of sessions is below).
My session was: Successful business value realization with Lean Startup and Project Online. The idea was to merge Portfolio Analysis with Lean Startup principles.

Here is the session abstract
To develop their business and products, Coltham Metalhead, a beer brewing start-up, has put in place the Lean Startup Method in order to support their fast growing business. They have combine this practice with a Portfolio Management Methodology, based on the Standard for Portfolio Management from the Project Management Institute. Their Project lifecycle starts with demand management and project ideation through their innovation hub, then the portfolio management process helps the decision making process to select the right projects to run and finally project management techniques help ensure projects are successfully delivered. In this presentation, the focus will be on the Portfolio management principles, and how Coltham Metalhead, hence yourself, can apply Project Management Institute’s standards on Portfolio management and lean start-up philosophy within project Online. By creating what if scenarios (based on risks, costs¦), they ensure they are “doing the right work”.


Have fun watching the recorded


1 commentaires