Do It Clean

If you do the Twitter thing, follow me at @HousingITguy
or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy


If you have ever migrated systems, you will have certainly encountered the concept of ‘Data Cleansing’. It’s a strange abstract oddity, I think. The whole idea of having to do it reveals our users, managers & staff, pretty much total distain for data.

How often do we ‘cleanse’ our clothes? Well, quite often, we don’t wait for Christmas or the holidays, to put them through a 30-degrees wash & spin, with integral tumble dry. We should not treat our data that way either.

‘Data Cleansing’ needs to be a continual process and all staff need to be confident about the value of data. Why it should be accurate, the cost of it not being, or falling into the wrong hands. It’s often said that people, (not paper clips stupid!), are the most valuable commodity in an organisation. While staff & people are crucial, data is of the highest value and we forget that at our peril.

So, get the message out to your staff. It’s their job to look out for data, it’s quality, security and relevance. Not just for some one-off clean up, migration or to get ready for some audit or IDA. If we deem staff responsible enough to amend/correct data, then empower them to be able to do so. Where staff cannot, let them escalate issues to the responsible team or person, with a mechanism to get changes completed. If those requests fall on deaf ears, there is a danger that system data may no longer be believed, or it will seem a waste of time in the future, to escalate issues for correction.

GDPR makes data, its use, value and access, even more important in our organisations. The truth is, without data that can be used as information easily, most businesses cannot function efficiently. Once our managers and staff grasp that we will excel with higher productivity and more satisfied customers. If I were you I would start that journey to doing it clean, as soon as you can.

Related Post: If you are using EDRMS, have you destroyed your paper originals? If not, why not? 

Catch the blog monthly archive at https://soundcloud.com/housingitguy/

_/_/_/_/_/_/_/_/

I would be pleased to connect with you on LinkedIn - http://uk.linkedin.com/in/tonysmiththathousingitguy Message me with any issues or queries, you would like to be explored in this blog. We generally receive a couple of suggestions each month.

Echo And The Bunnymen – Do It Clean.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009


Access a quick list of our Social Housing ICT blog posts here

Could we help you or your organisation? Our contact details are here , get in touch we will be pleased to chat about your problems and help with your organisation issues.
File Under: 360,1stTouch,4Js. , 07854655009 ,365Agile," """" ",,#UKHousing,#HousingDAY, #HomesForBritain,#InternetOfTenants, #Shout,1st Touch,3squared,Accuserv,Acutence,Aareon,Academy,ActiveH,AirWatch,Alignment,ALMO,Anite,Apex,ArchHouse,Archouse,asbestos, Asprey e-state pro,ActiveHousing,Asset Management,Aurora,Average IT Costs,App,Associates,ACL,Abritas,AMS,AX,aspireview,Agile365, BO,BPR,Browser Applications,Business Objects,Business Planning, Business Process Review,Business social networking, Blockwise, Block wise,BI,BancTec,BluTek,Bluebox, Castle,CBL,Cedar Open Accounts,Cx,Change,Cheaper Housing IT,Chics, CHR,Citrix,Civica,Clearview,CMS , CCS IT Keystone CCSIT,Civica Genero,Contractor Systems,CORE,CorVu,Cost Reductions,Covalent,CRM,Crystal Reports,CTI,CTX,Customer Relationship Management,Cashflow, COA,Coactiva,Codeman,Comino,Competitive Dialogue process,complex IT procurements,Component Accounting, Community Reward Services, Consilium, Consolidation, Consultancy,Consultant,Contact Manager,Context,CIH,Chartered Institute Of Housing,Cadcorp,Cerrus Saturn,convergeOne,CACI,CPL, CRS Director, Deeplake,Development Systems,Accuserve,Document Management,Documotive,datasystems , Microsoft dynamics GP 2013, DynamicAI, Dynamic AI, ECMK,EDRMS,England, English,EnterpriseBI,ERP Systems,ERP,Elmhurst,Estatecraft,EDM,ESRI,Exponential-e, Finance, Financial Systems, Financials, Factorwise,Facebook ,Footprint,Fusion, Getting best from,gotonysmith, Grasp,Grip,GeoSolveIT,GIS,GGP,Genero,GCloud,G-Cloud,HouSys,Housing software,HFI (Housing Financials interface),HG,Housemark survey,Housing Blueprint,Housemark,Housing Portfolio Management System, HRA,housingtITguy,Housing Support Pro,HousingSupportPro,Housing Options,Hometeam, Housing Group,hotpixuk, HousingIT,hotpix,Hardware,Hitex,Housing Contact Company,housing predictive analytics, Impact Response,iPayPro,implementations,iRobot,In House,InHouse,In4,InMotion, InMotion2016, InMotion2015, InMotion2016 , Exhibition, conference,Housing Management Consultant,Housing Management Consultants, Infoflow,Information Technology,Informix,inHouse,in-house workforce,Information@Work components, Innovation,Inside Housing,Internet Portal,Internetalia,Information Management Server,IMS, Invu,Ireland,Irish,Inphase , IT Budget,IT Training,iWorld, Innovation Group Apex,ITIL, In4Systems Promaster,IT,Insight, iSupport,iSupportPro, Keylogic,Keystone,Kirona,Kypera,Keypera Hometeam,Keyfax,Ledgers,Linkedin,Locality,Liquid Voice,MD ,Mr Void , MrVoid, Measuring Change,Mebus,Miracle,MISCS,mDesign,mobile functionality,mobile platform,Monopoly board images and pictures, Montal,MS Dynamics,MS Dynamics CRM2011,Miracle Software,MDM,Management,CRM2013,Reporting,MI,M3,MIS,MIS-AMS,Mobysoft, Northgate Codeman,Neighbourhoods and Communities,NPS,NPS Housing,NPS CRM,NPS Job Manager Mobile, Northgate,NEC,Notice,NROSH,NINTEX,NINTEX workflow,Natural Forms,Nintexworkflow,NPS ASSIST, OA,OGC Buying Solutions,Ohms,OJEU Limits,OmFax,Omniledger,Open source software,open tender,OpenHousing,Opti-time,Oracle,Orchard,Optitime DRS,Outsource and outsourcing,OpenContractor,ORS,OneServe, PIMMS Data Systems, Paloma,performance management systems,PfH, Pick,PIMMS,pimms4communities, Planned maintenance,People Value,Plus, Peoplevalue,Portfolio Management System, PM,Progress,Promaster,Proval,Pyramid,PRINCE2,prince,Pamwin,PlanForm, Propoints, Pro-Points,predictive analytics for housing, QL,QLX,Quiss,Qlikview, QueryView,Queryview reporting,Registered Providers,Registered Social Landlord,Rent Increase Freezes,Repairfinder,Reporting,Reports,ROCC,RobotAutomation,Rave Technologies (India) PVT Limited, Rocket,RPs,RSL,Reality,ReAct,reidmark,RM865, Saffron,SAP,Scots, "Social Housing IT",Social Housing ICT, Scottish,Scenario, Scotland,SDM,sector,TonySmithHou,Safron,Server Virtualisation,servicing, Servitor,Sharepoint, Simdel,Simdell,SimPro,Sim Pro,Slash and Burn,Social Media,Software,SQL Open Housing,SQL Reporting Services,SQL reporting services,SQL Server,Star rating,Stores and Stock,Strategic Asset Management,Sunguard ,Surveys,Sx3,System alignment,Symatrix Human Capital Management, TonySmithHousing, Systemwise,SM,Sequoa,Serros,SP,Scout,score,Swordfish,Serengeti,SOTI,southview,Sunguard,Service Charges,Spotlight Service, Spotlightservice, SunAccounts, Social Housing Software Applications, Template,Task,Terminal Services, tonys , tonysm , tonysmi , tonysmith, tonysmitht, gotonysmith, tableau Business Dashboards, tonysmithth, tonysmiththa, tonysmiththat, tonysmiththath, tonysmiththatho, tonysmiththathou, tonysmiththathous, tonysmiththathousi, tonysmiththathousin, tonysmiththathousing,Tony Smith That,Tony Smith That Housing IT Guy,TonySmith that housing IT, guy,tonysmiththathousing, tonysmiththathousinguy,tony smith housing guy,sharepoint, share point, SHBVN, Three Star,Today,Total repairs,Tribal,Twitter,U2, tonysmith , tonysmiththat , thathousing , thathousingIT , thathousingITguy, TED,Tagish Casework,TP Tracker,Telecetera,Tagra,Trace, Totalmobile, Total Mobile, UniClass Enterprise,Unidata,Universal Housing,Universalcredit, universal credit, universal credits,UC,Universe,Unrest, UK, United Kingdom ,Ukhousing,UK Housing, Van Stock,Voice and data,Vantage Sentinel,verse one,verseone,vWork,Version One,Visualmetrics,Valueworks,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley,Works Connect,worksConnect, Xmbrace,XML ,XenApp,Xen App ..

Come Together

If you do the Twitter thing, follow me at @hotpixUK
or LinkedIn here http://uk.linkedin.com/in/tonysmiththathousingitguy

Looking back 10-15 years there seemed to be many more RSLs out there. Much of their stock is still out there, but now they are most likely to be part of a larger group. Some might still retain their individual character and personality, but many are just now branded as their parent group name.

All of those smaller entities will have used their own housing management system and chances are, in a group structure, (many that I know anyway), 3 or 4 different systems, plus 20+ other applications are in use. Even just two RSL's under one groups' roof can mean perhaps an eye-watering annual maintenance bill for IT support and doubled up hardware or hosting.

Apart from obvious savings from merging to a single ERP or HMS, if done well, this can be an excellent project to provide 360 degree CRM, 'One version of the truth' reporting, integrated mobile and common, streamlined processes. The latter, a real requirement for great KPIs that can be measured across all group areas. Summed up in that short paragraph, you might ask, "Well how hard can that be?".

A vision need to be presented to captivate and motivate managers sometimes to see what the journey might be like and the benefits for each strand along the way. It's common for peoples' day job and current issues to anchor them in current problems. This being a barrier to going forward. "Well we get by now don't we, with our IT", is a phrase I had £50 for over the years, I hear it so frequently. Aligning IT with the corporate and board objectives, via a robust gap analysis, is a great way to make people realise how bad their current ICT is. A big migration/consolidation project is an expensive undertaking, but one that will underpin those 5 year objectives and the 10 years beyond that.  

That was the theme of a chat I had with someone at the Manchester CIH Conference this week. We all knew of groups where processes had been really researched and nailed down, such that new joiners could be assimilated very quickly. Also, one where I have done a lot of work, where newbie's almost can pick from a menu, which elements of the head office support & IT structure they will take on signing up. That's all well and good where really good process mapping has taken place. An exercise that can often be accelerated by using an external resource, with good housing and specific system skills.

In some cases 'change' can be very scary for staff. Even after choosing systems, it can be difficult to escape that silo mentality. You know, that 'I prefer my spreadsheet here...' approach. Middle manager & director jobs might be at stake. I have seen managers try to stamp their mark over processes and systems, just to stay in the mix. This might be regardless of if the systems in place could be easily configured to do it better. Outside help here can bring some realism too, issues around this are often not revealed until after go live, when the supplier is asked, "Why are we still doing it this way then?".

Everywhere I go, I am creating change and I realise that at all times, its useful to keep everyone's eye on the big picture, to keep them signed up. One example is CRM. A bit feared if departments are not now going to deal with specialist calls anymore. A: You will deal with the specialist issues, but not all those little chasing calls that really should be answerable by looking in our system. Now isn't that better? The customer support team can be provided with all the intelligent script support they need, so in 85%+ of cases, they solve the tenant/customer issue first time.

Quality of data is another gotcha. I have worked with many organisations where they swore that individual system data could not be merged consistently and accurately. Cross-referencing of data is always a job to do, when moving to a single system, but so is data cleansing. Without this essential element, or help in this area, your new integrated systems will not get the clean fresh start they deserve. Of course, this will help make your data consistent when you come together on one system. In the end everyone will wonder what all the fuss was about....

Read on to: Are your systems really so agile?

_/_/_/_/_/_/_/_/

You can link with me on LinkedIn here - http://uk.linkedin.com/in/tonysmiththathousingitguy It would be great to connect !

Primal Scream - Come Together.
(c) Tony Smith, Acutance Consulting www.acutanceconsulting.co.uk 07854-655009

PS As usual, if there are subjects you might like me to tackle on this blog, please get in touch and let me know!

File Under: 360,1stTouch,4Js. 07854-655009 , 07854655009 , 07854 655009 ," ""07854 655009"" ",07854-655009,#UKHousing,1st Touch,3squared, Acutence,Aareon,Academy,ActiveH,Alignment,ALMO,Anite,Apex,ArchHouse,Archouse,asbestos,Asprey e-state pro,Asset Management,Aurora,Average IT Costs,App,Associates,ACL,Abritas,AMS,AX,aspireview, BO,BPR,Browser Applications,Business Objects,Business Process Review,Business social networking, Blockwise, Block wise,BI,BancTec,BluTek,Bluebox, Castle,CBL,Cedar Open Accounts,Cx,Change,Cheaper Housing IT,Chics, CHR,Citrix,Civica,Clearview,CMS , CCS IT Keystone CCSIT, Contractor Systems,CORE,CorVu,Cost Reductions,Covalent,CRM,Crystal Reports,CTI,CTX,Customer Relationship Management,Cashflow, COA,Coactiva,Codeman,Comino,Competitive Dialogue process,complex IT procurements,Component Accounting,Consilium,Consolidation,Consultancy,Consultant,Contact Manager,Context,CIH,Chartered Institute Of Housing,Cadcorp,Cerrus Saturn,convergeOne,CACI,CPL Director, Deeplake,Development Systems,Document Management,Documotive,datasystems , Microsoft dynamics GP 2013 ECMK,EDRMS,England, English,EnterpriseBI,ERP Systems,ERP,Elmhurst,Estatecraft,EDM,ESRI,Exponential-e, Finance,Financial Systems,Financials, Factorwise,Facebook ,Fusion, Getting best from,gotonysmith, Grasp,Grip,GeoSolveIT,GIS,GGP, HouSys,Housing software,HG,Housemark survey,Housing Blueprint,Housing Group,hotpixuk, HousingIT,hotpix,Hardware,Hitex,Housing Contact Company, Impact Response,implementations,In House,In4,InMotion, InMotion2014, InMotion2015, InMotion2016 , Exhibition, conference, Infoflow,Information Technology,Informix,inHouse,in-house workforce, Innovation,Inside Housing,Internet Portal,Invu,Ireland,Irish,IT Budget,IT Training,iWorld, Innovation Group Apex,ITIL, In4Systems Promaster,IT,Insight, Keylogic,Keystone,Kirona,Kypera,Keyfax, Ledgers,Linkedin,Locality,Liquid Voice, MD ,Mr Void , MrVoid, Measuring Change,Mebus,Miracle,MISCS, mobile functionality,Monopoly board images and pictures, Montal,MS Dynamics,MS Dynamics CRM2011,Miracle Software,Management Reporting,MI,M3,MIS,MIS-AMS,Mobysoft, Northgate Codeman,Neighbourhoods and Communities, Northgate,Notice,NROSH,NINTEX , NINTEX workflow,Nintexworkflow, OA,OGC Buying Solutions,Ohms,OJEU Limits,OmFax,Omniledger,Open source software,open tender,OpenHousing,Opti-Time,Oracle,Orchard,Outsource and outsourcing,OpenContractor,ORS,OneServe, PIMMS Data Systems, Paloma,performance management systems,PfH,Pick,PIMMS,pimms4communities,Planned maintenance,People Value,Plus,Peoplevalue,PM,Progress,Promaster,Proval,Pyramid,PRINCE2,prince,Pamwin, QL,QLX,Quiss,Qlikview, Registered Providers,Registered Social Landlord,Rent Increase Freezes,Repairfinder,Reporting,Reports,ROCC , Rocket,RPs,RSL,Reality,ReAct,reidmark,RM865, Saffron,SAP,Scots, Scottish,Scotland,SDM,sector,Server Virtualisation,servicing, Servitor,Sharepoint,Simdel,Simdell,Slash and Burn,Social Media,Software,SQL Open Housing,SQL Reporting Services,SQL reporting services,SQL Server,Star rating,Stores and Stock,Strategic Asset Management,Sunguard ,Surveys,Sx3,System alignment, Systemwise,SM,Sequoa,Serros,SP,Scout,score,Swordfish,Serengeti,SOTI,south view,Sunguard,Service Charges, Template,Task,Terminal Services, tonys , tonysm , tonysmi , tonysmith, tonysmithth, tonysmiththa, tonysmiththat, tonysmiththath, tonysmiththatho, tonysmiththathou, tonysmiththathous, tonysmiththathousi, tonysmiththathousin, tonysmiththathousing, tonysmiththathousingg, tonysmiththathousinguy, sharepoint, share point Three Star,Today,Total repairs,Tribal,Twitter,U2, tonysmith , tonysmiththat , thathousing , thathousingIT , thathousingITguy ,TED,Tagish Casework,TP Tracker,Telecetera,Tagra,Trace, UniClass Enterprise,Unidata,Universal Housing,Universalcredit, universal credit, universal credits,UC,Universe,Unrest, UK, United Kingdom ,Ukhousing,UK Housing, Van Stock,Voice and data,Vantage Sentinel,Version One,Visualmetrics,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley, Xmbrace,XML ,XenApp,Xen App