Tuesday, January 5, 2021

PPM is dead, long live PPM!

 Stop scheduling your projects, manage your portfolio instead…

The acceleration of the transformation towards a digital world has been a reality for several years now. The sanitary crisis the world is currently going through with unprecedented economic and human impacts has highlighted the need for greater adaptability and responsiveness of companies.

Regardless of the sector, companies must reaffirm their vision, clarify their strategic initiatives and realign their investments.

We are entering a new era where the need to quickly align strategic vision and execution is increasingly necessary. This is not just a transitional phase to get out of this crisis but a long-lasting operating model that should be adopted to face the world of today and tomorrow. One of the levers to achieve this is the implementation of a new approach to a more dynamic project and portfolio management.

Change of paradigm

The paradigm of the previous decade on portfolio management was a bottom-up approach, favoring the creation and management of portfolio through the consolidation, the aggregation of a multitude of projects. We are now making several observations questioning this model:

  • The implementation of the operational layer of portfolio management requires a certain level of maturity, strong change management and significant effort.
  • The population of project managers is changing. Compared to "career" project managers certified and trained, the new project managers are webmasters, consultants, business analysts who move into the world of project management.
  • The activities to be managed in an organization are heterogeneous in their characteristics such as the delivery mode (Agile, V model), and are often already supported by an existing IT ecosystem (legacy).
  • The cycle times between the consolidation of operational activities at the strategic level then the operational application of the strategic realignment can be very long and lead to latency in the organization management.

Based on this observation, we can now distinguish two complementary areas in the playground of Project & Portfolio Management (PPM):

  • Strategic Portfolio Management (SPM)
  • Adaptive Project Management (APM)

Strategy and execution, a complementary approach

It is therefore recommended to implement as a first step the upper layer of portfolio management (SPM), a core-model or common denominator that makes possible to align the execution of activities with the business strategy. This layer provides a maximized and immediate ROI by dynamically declining the strategic drivers of the organization at the execution level, with a controlled effort. We therefore bring in the first place and quickly decision support tools on the overall management of activities with a pragmatic approach. The SPM corresponds to “Do the right projects”.

In addition, the management of project execution is the core of the operational performance optimization. Based on the core-model, a necessary and sufficient prerequisite, the organization is autonomous to adapt the operational management of its activities as needed, on demand, depending on its maturity and its context. The compliance with the minimum portfolio management framework gives to teams a full autonomy and flexibility to manage the execution of projects, in terms of approach, depth or tooling. Thus the implementation of a PPM does not call into question the use of backlog tools. Through the APM, we are addressing to the stake of "Do the projects right".


We are therefore in a top-down portfolio management approach, supported by market PPM solutions that support the complementarity of SPM and APM. Organizations that focus exclusively on the operational component of PPM solutions are likely missing out on its ability to drive the digital transformation of the organization.


Strategic approach & processes maturity

PPM solutions are at the crossroad of business processes: strategic management, financial management, resource management, project management, enterprise architecture, etc. The processes definition and maturity are often and wrongly shown as a prerequisite for the implementation of a PPM. This is wishful thinking because the processes are living artefacts that evolve with the market, the context and the stakes of the organization. In this time of crisis, we have never adjusted our processes as much as in the past 6 months.

We therefore emphasis on the concept of the common denominator here. Strategic portfolio management can be implemented on a set of strong markers such as an RACI, the life cycle of different types of activities and KPIs. Reporting is an essential aspect because management indicators come from the requirements for structuring portfolio management. Thus the PPM solution will anchor the management processes in the operational model and its governance.

For example a first layer of portfolio management, sufficient to dynamically and in real time support the strategic alignment of project execution, could be a simple form for each of the projects containing start and end dates, some attributes and indicators, associated with a capacity plan at skills level. This ensures the immediacy and dematerialization of the relationship between the project manager, the project office and the decision-makers. Moreover, with the flexibility and autonomy of the operational teams, we smooth out the differences in maturity at the process level.

Dichotomy of hybrid portfolio

The challenge of an approach based on autonomy and operational flexibility is even more critical as the portfolios are now mainly hybrid, resulting from the cohabitation of traditional projects (V model) with Agile products. Unlike the bimodal mode (cohabitation of homogeneous portfolios, either traditional or agile), this hybrid world requires the management, selection and prioritization of heterogeneous objects.

This cohabitation seems to be insoluble because it implies the manipulation of structurally different objects, by nature, management and content. So how do you prioritize a project versus an Agile product? Projects are driven and managed by tracking progress, products are by measuring value.

If this dichotomy is still little modelled or implemented, we can try to provide some answers. Here again, we will try to bring a common denominator to the KPIs, by bringing the two typologies into a field of co-management. For example, we will introduce progress indicators on products based on the backlog items as well as on the capacity of the Agile team. On the other hand, we will propose for V model projects to add the notion of value, possibly by dividing up the project.


PPM : from control to steering

From a rigid, uniform but unitary framework, with a bottom-up and control-oriented approach, we have moved into an opposite paradigm. PPM solutions now serve strategic objectives from which a flexible operational management and variable depth is applied, encouraging the autonomy of the teams and therefore the efficiency of management. On the other hand, they require total transparency in the management of activities.

While being less complex and less time-consuming, implementations of PPM solutions now deliver more quickly a maximized ROI and are an excellent receptacle for managing hybrid portfolios. The preferred methodology for deploying PPM solutions is to start with an MVP (Minimum Viable Product) avoiding the tunnel effect and to enhance it with successive addition of value as the digital transformation of the organization progresses.

There is no doubt that PPMs are reinventing themselves and evolving with digital transformation. While some players have already integrated various delivery and governance modes into their platforms, they will undoubtedly have to go even further by adapting to new uses through AI, bots, mobility, etc., by providing a complete and on-demand horizontal (end-to-end lifecycle) and vertical (information depth) coverage.

 

 

Share this article :

Thursday, May 28, 2020

Microsoft Project bricks: Project Online, Project for the web, Home, Roadmap, Project Operations

A new brand area is coming in the Project world. I do believe that the project management paradigm is changing. 10 years back, project managers used to be professional schedulers with certifications, excellent project management skills and a dedicated continuous training and education.
Nowadays project managers are more and more employees who have project management appetence and are coming to this position by seniority after a few years holding other responsibilities. They could be web designers, developers, architects... 
When the traditional Project world (Project Server and Project Online with MS Project Pro) was perfect for the first category with strong scheduling and project/portfolio capabilities, the second category could not fit in it: tooo complex, too many features, too many constraints, training required, etc... 
Project for the Web with Roadmap coming with the CDS and Power Automate bring all together a brand new project management approach: simple, intuitive, full web, no training, drag and drop. No more critical path, just a few columns, you can start just right now to plan your project and activities, using a simple task grid, Kanban or Gantt. You can of course add some information such as effort, % complete, predecessors to make your project plan relevant and gather data at portfolio level using PowerBI. 
My guess is that Microsoft with invest more and more on this approach. Moreover, Project Operations, coming this fall will extend Project for the web using CDS to make it work with PSA service. You can still use Project Online, there are so many organizations using it that it will still remain for at least a decade. And Roadmap helps you consolidating both Project for the Web and Project Online data.
I won't give more technical details about Project for the web since you can already find a lot of amazing things on the web, especially about implementing business rules using Power Automate. 

References:

Below a few screen shots:


In Roadmap you can have a portfolio view adding your Project for the web projects (Déploiement PPM), your Project Online projects (Projet ITSM). You can also add Azure DevOps projects.

Finally in Project Home you can see your roadmaps (portfolio views) and your projects.

Share this article :

Tuesday, November 19, 2019

New "decomposition tree" visual in PowerBI!

Do you remember this visual? Long time ago, we used to create nice dashboards using PerformancePoint Dashboard Designer. I think it was part of SharePoint Server 2010. That was really nice for people like me who are not doing any codes such as SSRS reports or .NET. We could deliver to our customers nice interactive web dashboards with drill-down capabilities. Basically I think it must have inspired MS engineers when developping PowerBI.

Here is a vintage article about PerformancePoint (in french).

PerformancePoint most famous visual was the decomposition tree.  It allowed you selecting a data (custom field) then seeing all sub-decomposition along a measure (work for example). So much better than selecting many filters. As a PM, you could see in your department, your project type, your project stage, your project client, the work by phase.
Here was what it looked like:
Since then we have been playing with PowerBI at lot (more than that) but still to such visual. Now it is done! In PowerBI november update, you have this decomposition tree visual. Thanks Microsoft!

Go and play with it!

Share this article :

Tuesday, November 12, 2019

New service: "project for the web"!

It has been a while since we didn't have such a major update in the Microsoft Project World. I would say that the last key change was in 2013 with Project Online, available in MS cloud. That being said, the features were the same as the on-premise version and it was more the subscription model that was changed.
Since beginning of October a new service has been announced by Microsoft, following Roadmap and Project Server releases earlier this year: PROJECT FOR THE WEB (P4W).
I won't describe here this service in detail since the Project community is quite active and already has produced a bunch of nice article. I'll just point to those articles and highlight the most interesting parts.



Basically it is a brand new service, well described by the following diagram.
You see there that P4W and Project Online are 2 separated services. The first one is based on the Power Plateform and use the CDS (Common Data Service) to store data. Project Online is still available, using both web access (PWA) and desktop client (MS Project). Both services can be accessed by Roadmap for consolidation and PowerBI for reporting.

Here are the key feature of P4W:
  • The grid is an Excel like view allowing managing in a simple way tasks, attribute and assignments.
  • Gantt chart allows having a graphical and timephased view of the tasks.
  • The Kanban view brings more agility in the day to day task management.
Note that those 3 views support co-authoring and real-time (no more check-in/check-out, publish). Accesses are managed through O365 groups and you can embed views in Teams. Note also that since this new service is based on the Power platform, there are many opportunities to enhance the service.

You'll find some screenshots in the links I shared above.

Share this article :

Thursday, August 1, 2019

Project versioning and back-up on Project Online: vote on UserVoice!

Since Project Online was launched back in 2013, there is no more back-up and restore feature available.

UserVoice proposed to introduce again this feature strongly used by Project administrators. You can vote here. I had the opportunity to write a review on this idea on Erik's blog. You can find the review here.



I recently added a new idea on the UserVoice page for versioning projects. This is kind of related but the versioning should be accessible to the users (like the sharepoint versioning), not like the initial back-up/restore feature. Moreover the scope should be extended to the new Project Service platform and not only Project Online.

What do you think? Would you vote for this idea?

Share this article :

Monday, July 1, 2019

Renewed as MVP, 6th time in a row!



Honored to be renewed for the 6th time in a row as a Microsoft MVP in « Office Apps & Services » with a focus on Project and Portfolio Management (PPM).

Since 2014 it is always the same excitement to be part of such an amazing community.

Follow me on my blog to learn about Project Online/Server, PowerBI, Planner, Flow, SharePoint, etc…

Share this article :

Tuesday, March 19, 2019

Delegation in Project Online: what's wrong??

4 years ago, I wrote an article about the delegation limitations and it has reached a great number of views. I guess this is because the delegation feature is (I should say was) intensively used by administrator for daily support and security model use case testing.

However back to May 2016, we noticed a strange behavior while running delegation sessions. Starting a delegation session for a user with limited access (team member for example), we were seeing more projects than we were supposed to. As usual, Brian Smith reacted promptly and published an article to explain this unexpected behavior. I didn't update my initial article at this time, and I now feel like I should write a short post about it since I still see this question on the TechNet forums and from some on my customers, so I think that this change in the delegation feature is still not completely known and well understood.

Basically you'll see this unexpected behavior if the delegate user is a global administrator (O365 admin or Site Collection admin). Here the reason of the change, with Brian's words: "The reason for the change is that in Project Online customers were accidentally locking themselves out of PWA by removing all their PWA administrators – and then the only way to make a user an admin again was to open a support call". To avoid this frustrating situation where the admin is locked into a delegation session, this restriction was created.

The workaround is unfortunately not magic: you simply have to use a session (not delegated) of a user to test the security model. 

Share this article :

Thursday, March 7, 2019

PowerBI : manage different project calendars in your dahsboards.

Following my previous article talking about how to manage your calendar working time as a parameter in PowerBI, I had an interesting comment from my fellow colleague Xavier Trottin. Xavier has a similar role as me, but works most of the time with larger organizations. Meaning that they often (always) have different project calendars because they are managed in different countries with specific working week hours.
Thus my previous method doesn't work. It would require having as many parameters as calendars. 

The way Xavier proposes to manage this use case is to retrieve the minutes per day, which is a data based on the project calendar and attached to each project. The issue is that this data is not accessible in the standard OData reporting PROJECTS table (/_api/projectdata). You have to collect it from the /_api/ProjectServer/Projects table.

Here are the steps to perform to go further in your deployment industrialization.

1- Create a new query. In the source step of the new query, access the table mentioned above. Note that since the PWA url parameter goes until /PWA, you don't have to create a new parameter.



2- Select the ID and minutes per day columns. Note that you can find here a lot of useful information, such as "ischeckout" or the last saved date.


Then you'll get the query output as following, with the project ID which will be the key of the merge and the minutes per day (420 in my example for 7 hours/days).


3- Merge queries. From the standard PROJECTS query, merge it with the newly created query. You'll have to select the project ID from both queries to merge the tables.


4- Expand the column. I'm not really sure if this stage is mandatory but it allowed me having the minutes per day column in the standard PROJECT table in addition to the merged query. You do not need to include the ID column since it is only used for the merging step.


5- Use the new measure in the formulas. Back in the desktop client, for the project duration in days in my example, I divide it by the minutes per day multiplied by 60 (to get hours).


Et voilà! Thanks again to Xavier for the tip. And remember that those improvments have a considerable added value since you do it on one report and you can deploy it for any customer.

Share this article :

Tuesday, March 5, 2019

PowerBI : manage the working time as a variable in your dashboards!

In PowerBI reports, I usually propose a set of dashboards including standard indicators. On a portfolio dashboard such as the one below, you'll always find the duration, baseline, variance, etc...


By default, any data related to time unit in the reporting database is expressed in hours. When you talk about work, it might relevant, but duration are most of the time more comprehensive in days.

In my first reports, I used to create a new column with a formula dividing the duration by the number of hours in a working day.


When you have one major Project deployment per year, this can be a suitable solution. However I personally saw the change in our Project consultant job: with Project Server, we used to do major deployments which could take months and even years. Now with Project Online, since you don't manage the infrastructure part, deployments are much more simpler and quicker. Moreover much more organizations are interesting in deploying Project Online since it is now opened also to smaller companies (less licensing fees). Therefore we are doing a large number of smaller deployments.
All that to say that with this new paradigm, we do need to industrialize our deployments and particularly PowerBI reports deployments. In the usual use cases where the working days can be different in all organizations, the method described above can be time consuming.

So here is the solution: set the working time as a variable.

1- In the PowerBI Query Editor, select "new parameter". You can create a new parameter "hrs_day" with a list of values (7, 8, etc...) and select the current value for the company you're deploying Project Online.


Note that I already have the PWA tenant URL as a parameter.

2- In the dataset where you need to convert hours into days (Project dataset in my example), add a custom column calling the parameter.


3- Back in the desktop client, select again the Projects dataset and select the measure having the manual calculation (.../7). You can also create a new column. Replace the division by 7 by the new parameter.

Here is how to manage working time as a parameter in your PowerBI dashboard. This will optimize your report deployment for new customers and make you reporting toolbox more efficient.

Share this article :

Wednesday, February 20, 2019

Change your default PWA site in Project Home

Thank you Brian (see article)! We can now change the default PWA site in Project Home. 
This is a nice improvment, in the same direction than the permission mode being configurable from PWA settings (versus the SP CA). Now orgnizations tend to have more PWA sites and do need more flexibility to manage several PWA sites. This is also why proposing the new Project Home was very relevant.

From Project Home, you'll find this new "Default PWA site" option.


Then you can select a new PWA url.


When you select a PWA site, Project Online checks if the active account has the right permissions on the new defaut site.

Then what's new? When you'll create a new project from Project Home, it will use the new default PWA. Also the "Go to Project Web App" link will open the default PWA site.

If you are curious, you'll notice when you hit the "Go to Project Web App" that the URL is the following, using the "default" property.




Share this article :

Project Online permission mode directly accessible from PWA settings

When Project Online was released back in 2013, Microsoft introduced the SharePoint permission mode. I've never understood why but this SP permission mode has always been the default mode, where as in most of the cases, the Project Server permission mode was the one to choose.
Indeed the SP permission mode requests to manually give permissions to user in both SharePoint and Project Online, on every projects. Where as the well known Project Server permission mode, even if it is more complex (groups, categories, RBS), is much more simpler to manage once define. It embeds a synchronisation between projects and Sharepoint sites. It also allows defining permissions at group/category level and only requires adding users to groups.
At this time, we only had a few PWA site available for creation : 3 in 2013, then 10 few years later. But now we have up to 9999 PWA sites available, so organizations use to create more PWA site for test, demo, training, different departments, etc...
So at every PWA site creation, the administator has either to change the permission mode in the SharePoint CA (Project Online) or to run a Powershell command (Project Server) to switch from SP permission mode to Project Server permission mode.

This is now over since the permission mode can be set from the PWA setting in the additional server settings.


Share this article :

New SharePoint Central Admin for PWA site creation

Just a quick post since this morning, trying to create a new PWA site, I noticed that the interface changed.


The SharePoint Central Admin has now the modern interface. You can choose to create a new site and pick up the PWA site template. Then you'll select a name and an administrator.

Of course you can still come back to the classic interface.
Share this article :

Friday, February 8, 2019

MS Project formula: ProjDateDiff versus DateDiff

It is always fun to play with formulas in MS Project. It reminds me when I started in 2006 working with MS Project doing scheduling support for project managers. Recently I add a new request about formulas from a customer.
He needed to enter a custom deadline for tasks or milestones. He could use the default deadline column since it was already used for another purpose. Thus we created a custom deadline new field. Then we wanted to have the delay between the finish date and the custom deadline, with a sum rollup at project level to obtain the overall delay.


So far not a big deal... To calculate the delay, I started as usual by using the ProjDateDiff function. Note that I divided by 480 (480 minutes in a 8hrs-day) because this function returns a number of minutes.


However when I give a try, here is what I got if I set the custom deadline equal to the finish date.


Here is the problem, I got 1 day of delay while both date are the same. The trick is to display the time in the date format. 


My task is a 1-d task thus the finish time is at the end of the day (6pm). When I set the custom deadline, by default it will be at the start of the working day (9am). Thus the ProjDateDiff returns a 1-d delay. 

So I search for a couple of minutes around the date functions in MS Project and found the DateDiff function (DateDiff(interval, date1, date2)). It has an additional property that is the time unit or interval. Thus you can set that you need to consider days only in the date difference.


Now I get the difference between the two dates, only considering the date and not the time.



Share this article :

Tuesday, December 18, 2018

Microsoft ROADMAP available, have a look!

Finally Microsoft ROADMAP is available for lucky us! Depending on your your region, you’ll start to see Roadmap roll out worldwide to commercial customers.
For those who still haven't heard about the future of Project, here is the annoucement for Howard Crow and a video from Orlando MS Ignite about the upcoming new features.

I'll publish a more detailled post later on, but right now, I just want to share with you my first impression as activating and discovering Project ROADMAP.

First you need to activate the Roadmap feature in the O365 Central Admin.


Then on the new Project Homepage, you'll find under "create new" button a "ROADMAP" item in addition to the existing project creation item.


After that, I add to wait for some time, maybe around 10 minutes, which I found to be quite long. Reading the message, the feature is getting setting up for the first time so it requires some time to compute. Note that I was using a demo tenant which might not be optimized like customer tenants. Note also that it is definitely a good news to finally have relevant and contextual message while you're waiting for an operation to be processed. It reminds me the new contextual message when you are publishing a project from PWA. Here is a reference.  

Once initiated, you'll start from an empty page proposing a timeline with a zoom and a member list.


When you create a first project (not sure if I should call it a "project"...), you specify a name, an owner (Anna) and you can connect it to an existing project from Project Online or to an Azure Board.

When trying to connect the new project to a Project Online project, you have to enter the PWA tenant URL then a project (once the URL is getting validated). 
Once the project selected, it seems like you're using FLOW to get updates to roadmap from Project Online.

You can then select a task:

And it will be added to the roadmap in the new project.


You can also add a key milestones.

You can also add members to the roadmap itself, but not specifically to the single project (line) inside the roadmap.

This was a quick review of the new roadmap feature. I can tell you that I'm pretty excited.
Do not hesitate to ask questions or to suggest improvments to Microsft through the UserVoice.


Share this article :

Sunday, November 18, 2018

Project Server 2019 Released

In a fast pace changing environment, Microsoft is continuously improving its Project Management platform via Project Online. While traditionally all enhancements are released in real time via Project Online, just one of the benefits of being in the cloud, Microsoft has released a bundled three-year snapshot of enhancements to its 2019 product for their loyal on-premises clients.


What’s new in Project Server 2019?

 Agile Delivery in your day to day Project Management Software

The new Project Server 2019 release introduces higher performance resulting from optimizations applied in the database layers.  Additional benefits include:

  Continuous PPM Innovation

Microsoft Project Server has been built on continuous PPM Innovation.  While Project Server 2019 is an on-premise version, you can connect to it from several desktop clients.
Share this article :

Friday, October 12, 2018

Indented Schedule Tasks in Power BI #Tips

The other day, one of my US colleague asked our internal community for help in displaying project tasks in a table. The tricky part is that he wanted to display the task names indented as Microsoft Project would do. One of my fellow colleague (Jean Lieverman) working on Project Online and Power BI replied with the simplest yet super clever solution. 
I was so excited to see such a clever call that I wanted to share!

Here is the result
As you can see, we have here a nice table with indented tasks based on the outline level of the tasks.

The awesomeness is not necessarily in the visual result but in the way it has been built To get to that result, Jean created a new column (right click on the tasks table and add column) called "Task Padded" with the following formula:
Task Padded = REPT ( "     ", Tasks[TaskOutlineLevel] ) & Tasks[Task Name]

The formula will add as much tabulations as the outline number which references the level of indentation. Use that new column in your matrix or table and you are all set!

I hope that will help some people who might want to achieve the same.
Special Credit to Jean 👍
Take care.
Share this article :