Skip to content

    Good data vs. Bad data

    6 March 2014 - Evotix

       

    Data drives the operations of today’s largest organisations and the mantra ‘what get’s measured gets managed’ has never been more important to health and safety management professionals. With new safety management software technology comes the opportunity to collect, analyse and compare data on near misses, the relative safety performance of branch sites and facilities, staff training levels and much more. Collecting great data leads to great safety management systems.

    But collecting data is one thing; acting on it another thing entirely, and you can’t act on it if you’re not collecting the right data in the right way. If you’re not using a database, instead relying on a Word or Excel health and safety management system, then I’m afraid you’re in no position to build a safety strategy around data.  SHE Software often meets with customers that manage data via lists in Word, tasks in Outlook with backup from Excel for reporting purposes. Word is great for documents and Excel is a titanic calculation or reporting tool, but neither comes close to what’s known as a relational database.

    Relational databases can track just about anything and relate one set of data to another, unlocking the door to in-depth analysis of trends and variations that are otherwise hidden from view. That makes for an extremely powerful safety management system.

    We’ve only ever come across a handful of company safety management systems using Word to manage workplace safety data but Excel is used much more commonly. However, while Excel is not really fit for purpose in the first place it is made less so by users putting too much information into a single cell. By segmenting data into separate fields it is of far more use, allowing for the sorting, querying and grouping of information for analysis and trend-spotting. This is exactly what a relational database does. Proper segmentation allows for potentially very powerful calculations to be made and there are not many limits on what can be done as long as data is accurately entered and correctly linked together – and this is the case for good data versus bad data.

    There is a famous maxim in the software world, if you like that kind of thing (and we do!): rubbish in = rubbish out. Similarly there is a world of difference between a health and safety management systems software with bad data and one with good. A purpose built database system for safety professionals will provide a lead on what data is useful and what isn’t, especially if it has been produced in partnership between the user’s organisation and the developers. This way you end up with a database that helps you to successfully direct your safety strategy – and your valuable time – to the proper places, where it can actually do some good.

       

    RELATED BLOGS

    usa2018manunet

    Future Directions: How Disruptive Technology Can Improve Safety Performance in the Manufacturing Industry

    6 September 2018 - Evotix

    According to the EHS Daily Advisor’s recent Annual Safety Report, employee engagement tops the list of safety challenges faced by manufacturing companies in the US.

    Blog
    Read Article

    The Missing Piece of the Health and Safety Jigsaw Puzzle Part 3: Data and Information

    18 June 2020 - Evotix

    The Health and Safety Jigsaw Puzzle is a combination of key pieces that can make a big difference in an organisation, especially when technology is added to the mix. In Part 1 and Part 2 of this blog..

    Leadership, Engagement, Data, Continuous Improvement
    Read Article

    The Missing Piece of the Health and Safety Jigsaw Puzzle Part 4: Informed Decisions

    25 June 2020 - Evotix

    What is the Health and Safety Jigsaw Puzzle? It is a combination of key pieces and technology that can make a big difference in organisational health and safety. In Part 1, Part 2, and Part 3 of this..

    Leadership, Engagement, Data, Continuous Improvement, Informed Decisions
    Read Article