Three Tricks I Learned, And You Should Too

A lot of my content talks about the why and how of knowledge sharing and reuse. Yes, this is something to consciously integrate in your organisation's way-of-working. And yes, a systematic approach enables this. But much (if not most) of the value comes from tricks and small improvements that are easy to replicate and adopt. Their impact might seem small, but it all adds up over time.

So, here I'd like to share three 'tricks' I've learned to improve your work and life.

Trim Your Columns!

A while ago I was working on a project with another consultant. He looked quite frustrated so I checked in to see how he was doing. He sighed and said: "I don't understand it. I have this data export that I want to analyze, but the vlookup won't work. I've been trying to figure out what the problem is all day." “Fortunately” I had experienced the same problem some years ago, and learned it takes 10 seconds to fix.

Different systems encode data exports in different ways. This might add hidden characters to values that affect spreadsheet functions. An easy way to prevent issues is to trim any text columns you want to use in vlookups (and similar functions). Create a second column with the =trim(original column) formula, and use this in your vlookup. Doing this is a good practice that will save you a lot of confusion and headaches. 

Don’t Trust Averages

The standard deviation (StDev) is one of the most useful statistical measures. It's also a standard function in spreadsheet tools so it's easy enough to calculate. Yet, I didn't know how and why to use it until someone explained the 68-95-99 rule to me.

For example, if you have an average delivery time of 20 minutes and a standard deviation of 2 minutes, that means:

68% of deliveries happen within 18-22 minutes (average +/- 1 StDev)95% of deliveries happen within 16-24 minutes (average +/- 2 StDev)
99.7% of deliveries happen within 14-26 minutes (average +/- 3 StDev)

Note that this only works for data with a normal distribution. You can quickly check this by making a histogram of your data, and see if you have a bell curve.

So why does standard deviation matter? Because it indicates the volatility of a certain process or change. 

Here's the delivery time of two different restaurants.
Or the travel time of two trains on the same route.
Or the value of two stocks.
Or temperature changes in two countries.
Or the voting preferences of two states.
Or the response time of two ambulances.

Same average. Different stories.

Averages are popular and easy, but they only give a very limited impression. Ignoring the volatility of a process can have serious consequences. 

The Answer To All Questions

Recently, a legal knowledge management consultant told me the following story. She asked her client how exactly she was bringing value, and improving the clients' work. He told her that she had helped him save a lot of time and frustration. Before, he received the same questions all the time. For example, how to remove the 'draft' watermark from contracts. He found this immensely frustrating as it interrupted his work and broke his focus. Together, she and her client set up an FAQ page on the firm's intranet for these sorts of questions. The client's colleagues learned to look there first, freeing him to focus on higher value tasks

And there it is. Three small things to improve your work and life. 

Are you looking for advice and help in improving the knowledge sharing and service delivery of your team? Let's have a talk. Even if you're just curious, our 45 minute conversation will give you clarity and save you weeks of research and frustration. No strings attached.


The Do's and Dont's of IT projects

What should we do to (and not do) to ensure the project runs smoothly, and delivers the best results? I asked a few experienced IT project managers what they've learned.

[Case Study] How I helped improve construction projects

Last year, I helped a construction company improve the efficiency of their projects, and their IT team become a true business partner. You can read the story here.

[Podcast] It Took A Lot Of Jelly Beans

Peter Maeseele is an expert in design and business analysis, and a lead in a number of IT knowledge management initiatives. In this talk he shared some of his experiences and insights - and why jelly beans proved a key component of their change management.

The Lazy Man's Way Of Working

Lazy smart people leverage experience to their benefit. They take the time to save time.

[Case Study] Better IT knowledge sharing = happier customers

Fewer calls, lower costs, and happier customers. Here are some results different IT teams saw by improving their knowledge sharing and communication. What would achieving similar results mean for you and your team?

[Podcast] Not Everything German Is All German

Marianne Rutz shares some great insights and practical advice on how to account for local culture in global service teams, and how teams can leverage cultural diversity to improve their services.

A tool to optimize your team's learning and knowledge sharing

In this video I introduce a free tool that 1) helps you quickly identify the knowledge sharing opportunities in your organisation, 2) indicates where such an investment would yield the greatest return, and 3) helps you build the optimal learning strategy.

[Podcast] Breaking Silos in the Virtual Workplace

In this talk, Stefano Leone (IT communications and people strategy at Euroclear) sin improving collaboration and breaking down silo's in a tech-focused environment.

[Podcast] How to make the IT department redundant!

I recently appeared on the podcast of Marianne Rutz, a leading operational excellence consultant in the contact center industry. We talked about the future of IT services, and how to deliver real value to customers.

The three kinds of knowledge management

So you want to improve your IT team’s knowledge management. Where do you begin?

Nobody cares about the ServiceDesk

Traditionally, the ServiceDesk offers a safety net for IT users. But here's the thing: nobody wants a good safety net. They want to not need a safety net.

Shift-Left: getting started the right way

Many IT organisations are working to implement a shift-left of knowledge and capabilities. However, many of these initiatives don't deliver the expected results. To prevent this from happening to you, I’d like to share three pieces of advice to get started the right way.

[Case Study] 45% increased customer satisfaction at IT service company

We helped an IT company improve their service delivery. Within 6 months, the company saw 30% fewer complaints and incidents, 35% less rework, 45% higher customer satisfaction, and overall lower operating costs.


{{ popup_title }}

{{ popup_close_text }}