Contact Us Direct - 07919 356 007
Support Services Direct
  • Home
  • Visualising Transformation
    • VT Case Studies
  • Services
    • Store
    • Pocket Books
  • Case Studies
    • Public Sector
    • Private Sector >
      • Private Sector Examples
  • Blog
  • Podcasts
  • About
    • Contact
    • Testimonials

‘We can’t do that’!

30/4/2015

0 Comments

 
How often have you or your organisations heard ‘we can’t do that!’? 

If it’s as frequently as we have heard it at SSD, you may have questioned the slow rate of change and progress organisations seem to make following assumptions about what isn’t possible.


The SSD team have extensive experience of progress being restricted by the beliefs held within organisations. We also have a lot of experience testing and changing such basic assumptions, enabling clients to stride ahead and achieve far more than initially imagined.

This blog provides a few examples and how they led to £M's savings...
Picture
A prime part of all the work we’ve conducted using our Visualising Transformation methods is the creation of clean information and knowledge from what starts out as ‘dirty data’. A subsequent activity is linking information streams together, often across departments, systems and agents to expand and share knowledge. This enables a more tactical, informed and less reactive approach to management to ensue.

The next in line are systems and processes, efficiency and effectiveness: Very few organisations use their existing ICT systems to full effect. Rarely are the multiple systems most organisations have evolved to include been developed so they join up or coordinate effectively to provide a flow of information from system to system, without repeated data entry activities (and of course a high level of data entry mistakes and the associated delays, rework etc. such mundane errors generate).

At SSD, we’ve been improving the connectivity between systems since 1988, when we connected Housing Repairs to Housing Client, to Stores to Financial and Management Systems. Later using a mantra of ‘enter data once, use many times!’

Following our experiences we’ve written a book covering just such issues. The book is called Visualising Transformation. On page 118 an example is provided of a frequently occurring issue highlighted through the workshops we run when leading transformation programmes. In this case we detail how a need to connect a static database to mobile devices had been denied for seven years … challenging some basic assumptions following the statement “You Can’t do That!”  we were able establish the connection required, with zero investment within three days.

Since then similar discussions about using CSV’s and what has come to be known as ‘middleware’ (Software that sits in between two other bits of software to act as a connector and translator) has allowed several massive databases in various clients, to be linked with other systems like GIS, CRM, SAP, Agresso, Triscan, Tranman and many others those in the Public and Service sectors will be familiar with.

You can buy specific middleware, like Crystal Reports, but very often you can use software already available at no cost … we have solved multiple issues by using excel and use its power to process .xml and .csv to act as middleware between different systems. You don’t need to know what a CSV is (a Comma Separated Values file) you just need to know it is often used by other databases and is supported by Excel … then it’s just a case of programming.

SSD’s MD, Dave Gaster was in discussion with a major software provider a few weeks ago, helping them understand the practical requirements of a number of local authority functions their software was failing to connect. The supplier was quoting £12,000 to alter some templates which would allow the authority to print and present some information in a different way.

It was quickly identified that the software was overdue a scheduled upgrade. Dave asked how much the alteration work would cost once the upgrade was installed. The supplier quoted £6,000. Dave suggested the data was exported from their system as a .csv file, imported into excel and printed from there. The supplier confirmed that was possible. It took around half a day to set-up.

We went on to discuss linking their system to SAP. With the upgrade it could be done for about £9,000. Dave suggested the Local Authority officers export a .csv file into Excel. This was identified as acceptable and enacted immediately, with ZERO cost!

This is just one example of many we have supported over the years. If you know how to export information from a database, it’s nearly always the case a common ‘language’ can be found and that information can be uploaded into another database. In many cases this can be automated making the same information appear on both systems seamlessly.

A few years ago another software house was trying to help a council make better use of their systems. That support came with quotes for the time and expertise required.  

We had experimented with SIS, Crystal Reports and the software companies system to create a layered architecture to share and act on information. In this way, we were able to produce higher quality information than the software house had been able to promise following their submission of a quote for a £100,000 project lasting eight months.

In our experience, what is often required to make significant improvements are a few key questions and some bright people who not only understand what IT systems are designed to do, but also what they can be enabled to do when they can be connected to share information!

One organisation saved over £1M per annum as a direct result of challenging the phrase “We can’t do that!” Several others have saved between 12% and 22% revenue costs by better scheduling contract work.



If you suspect you could reduce costs and improve efficiency through better connectivity within your organisation, we'd be happy to discuss how we can help.

Case Studies are available on request from Daveg@supportservicesdirect.co.uk  they are also available for download from our website at http://www.supportservicesdirect.co.uk/case-studies.html

NOTE Visualising Transformation is a ‘Way of Working’ (WoW) that takes information within a system and translates it into relevant meaning for the people involved, enabling clarity and better, faster decisions.

VT acknowledges that everything is connected and sustainable change comes from a better view of systems.

We would love to hear your thoughts.

For all enquiries contact daveg@supportservicesdirect.co.uk


0 Comments



Leave a Reply.

    SSD Blog

    Visit regularly to see the latest thoughts provoked by the world of change in the public sector and supply chain.

    Archives

    February 2018
    October 2017
    June 2017
    September 2016
    August 2016
    July 2016
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    October 2014
    July 2014
    March 2014
    January 2013

    Categories

    All
    Child Abuse
    Child Protection
    Cost Saving
    Delivery
    Effectiveness
    Efficiency
    Highways
    #IEWMconf14
    Innovation
    Inter Agency
    Lean
    Links Between Agencies
    Passenger Transport
    Pot Holes
    Public Sector
    Quality
    Refuse
    Social Care
    Systems Thinking
    Virgin Media
    #VTAMfL
    Waste Collection

    RSS Feed

Our Services

Transformation Services
Interim Management
Project rescues ... for
Local Authority, NHS, Service Sector and businesses 

Company

We are based in Brackley, Northamptonshire.
With consultants transforming services across the UK.

Contact us

Contact Us
T: 07919 356 007

Copyright © 2015 | Registered in England | Company Number 4800525 | Vat No. 823664522