5 reasons your organisation should have clean data

Questions about the FactsMany organisations constantly live with data issues, justifying it on the basis of “this is how things have always been” or “it’s too hard to fix the problem”. On the other hand, by doing a few simple things to resolve these issues, they can benefit much more.

Below are five reasons why every organisation should strive to have clean data in their systems:

1. Enhanced Decision Making

All your decisions will be based on accurate information, and not guesswork. And your decision making will be quicker, as you are not waiting for the data to be “fixed” before you receive it.

2. Improved Cooperation with your partners

You can confidently share information with your clients and suppliers, knowing it is correct. This is turn will improve the trust and cooperation between your organisation and it’s partners.

3. Saves Time & Money

You’ll spend less time fixing up issues in your reporting, budgeting, planning, schedules, etc., and in turn save money. Staff can be doing the higher value activities rather than fixing up data problems.

4. Improved staff morale

Your staff will feel less stressed and not be frustrated by having to deal with incorrect information, or having to fix up mistakes caused by poor quality data.

and finally, avoid the stick…

5. Keeps you out of trouble

As you aren’t misrepresenting facts and figures to your board, investors and regulatory authorities, you won’t get yourself or your organisation into a pickle.


Personalisation still has a way to go, but there is progress

Having read the article “Why Websites Still Can’t Predict Exactly What You Want” by Kaiser Fung, I am inclined to agree with his conclusion that companies are looking at their data the wrong way.

Instead of looking for commonality between groups of customers and making generic offers based on that, companies should be looking at the individual’s transaction history and profile to make offers that are better suited to individuals. In this case, offers do not have to be specials or discounts in the traditional sense, but simply suggestions that might be useful in the context of the transaction.

Where to next?

As to Kaiser’s point – Is it being ignore because it’s too simple? It’s not like the data doesn’t exist to make this possible. I believe it’s simply a case of companies not looking at personalisation through the eye of the customer.

The few good examples I have come across are in the travel industry, but these customised offers are generally made via email instead of online at the time of transacting. But there are more and more companies investing in personalising offers to customers, more notably in the retail space.

Recent Improvements to Evernote and Xero

Since I wrote about Working in the Cloud and the applications the we love using at Adaptive Consulting, there has been some significant improvements made across two of them. Below is a summary of what I love about these improvements and some additional information about them.

Files in Xero

As mentioned in that article, we love using Xero for our accounting needs. One new major improvement that was recently announced is the ability to store files in Xero (not just attachments). This feature in my opinion adds a tremendous amount of value to a business as it increases collaboration between small business owners and their financial advisors via a single tool.

Another feature which has been flagged as coming soon is the ability to email files to Xero and create bills from them. I’m eagerly looking forward to getting hold of this new functionality as it will be a massive time saver!

Read about the announcement on Xero’s blog at http://blog.xero.com/2013/10/attach-files-financial-data/.

Files for Xero from Xero on Vimeo.

Evernote 5 for Windows Desktop

Ever since Evernote announced that Evernote 5 for Windows Desktop was being released I’ve been looking forward to trying it out. When I finally was able to download and install it, it didn’t disappoint. There are a whole bunch of features that I love about it, including the new UI, the Shortcuts, the Smarter search functions, etc.

 The downside (and the single biggest gripe I have) with Evernote 5 for Windows Desktop is that it has a tendency to crash a fair bit. As with most things, I’m confident that this will be resolved as this new version matures.

 I also love this little graphic titled “100 Reasons to Love Evernote for Windows” to describe the core features http://blog.evernote.com/blog/2013/10/17/100-reasons-to-love-evernote-for-windows/.

The MOST Important Dashboard of them all

health_dashboard_200pxHaving spent quite a bit of time over the past month visiting various hospitals, I have come to the realisation that a dashboard that shows/monitors key indicators of the state of a person’s health is probably the most important dashboard of them all.

The heart rate, temperature, blood pressure, blood oxygen levels, etc are all vital signs that are monitored when someone is unwell and in hospital. If any these go below (or sometimes, above) their normal values there is cause for concern and usually triggers some action from the medical staff.

These dashboards or monitors have to be real-time. They also have to be accurate. Whilst most organisations would like their dashboards to be real-time and accurate, the consequences are rarely as bad as having a patient’s health deteriorate and no one knowing anything about it.

Dashboards in the Supply Chain – Manufacturing

Abfüllanlage Bottling plantManufacturing is another area in the supply chain for which you could have lots of KPIs that can be indentified and monitored. To a fair extent, a many of the KPIs for a warehousing operation also apply to a manufacturing environment, such as:

  • Monitoring the status of orders, including Priority Orders
  • Monitoring order turnaround times
  • Monitoring incidents on the production floor

Other items that could be monitored via a Dashboard in a manufacturing operation include:


Most manufacturing operations have productivity KPIs for staff, and by monitoring productivity via a dashboard in real-time will allow the company to identify and resolve any issues whilst they are occurring.

This information can also feed into trends, be it seasonal, type of product being manufacturing, etc so that adequate resources can be scheduled as required.

Raw Material Stock Levels

Whilst many ERP systems these days have real-time monitoring of stock levels and some have the ability to place orders automatically, it is still vital that planners are able to see what triggers these stock levels to run low and when. Any information they can gather about the items and their stock levels will assist with materials planning in the future and also guide them in adjusting the minimum stock levels.

Real-time monitoring via dashboards and/or alerts can provide input to this process.

Damaged Goods

Producing damaged good in the manufacturing process is a costly exercise as in some cases there is no option but to start again from scratch.

By monitoring any reported damages in real-time, the plant or factory manager will be able to identify the problem, analyse the cause and implement changes to reduce any further potential for damaged goods being produced.

Of course, the value of the goods being produced need to considered when implementing a monitoring process. Trying to fix the occasional damage in a low value item such as a plastic straw isn’t as important as trying to eliminate 5% of large crates turning up with defects.


Material wastage does happen in most manufacturing operations. However, identifying the causes of this wastage and trying to reduce or eliminate it will result in significant cost savings.

A real-time dashboard can be used to monitor how much wastage is being produced and if any particular workstations or machines is producing more waste than the others. In the case of a machine, it could indicate something as simple as a machine requiring recalibration!

Hopefully this is useful in some way and I would love to hear from you with any examples you wish to share.