or LinkedIn here https://uk.linkedin.com/in/tonysmiththathousingitguy
During my first few years working with Social Housing Systems, I was involved in a lot of full integrated solution implementations. I still surprise suppliers when pulling them up on implementation and data extract/transformation processes. You soon learn how to locate trouble-some and hidden data and use tried and tested approaches to clean it up and present it in the best form possible, for a brand new system.
Strangely, lately I have been involved in a raft of data conversion work, for Housing Groups merging systems or new properties in, and for a few organisations, taking their first housing solution.
That all covers the relatively structured stuff. Even Excel spreadsheets have some structure, however possibly haphazard. I am used to telephone numbers, containing comments, like (work) or (Daughter – Mon-Thu only) etc. Notes and scratch pads are another matter. Free text is of course notorious and using conventional database languages, a bugger to report from. I often come across sensitive data in text and note fields. Historic account references, person details, credit card data, sort codes and others. Some of it innocently blows PCI compliance right out of the window.
The above of course refer to database info. IE in SQL Server, Progress, Oracle, Ingress or Informix etc. Every organisation also has Terabytes of data held on local, network and cloud drives, as well as local Exchange Server storage. Once you start looking, unfortunately you start to see sensitive data in the strangest of places. Fascinating that all this is, within the recent GDPR rules, we should be managing every single byte of sensitive data that we own. Much of it is historic, and a lot down to poor user training and poorly managed habits.
|Innocent recording of card/payment details in free text notes are a major Achiles Heal for GDPR compliance|
Searching just a small corner of your unstructured data, can take several days and then you only just scratch the surface. You would need a small army (well maybe a platoon), to do a proper job, then keep on top of it too. Data quality groups are something I always promote, wherever I can, but they have a limit to their vigilance. For a few years I have been actively seeking some more intelligent solutions, to help crack this one.
Last month I think I spotted a pretty comprehensive, proven tool to do the job, called InfoBoss. You don’t need an army of people either, to feed and water it. Just a few pioneering Social Housing landlords are currently using it, in addition to at least one credit rating agency in the Midlands.
It pretty much sniffs out the problems by itself with a set of inbuilt rules, that can be activated to detect data in the wrong place, suspect data problems and breaches of GDPR policy, such as ‘Right To Be Forgotten’. Integral white and black lists enable checking for what should have been long since archived ID’s, that potentially are breaking the law.
The tool has been built on Elastic Search, the platform is scalable, cloud based and quick to setup and very easy to use. Once it has been pointed at a multitude of data sources, within an organisation, it will collate details into a single reportable repository. A messaging API allows set up of automation. Stakeholders can be created that are automatically alerted on new and newly discovered exceptions.
I’m techie, but it’s clear this is more of an end-user, than an ICT team tool, all in a private cloud too. Check it out by contacting Mark Hobart of InfoBoss or download the InfoBoss data management whitepaper.
|Download the InfoBoss white paper here|
If you have or suspect you may have data quality issues that possibly contravene GDPR, this is clearly a new tool worth a look.
Do mention you read it first on this blog and please let me know what you thought of it too.
|Catch the blog monthly archive at
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.
The Shamen – Boss Drum.
(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: #HomesForBritain,#HousingDAY,#InternetOfTenants,#Shout,#UKHousing, 07854655009, 1st Touch,1stTouch,360,365Agile,3squared,4Js, ACL,ALMO,AMS,AX,Aareon,Abritas,Academy,Accuserv,Accuserve,Active Housing,ActiveH,ActiveHousing,Acutence,Advanced,Agile,Agile365,AirWatch,Alignment,Allpay,Amazon Web Services,Anite,Apex,App,ArchHouse,Archouse,Asprey e-state pro,Asset Management,Associates,Aurora,Average IT Costs,AWI SX Integration Toolkit,AWS, BI,BO,BPR,BancTec,BigChange,Blockwise,BluTek,Bluebox,Blueprint,Browser Applications,Business Objects,Business Planning,Business Process Review,Business social networking, CACI,CBL,CCS IT Keystone CCSIT,CHICS,CHR,CIH,CMS,COA,CORE,CPL,CRM,CRM2013,CRS,CTI,CTX,Cadcorp,Capita,CapitaOne,Capita One,Capital Management,Cashflow,Castle,Castleton,Castleton Technology,Cedar Open Accounts,Cerrus,Change,Charges,Chartered Institute Of Housing,Cheaper Housing IT,Chics, Citrix,Civica,Civica CTX,Civica Cx,Civica Genero,Civica Saffron,Clearview,Clik,Cloud Dialogs,CloudDialogs,Coactiva,Codeman,Comino,Commontime,Community Reward Services,Company,Competitive Dialogue process,Component Accounting,Consilium,Consolidation, Consultancy,Consultant,Consultants,Contact Manager,Context,Contractor Systems,CorVu,Cost Reductions,Covalent,Crystal Reports,Customer Relationship Management,Cx, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Dynamic AI,DynamicAI,Dynamics 365, ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Etive,Exhibition,Exponential-e, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,Footprint,Forms,Freezes,Fusion, Gas Tag,G-Cloud,GCloud,GDPR,GGP,GIS,GasTag,Genero,GeoSolveIT,Getting best from,GoTonySmith,Grasp,Grip,Group Apex, HFI (Housing Financials interface),HG,HRA,Hardware,Hitachi Systems,Hitex,HomeMaster,Hometeam,HouSys,House,Housemark,Housemark survey,Housing,Housing Contact,Housing Group,Housing Insight,Housing Management,Housing Management Consultant,Housing Partners,Housing Portfolio Management System,Hub Asset Management, Housing Support Pro,HousingIT,HousingSupportPro,HyperOptic, IMS,IT,IT Budget,IT Training,ITIL,Impact Response,In,In4,In4Systems Promaster,InfoBoss,InHouse,InMotion,InMotion2015,InMotion2016,InfoBoss,Infoflow,Information,Information Technology,Information@Work components,Informix,Innovation, Informetis,Inphase,Inside Housing,Insight,Internet Portal,Internetalia,Invu,Ireland,Irish,itLab, Keyfax,Keylogic,Keypera,Keystone,Kirona,Kypera, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MAVIS,MD,MDM,MI,MIS,MIS-AMS,MISCS,MRI,MS Dynamics,MS Dynamics CRM2011,MWL,Management,Management Server,Manifest,Measuring,Mebus,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid, NDL,NINTEX,NINTEX workflow,NPS,NPS ASSIST,NPS Housing,NPS Job Manager Mobile,NROSH,Natural,Neighbourhoods and Communities,Nintexworkflow,Northgate,Northgate Codeman,Northgate Public Services,Notice, OA,OGC Buying Solutions,OJEU Limits,ORS,Ohms,OmFax,Omniledger,One,OneAdvanced,OneServe,Open source,OpenContractor,OpenHousing,Opti-time,Options,Optitime,Oracle,Orchard,Outsource and outsourcing,OutSystems, PIMMS,PIMSS Data,PM,PRINCE2,Paloma,Pamwin,PanConnect,People Value,Peoplevalue,PfH,Pick,PlanForm,Planned maintenance,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propoints,Proval,Providers,Pyramid, QL,QuantSpark,Qube,QLX,Qlikview,QueryView,Queryview reporting,Quiss, RM865,ROCC,RPs,RSL,Rave,ReAct,Reality,RedkiteCRM,Red Olive,Registered,Registered Social,Rent Increase,RentSense,RentSenseLite,Repairfinder,Reporting,Reports,RobotAutomation,Rocket, Salesforce,Salesforce.Org,SAP,SASSHA,SDM,SHBVN,SM,SOTI,SP,SQL,SQL Open Housing,SQL Reporting,SQL Server,Saffron,Safron,Saturn,Scenario,Scotland,Scots,Scottish,Scout,Sequoa,Serengeti,Serros,Server,Service,Services,Servitor,Sharepoint,Sim,SimPro, Simdel,Simdell,Slash and Burn,Social Housing ICT,Social Housing Software Applications,Social Media,Software,Software solutions,Spotlight Service,Spotlightservice,Star rating,Stores and Stock,Strategic,SunAccounts,Sunguard,Surveys, Swordfish,Sx3,Symatrix Human,System alignment,Systems,Systemwise, T-Files,TEAMS,TED,TFiles,TP Tracker,TSG,Tagish Casework,Tagra,Task,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Today,Tony Smith,Tony Smith That Housing IT Guy,TonySmith that housing IT,TonySmithHou,TonySmithHousing, ,TonySmithHousingITguy,Total,Total Mobile,Totalmobile,Trace,Tribal,Twitter, U2,UC,UK,UK Housing,Ukhousing,UniClass Enterprise,Unidata,United Kingdom,Universal,Universalcredit,Universe,Unrest, Valueworks,Van Stock,Vantage,Vantage Sentinel,Version,Virtualisation,Visualmetrics,Voice,Voice and data,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, ...