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 :