Tuesday, October 10, 2017

Power BI: Chiclet slicer with image

Hi, 
I haven't been playing and blogging with PowerBI since a while. Recently for a new customer, I had to display a filter on a PowerBI report to include/exclude important projects which need to be reviewed at board level. Since my tenant was in French but the report was in English, I had something really not satisfying, displaying TRUE or FALSE in a slicer, not really meaningful. The board wanted to have something more graphical. You would just click on the green check mark to select flagged projects. 

Nice isn't it?

Basically, in MS Project it is not more than having a flag enterprise custom field in a PDP to flag in or out projects, associated with a graphical indicator. In the project center, flagged projects are displayed with check marks.

First, find on Internet (free of rights) icons corresponding to your need. Prefer PNG format so the icon's background will be highlighted when selected. You can store the icons on a shared library on your PWA instance, accessible at least in read-only by all Power BI users.

Then in Power BI Desktop, you have to import a custom visual named Chiclet slicer. I won't go in details on how to do this, it has been blogged many times already: here is the support article you can refer to. Once done, open the query editor, select the data source containing your flag (ProjectData in my case) and create a new conditional column.

You'll be able to enter a name and generate outputs based on condition. In our case, the output will be the image URL for each value of the custom field (TRUE or FALSE), with a "else if" condition.

Once validated without error and back to Power BI desktop, you can select your dataset then your new conditional column. In the "Modeling" tab, under "Data category", select "Image URL".

In your report, add the new chiclet slicer visual and drag:
  • the flag enterprise custom field in the category and values zones,
  • the new URL conditional column in the Image zone.


In the widget format settings, you can specifiy the size or the chiclet and the split of the image (100% in my case so only the image is displayed, not the label).

Et voilà!! Note that you can even do that with the Enterprise Project Type which is a pretty common filter. The challenge is more to find meaningful icons. 

You'll also note the nice graphical rendering using conditional formatting in table and the Gantt custom visual which particularly applies to Project Online context. 



Share this article :

Wednesday, October 4, 2017

Highlight days in a Gantt

As moderator of TECHNET forums about Project Server / Online, I often have interesting questions which push me digging concerns I would never have considered.

One recent question I had was as followed. So back to MS Project basics, this is quite simple and immediate to set up but it can bring visibility to stakeholders whom you're sharing the plan with.
"How could we highlight days on an existing task? For example, customer visit on site, strike, MEP, etc... We don't want to create additional tasks or work, neither to create exceptions."

So before going through the steps, here is the final result you can achieve with a 5-minutes configuration.

Starting with the following 10-days new task:

First concept to understand: the bar styles. If you double click on the Gantt chart, you'll open the following configuration box:

You can see that each type of task (normal, manual, critical, milestone, summary, baseline, etc...) has a specific style which can be customized. You might remember that I wrote a post a while ago about customizing bar style based on custom flags. You can also see that each style has a start and a finish. For standard tasks, it is obviously [start] and [finish], whereas for baseline tasks, this is [baseline start] and [baseline finish]. This allows displaying baseline above the task as shown below. 


You understand that mastering bar styles can be quite useful whenever you fall into Gantt customization. So back to our use case, the principle is to use custom start and finish dates. 

1- You can start with the start1/finish1 but you could use additional custom dates if you want to highlight multiple slots.

2- Then customize bar styles with start and finish dates 1 and 2. Note that the new bar styles have to be created BELOW the standard task style so it will be shown on top. Otherwise it would not be visible.

Here is what you get, clear and simple:

3- You might want to add a label as an explanation for highlighting those days. You can use the text 1 and 2 to enter text, and set those custom fields as text displayed on top or below the bar.

Here is the result:

Leonardo da Vinci used to say: "Simplicity is the ultimate sophistication", what do you think?

Share this article :

Tuesday, October 3, 2017

Exciting times for Project Online!

We are living exciting time for Project Online. I have to say that things have been a bit quiet the past few years. Indeed we had the resource engagements feature and new reporting capabilities with PowerBI, but since a few months, we do have some interesting announcements, showing us that Microsoft is giving a second youth to Project Online. Our entire community is excited by this trajectory and I wanted to share some topics which were announced at or around the Ignite Conference in Orlando (interesting session to replay).

PLANNER INTEGRATION


This first new feature emphasizes what I'm telling from years and years since I'm deploying MS Project / Server / Online. MS Project is NOT a task management tool, especially when you're using it in an Enterprise context. It is meant to manage a portfolio and bring visibility on your workload and the project progress and health. Not to manage 2-hrs meetings or granular tasks. Of course you can do it, but I'll be tedious and it requires a high level of expertise with the tool. And from my experience, if you try to manage a 3000-tasks plan with dependencies, resources and timesheets, it won't last for long. Thus I always advice to use if necessary a Sharepoint list or any other solution to manage a backlog of activities. Planner came to fill this gap in O365 environment but still it wasn't linked in any ways to Project. 
Now this integration does exist, still in v1, but the momentum is there, MS will go on improving this integration. From now, this is "just" the ability to send a task from Project to Planner with a hyperlink, but we do wait for a both-way integration to roll down and up the assignments and (actual) work for example. 
It brings then the question of the timesheet: if the actual work is rolled up from Planner to Project, how is the timesheet dealing with this feature. Remember that the actual can be forced to come from the timesheet. Then we come to another exciting direction, talking a while ago with some guys from the product group: sending the timesheet application out of Project at O365 level so it can be plugged on Project, but also Planner, SharePoint, etc...
Didn't I told you that we were living exciting times...?

AGILE INTEGRATION


This is a huge WOAA!! A v1 Agile integration in MS Project (for Insiders Fast build 16.0.8625.1000) has been released. Here is what I can share with you. I would have liked to tell you more and propose a quick demo but I couldn't test it myself yet.
  • Use Agile in MS Project
    • Project Managers can use simple, visual task boards that support Scrum, Kanban, or custom workflows
    • Visually manage your projects and tasks using agile-style views
    • Plan work in iterations using sprints or choose a Kanban-like workflow to track ongoing status and limit work-in-progress
    • Customize workflows to meet your project's tracking and reporting needs
  •  Choose your work style
    • Project managers can choose whatever methodology makes sense: agile, waterfall, or hybrid.
    • Manage task-oriented projects using agile-style views
    • Use Gantt views for projects that require upfront planning, resource balancing, and critical path analysis
    • Manage sub-projects within a larger project using agile-style views while using a Gantt view for the overall project

  • Maintain Transparency
    • PMO can centrally manage different types of projects with governance and visibility
    • Maintain governance of standards and processes across teams and projects
    • Gain visibility across projects whatever work styles are being used to manage them
    • Use out-of-the-box and custom reports to report across projects or focus on status specific to agile-style workflows


POWERBI REPORT PACK V2


The first PBI report pack was an incredible enabler for pushing sexy reporting capabilities. It also helped the community to better understand PBI features and how it could strength Project Online added value. With this new report pack, Microsoft is going further, providing 11 pages mainly focused on portfolio and resources. Paul Mather, a fellow MVP has already written an exhaustive post so I give him credit.


TEAMS versus SKYPE


Microsoft Teams is quite a new member (1 year old) in the O365 family, but MS has already announced that it will be replacing Skype for Business, which has already took over Lync. Note that Teams allows integration through tabs with Planner and PowerBI.


Share this article :

Wednesday, July 26, 2017

Project Online: 2 free apps to make your admin or PMO life easier!

As Project Online admin or PMO, we know we all have some manual operations to perform on a regular basis in order to keep project data up to date or improve the overall process. Starting from Project Server 2003, I get used of spending (and asking my customer to spend) a certain time doing such time-consuming operations. Since I have no development or coding skills, I always had to rely on a technical team. It also meant to run all the way down kind of a mini-project for building admin tools: defining specifications, doing mock-up, testing, deploying, documenting (selling it to the customer...). So to earn time of administration, you spent time on developing administration tools.

Thanks God, Microsoft kept on investing, Project Online came up, the solution was more and more "sexy", the community of developers went bigger and bigger, starting playing with apps, scripts, code samples... It allowed administrators picking up apps in the Office store to make their daily jobs easier and most of all, bring added value to the native Project Online product. 

For example, when a customer says: Can I auto-publish all projects on a regular basis? Can I bulk edit project ECF in an Excel-like sheet? The answer was: "No you can't (or it'll cost you)". The answer is now: "Yes you can (and for free)".

Less job for the PMO/admin, customer happy, better sales rate for the consultant and less development, consultant happy.

This is to introduce 2 free apps I'll shorty present in this blog post. I obviously start by giving credits to my estimated colleagues who propose those apps on the Office Store:

I won't go in details on the procedure to install apps on your Project tenant, since this is child's play. Be sure to be connected to your Project tenant with your admin account. Click on the links above (or search in the Office Store the app name) and add it to your tenant. You'll get prompted with the usual dialog boxes, need to trust the app, accept the general terms, etc...

1- Bulk calculate and publish app
We all have struggled with custom fields with formulas not being calculated, such as formulas using now() functions which need to be updated each day. More generally, you can be in the tricky situation having false, empty or errored values for custom fields with formulas in the project center. Which is annoying knowing that the project center is often for manager a central point for portfolio/project data gathered among the organization. Also if the data is incorrect in the project center, it means that it is incorrect in the publish/reporting tables, consequently it'll also be incorrect in any type of reports (PowerBI, Excel, SSRS).
Solution is? Publishing projects of course! Here is where you don't have to do some PowerShell anymore to bulk publish projects. The app from PPM WORKS, once installed, allows the administrator to schedule on a regular basis (hourly, daily, weekly) your projects. You can set up email notifications entering emails separated by commas (it can be non-O365 email!!).
Another strength of the app is that it creates an "auto publish" project ECF so it will auto publish only flagged projects. 
Isn't it nice?


I was even wondering if it could be used to publish task updates after the PM approves it in the approval center. Digging this question and I'll come back asap with an answer.

2- Bulk edit app
Next question is: ok, I have scheduled my auto publish job with this nice app, but I now need to flag all my projects with the auto publish ECF!!! 800 projects need to be opened, checked-out, flagged, saved, published, checked-in. Let's say 20 seconds per projects, it makes almost 4.5hrs to update all projects. OMG!
More generally, if you're PMO or admin, it might happen for example to add a custom field to integrate a new need on an existing Project instance. So you also need to enter the new value for projects. For financial control, you might have cost ECF and update them on a monthly basis for reporting purpose.
Martin's app from NearBaseline allows you the bulk update your projects ECF in an Excel-like sheet. You first have to select the custom fields you want to display. Then just update the value. Some nice features :
  • Green check mark to show that the update has been published,
  • Possibility to defer updates,
  • Force check-in,
  • Possibility to extend cell's values like in Excel.


Interesting to check the queue while editing a project: you'll find the update, publish, reporting and check-in jobs processed. You might also see the "Synchronize Managed Project With Task List" in case it is activated on the project's EPT.



That was just 2 examples of the free apps you can find on the Office Store. Keep in mind that the community is more and more active and you'll find more and more apps or 3rd-party solutions which will be great added value for your customer, and great selling arguments for you.

Share this article :

Wednesday, May 31, 2017

New projects and sites number limit & EPT configuration

Beginning of April, Microsoft announced in this article of few improvements, mostly related to Project Online performance, such as the new check-boxes in the Project Center I described in my last post. Another major improvement concerns the limit of projects created in a Project Online instance increased from 5,000 to 30,000. With this improvement comes another one concerning the project sites. The limit used to be 2,000 project sites. If you needed more than 2,000 sites, you had to create and work with several PWA instances. Now there is a one-to-one relationship, meaning that you can have 5,000 projects with 5,000 sites.

In order to optimize PWA instances performance with those news projects and sites limits, the EPT (Enterprise Project Type) configuration has also been updated. 
Previously the synchronization settings were at instance level, they are now at EPT level. Moreover, you can set a site creation location for each EPT. 


How you should use this new configuration? Here is how I see it. 
  • You might have an EPT with a large number of small projects running on a short period. In this case, you'll not create any project site and consequently you'll not check the sync permission options.
  • In parallel you might have another EPT with an small number of standard projects. In this case, you'll automatically create a project site, you'll check the sync options and locate the site creation in the normal PWA address.
  • Finally, you might have an EPT with specific long term projects dedicated to specific stakeholder with a large set of documentation. You'll also automatically create a site with sync options checked, but you'll locate the site creation in another site collection.

Consequently, since those options have been rolled down at EPT level, you won't see them anymore where they used to be. If you go to the Connected SharePoint Sites section in the server settings, you'll see that there is no more "Settings" button.

Also under "Manage User Sync Settings", you won't find anymore the site sync.

Check-out the Microsoft blog to see the other improvements, such as the modified dates added to some Odata entities.



What is happening if you already have some project sites created in the "old" way? (a jérome's edit)?

Well, the story is a bit more complicate then. By default, you have to know that the options are not as set as you would expect.
1. While the Project Site creation will be set to the choice which was made in the "old" menu


2. The synchronization options are both disabled. The impact is that all the team members are losing (or not gaining) the access to the project sites while the project is published. Tasks as well stops to be synchronized which means that no more seen in the home page nor in the tasks menu of the Project Site


It is also worth noticing that the Project site is now created at next publish and not at project creation as it was previously enabling a rapid project creation

So, to wrap-up, if your environment is already having project sites created, I would advise the to take the following steps:
1. Validate that the setting for each Enterprise Project Type is the expected one
2. Open the schedule and publish it (either from Project Online or from Project Professional) - that will trigger a tasks synchronization
3. Change your project team temporarily in adding or removing a resource (who can connect) and publish to trigger the Project Site Permission Synchronization. Then revert the change.


You should now be good to go. let me know if you find any weird behaviours, Guillaume and I would be happy to further complement that post.


As a cross-reference, I would like to link the great work done by Nate Auchter here https://www.senseiprojectsolutions.com/2017/05/26/manage-site-creation/

Share this article :

Friday, April 21, 2017

Project Center update: small change good change!

Hi Folks,


You've got to stay on track with updates, which is not always obvious with the frequency of updates in Project Online!

Did you notice? No? Have a look to your project center ribbon... 


Got it? You have 2 new check-boxes, rollups and Gantt Chart. Quite easy for the second one, you can hide or display the Gantt Chart. I guess the first use concerns portfolio views where Portfolio Managers want to focus on data more than on the Gantt aspect.


The second one can be interesting also. You can hide or display rollups while using grouping data in views. The objective might be to load faster views


This could propose this type of interesting portfolio views.


Share this article :

Tuesday, March 28, 2017

PowerBI dashboard integration in Microsoft TEAMS

Hi Folks, it's been a while! Back from a couple of very time consuming projects, I wanted to share with you a nice way to share PowerBI dashboards.

A couple of months ago, I wrote a post about how to embed a PowerBI dashboard in SharePoint/Project Online using a content editor webpart. That was a nice try, but if you read it until the end, you probably saw this disclaimer:

Warning: When you use Publish to web, the report or visual you publish can be viewed by anyone on the Internet. There is no authentication used when viewing these reports. Only use Publish to web with reports and data that the anyone on the Internet (unauthenticated members of the public) should be able to see. Do not use Publish to web with sensitive data, data that has financial implications, data that must remain confidential, or data that you do not have the license rights to publish.

Not good, isn't it!? Or at least pointless... Until then, you couldn't easily share a PowerBI dashboard out of PowerBI App.

Few weeks ago, Microsoft released TEAMS, a chat-based application for supporting team collaboration (see here for more details), accessible from the O365 waffle menu.

O365 Waffle menu with TEAMS
The principle is quite simple. Assuming you have created your PowerBI dashboard and configured your collaboration space in TEAMS, you can easily add in the teams section a PowerBI application.
Add a PowerBI application in TEAMS
Once done, you'll be prompted to choose among the PBI dashboards you can see.
Select PowerBI dashboard
That's done!
The good thing is that it isn't just an image of your dashboard but a frame embeding your PowerBI content. You can even play with the filter or start a discussion related to the dashboard.
Use the dashboard filter in the TEAM PowerBI tab

Start a conversation about the dashboard

Beyond this nice feature, I see advantages for organizations using teams which can create groups of users based on their reporting needs, such as portfolio managers, and share dashboards accordingly.

Share this article :