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 at first, but really adds up over time.

So, 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 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. 



23 December 2023

Metaknowledge Part VII : Governance

This part provides an overview of the different methods and tools to ensure a successful KM program.

Metaknowledge Part VI: Technology

Metaknowledge Part V : Roles

A deep dive into the different roles involved in each of the knowledge management activities.

Metaknowledge Part IV: Process

An in-depth examination of the processes and practices related to the four knowledge management activities, with examples for each.

Metaknowledge Part III: The 4X4KM knowledge management framework

This part of the Metaknowledge Guide provides the 4X4KM framework, based on the four core KM activities. This framework is an invaluable tool in organizing your KM, and keeping your efforts focused and productive.

Metaknowledge Part II: The three kinds of knowledge management

This part of the Metaknowledge Guide outlines the the three kinds of knowledge management, and how knowledge management relates to learning & development.

Metaknowledge Part I: Knowledge, Information, and Data

A practical, intuitive interpretation of "knowledge", and how it compares to information and data. This will help you position knowledge management in relation to information management and data management in your organisation.

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.

How we used Digital Transformation to improve construction projects

Here's the story of how we used process analysis and digital transformation to speed up construction project initiation.

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.

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?

[Interview] 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.

[Interview] 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.

[Interview] The future of IT services

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.

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 }}