The Money Files

I’m taking a quick break from my mini-series on resilience in project teams as I’ve been doing some thinking recently on how to improve the project management software we have. You might know that I wrote Collaboration Tools for Project Managers so the changing landscape of software products is something I try to stay close to.

One of the conclusions I’m coming to is that tools don’t do everything. As a result, we have to integrate with other products. The software is powerful, but it just can’t/shouldn’t do everything, or you end up with a hybrid product that is rubbish at most things and does everything badly. So integrations so you can use best of breed products is the way forward.

Integrations extend the functionality of your project management tools, and here are 4 benefits to consider.

1. Streamlined workflows

Double-keying data? No thanks! Integrations between apps allow you to automate the flow of information between tools. Need to get that timesheet data into a financial tool? There’s an integration for that. Need to bring in actuals from the accounting software? No problem, we can feed those into the project budget and forecast.

Integrations reduce manual data entry and minimise the risk of human error. And they remove some of the boring work too – win win!

2. Centralised information

How many tabs do you have open? It’s no fun switching from dashboards in one tool to review benefits and then back to the PM tool to enter the actuals, and grabbing stuff from all the places. Bringing in what you need saves time and centralises the data so your team has everything in one place. That should help with transparency and reporting, plus saving time so you don’t have to log in to so many apps in the morning.

For example, integrate with your cloud storage or file-sharing software and then you can access the relevant documents directly within the project management system. To be fair, that isn’t even hard if you’ve got cloud file storage – just add a link! Done!

3. Improved collaboration

You’re in your PM tool but you need to flag something… do you have to leave to go to a messaging app or email? It’s better if there is an integration within the tool so your relevant threads can appear linked to the project task, risk or issue etc. If your tool doesn’t have native messaging, integrate it with whatever tool you do use so that status updates can be sync’d across platforms in real time, so the whole team can see what is going on.

4. Enhanced reporting and analytics

Finally, the more data you have in your PM tool, the better your reporting and analytics can be, and the more you can make use of AI. AI needs pools of data to give you forecasts or suggestions, so if your PM tool is scanty in that area, it’s hard for AI to do anything meaningful with your portfolio data.

Sync up your project data with external analytics or business intelligence tools so you can create detailed reports, analyse data trends, and monitor progress without exporting data manually. And you’ll be able to share project performance data with people who don’t have licences for your PM tools. Because that’s a problem, right?

So, integrations for the win! What tools do you link up (or what problems do you face when they don’t)? Let me know in the comments!

Are you thinking about year-end project audits? Perhaps your PMO is thinking about how to learn from the past year. Perhaps you want to set a good foundation for projects next year. Perhaps you just had a rubbish past few months and want a second opinion to see if there was anything you could have done differently to avoid the outcomes you got.

Whatever your reason, many project leaders’ thoughts will be turning to audits at this time of year, so let’s talk about how to make the most of this exercise – it’s not as awful as you might be thinking!

Planning the audit

First up, make sure the audit is planned in. Schedule it in advance to ensure key team members are available.

Look out the documentation that is required, which is normally things like financial reports, scope changes, and risk logs. You’ll also want to make sure that the business case, project plan, and schedule are available, as well as any change requests that changed those, so the auditor can compare the original planned baselines to the current baselines.

Key areas to audit

So what is your audit going to look at? Whether you have been asked to audit someone else’s project, or you want projects in your PMO to be audited, here are some things you’ll probably want to put on your checklist.

• Budget vs. actuals: Compare planned spend to actual spend and do the same for resource utilisation if you have the data.
• Scope management: Look at how many change requests the project had and whether that resulted in managed change or scope creep. Personally, I don’t think it is important to assess whether the project stayed within its original scope – what you are looking for is whether changes were assessed and approved rather than being done in an ad hoc manner.
• Risk management: You’ll want to go through the risk log to see how well risks were managed, mitigated, or exploited.
• Quality of deliverables: If anything has been delivered so far, check to see that the quality is comparable to the targets set. In other words, are there post-go live bugs still to sort out, and does the product meet quality expectations?

Identify lessons learned

The main purpose of an audit is to review what worked, what didn’t and what needs to change (or be continued). So you can think of the output of the audit as a sort of lessons learned report. If you already have scheduled lessons learned activities, you can feed those in to the audit report. If not, it never hurts to have a lessons learned conversation with the team.

Set the stage for next year

If your project is running into next year, discuss how the results of the audit can be used to improve processes, define new standards or ways of working, and inform the next year’s project strategy. There might be some easy things you can do to change up how things work to make them more effective.

Whether the outcome is a lot of things to change or the reassurance that you are doing everything right, it’s a good time of year to be reflecting on project management practice. Take stock of where you are and how far the project has come, and if an audit is offered, say yes! It really is a good learning experience.

We do a lot of our reporting in PowerPoint, which is a tool I like using. However, it does often involve recreating data from other sources on a slide so it can be included in a deck. Over the years, I’ve noticed a shift towards more visual forms of reporting, like dashboards and slides.

Slides lend themselves to graphical story telling far better than documents, and are good for the busy exec who wants to flick through the headlines without getting lost in the many pages of a PID or project plan. We all use a lot of words for our reporting, but if you’re trying to get your message across, making your reports more visual can make a difference.

Here are some advantages to consider.

Charts and graphs make your documents shorter

Charts, graphs and tables make your documents shorter because you can say more in a small space.

Visuals make your documents more concise and impactful, perfect for the busy senior manager who just wants to skim. Let’s face it, we all have information overload and busy brains, so the less work they have to do to understand the point, the better. Shorter documents reduce cognitive load and aid retention, so they might even remember the point next month!

Colours highlight status

You’re probably familiar with Red/Amber/Green colour coding for projects. The judicious use of colour makes it easy to see status at a glance. That means execs can focus in on the projects that need management attention.

Watch out for how you use colour though, to make sure your reports are accessible to all stakeholders: readers with colour deficiency or people who prefer to print content in black and white won’t automatically understand your statuses unless you use the words too.

Data presents the facts

Worried about how your sponsor might spin project status? If you present the facts in graphical format, that will support the narrative. Even if your sponsor says everything is wonderful, sharing (for example) the number of red/high risks or open issues is a way to draw attention to the fact not everything is going as well as it could. Data, in graphical format, leads to objective reporting.

Having said that, I’m sure you’ve heard people say that you can spin data in any way. So make sure your sources are clear and that you report like-for-like measures month-on-month for comparison. Links to drill down into the data will show that you value transparency.

If you want to get better at visual reporting, think about where the data is coming from and how you can present it. I got some amazing tips from the book Good Charts by Scott Berinato. It is an eye-opening look at how to position your data for maximum understandability and storytelling.

As well as the analytical thinking that you’ll want to do before you present any data, it’s also worth brushing up your technical skills, whether that’s a quick PowerPoint course or making sure you know how to use all the dashboarding and customisation features of your project management software, so you can get the data out in a format that makes it easy to share and talk about.

Lots of common project metrics lend themselves well to being presented visually: timelines, budget allocations, pie charts of risk ratings and so on. Why not experiment with what you can make more visual in your next project update?

Last time I looked at some tips for making lessons learned sessions run a bit more smoothly, and it made me think about some of the pitfalls we see when facilitating those sessions. My own experience is with using the model associated with predictive projects, but I imagine you could get stuck with these pitfalls if you were doing retrospectives with an agile team as well.

Image credit: ChatGPT

Here are some things to look out for once your lessons learned conversation is in the diary.

Focusing on only the negative things. Don’t let the session focus only on the negative. Yes, people like to have the opportunity to share the things that didn’t go well. If it helps the atmosphere to have a moan about the elephant in the room, then do so. But make sure there’s some time on the agenda left to discuss the working practices that were successful, otherwise you’ll all leave the meeting feeling like nothing went well, and I’m sure that wasn’t the case.

Making the sessions too long or too short. Who wants to give up an afternoon for a workshop? No one. And yet if your session is too short, you won’t have time to properly address any issues, come up with action plans or go through the agenda. The exact length of time is going to depend on what you’re wanting to cover and how much prep the team have done beforehand. Question why you need longer than an hour.

The same topics coming up regularly because they haven’t been handled. Regular lessons learned are part of the process, but too frequent and you won’t have had a chance to fix anything – and the same problems will come up again.

Listening to people say they suffered the same challenges because nothing has changed is annoying and frustrating and leaves people wondering what the point is of raising anything if nothing will be done.

People not feeling safe to speak up. Psychological safety is important if you want to get to the truth, but if no one is prepared to share what they thought didn’t go well, you won’t be able to improve. This is a hard one to address if the organisational culture is conspiring against you, but have a think about how you may be able to overcome it if it’s a risk for you. Having smaller sessions with targeted conversations, or anonymous surveys might be options.

Not doing anything with the output. Yep, this is all about leaving your lessons documented in a folder gathering electronic dust somewhere. Not good. Make sure they are turned into actions and have people responsible for doing something with them. At the very least, share them with the other project managers in your group.

Not being able to determine actions properly as you don’t have the detail to hand. So you’ve recognised you need to do something to change a process? If you don’t have the As Is process to hand, it might be hard to work out the action required to make the improvement. And that basically means the improvement won’t get done as what are the chances of someone doing the mapping and analysis afterwards? Unless the leadership team puts a lot of emphasis on follow up, you might miss that out.

These are some of the pitfalls of holding reflection sessions, but by all means I’m sure this list is not definitive. What are the other challenges you’ve found in your own meetings? Let me know in the comments!

Here is the Northern Hemisphere it really feels like spring has sprung. Evenings are lighter, there is less rain (and while the garden won’t thank me for saying it – we had a soggy start to the year so this is something I’m really pleased about) and I don’t know about you but I’m feeling like I’ve got renewed energy for a spring clean. It truly is the season of starting fresh.

That goes for project portfolios too. If you haven’t looked at the work you’re doing across the organisation, across your department, or even simply your personal workload, then now is a good time to take stock of what’s still outstanding and what (maybe) is no longer relevant.

Are you ready to spring clean your portfolio? The way I’ve been thinking about this is in 3 steps. First, we assess and rationalise, which I’ll talk about in this article. Then we review resource optimisation and reallocate where necessary. Finally, we set clear priorities and a roadmap to take us through the rest of the seasons until it’s time to review again.

Step 1 is decluttering – you might have already done some spring cleaning at home, and now is the time to do the same for your work! So let’s share some strategies for renewal and realignment.

Review the current portfolio

First, take a look at the current project portfolio. Make sure your list of projects is up to date, and that it’s complete. There shouldn’t be any projects that have snuck on to the list without the proper approvals, but if there are, add them formally.

Check the basics for each project: they have formal approvals, there is an assigned project manager, they are hitting their governance milestones or anything else that is the normal for your portfolio.

Identify performance issues and misalignments

Next, identify performance issues, overlaps where several projects are tackling the same thing, and any misalignments with strategic goals. Make sure reporting is up to date and source new reports if they are not. Look for milestones that have been missed or risks that are not managed. When was the last time there was a peer review or an audit? Check that each project still meets its financial objectives and is still viable, with a business case that has been recently reviewed and a benefits case that still makes sense.

Review the ‘go’ criteria

Refresh your criteria for project assessment. Remind yourself of how decisions are taken about pausing, continuing or terminating projects. Do you need to update any criteria or measures around financial performance tracking? Perhaps there are new metrics to include.

Review how resources are allocated to live projects and check everything on the list is a good fit strategically. You might not end up changing any of your criteria or measures, but it’s still worth the effort to run through them and check they are still fit for purpose.

Involve your stakeholders

Finally for this step, talk to stakeholders so you can build in their perception of project value and potential. Are there any projects that sponsors have fallen out of love with? If so, these could be taken off the list and the resources reassigned to projects that will add more value.

Next time, I’ll look at step 2 in your spring cleaning plan, which is dealing with resource optimisation.