Showing posts with label data quality. Show all posts
Showing posts with label data quality. Show all posts

Sunday, 27 August 2023

Policeman Data Skank

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


I don’t know what crossed your mind a few weeks ago when you heard about the recent UK big data breaches. On the Monday was a loss of millions of names from the UK Electoral Roll. 40 million voters in fact from hackers - Full article here. I suppose that does make a difference for our government to not be trying to be selling it this time!

A few days later came the PSNI data breach, of every serving police officer in Northern Ireland. - Full article here.

The day after that came Norfolk and Suffolk police, fessing up over another data breach consisting of personal details of 1,230 victims, suspects and witnesses - Full article here

While the first one was apparently a successful hack attempt, (we are familiar with some of those in social housing), the second two look more like spectacular own-goals, that would have needed Mary Earps England’s ‘Queen of Stops’ to try to effectively prevent. These were both cases where the police authorities apparently responded to freedom of information (FOI) requests, for summary data. IE number of cases, totals of police staff and roles etc.

They say a little knowledge is dangerous and that would certainly be true if that data was extracted into Excel perhaps (a tool we all love a little too much),  and a pivot table/formulas created for creating the summary totals. To be compliant with a FOI request they could have easily supplied a short PDF of the totals page. To share way too much data we could provide the much bigger spreadsheet and inadvertently and criminally overshare.

In the case of the PSNI data breach, it could not have been much worse a mistake.

I have worked a lot over in Northern and Southern Ireland over the last 25 years.  When I first traveled there, they had barely dismantled the British army checkpoints outside Belfast international airport. I have 100% always had positive and uplifting experiences with all sides of the communities I have worked with and received care and generosity throughout. Belfast and other places have improved immensely. Offices and property blocks have plate glass on the outside again and hen parties cycle around city centres on big beer/gin bikes. Its one of my favourite corners of these isles.

One institution in society that still polarises there is the PSNI. Once called the RUC reflecting just one part of society, its new incarnation is still extremely suspicious to both communities, nearly 22 years on:

Loyalist community suspicion

Republican community suspicion

In terms of putting people at risk and drastic effect on safety, over twenty thousand ordinary people doing some very dangerous jobs have been put in even more danger. Perhaps all down to lax training of admin staff on GDPR, our responsibilities to it and how they are to use software tools handling our data.

It wouldn’t be the first time I have encountered organisations doing a well meaning GDPR induction, yet with no practical advice of how and where to store data and the importance of it being accurate, succinct, consistant and well controlled. Its probably the subject of another future post or two, but we do give staff tools such as Excel and barely train them on it (if at all). No wonder they try to use it like a database and have no idea what they might inadvertently share using it. With such lack of knowledge, staff should be banned from using the common off the shelf excuse, “I cant do that due to data protection!”.

So, could these last two types of gaffs happen easily in your organisations?

How well do you induct and keep all staff aware of GDPR?

How do you induct staff on how your systems and storage needs to be used consistently for good data hygiene?

How well do you control information access and controlled release, particularly of sensitive data?

If you have any doubts on the above, please take action right now, before your organisation makes some rooky mistakes and we can all watch its gory details examined on Newsnight and Sky News.

If you are struggling with getting your GDPR in order, or replacing spreadsheets with systems or databases, just get in touch with us.

Subscribe to our blog here on this link, to always catch the latest news on whats happening in the sector.

Acutance Consulting would be happy to help you review systems options, 
please just get in touch, for a chat over a ginger nuts & a brew 😋

       Related Post: Thoughts on getting Right To Forget right


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

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.

Audioweb – Policeman SkankAudioweb – Policeman Skank.
(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,Affinity,Agile,Agile365,AirWatch,Alfresco,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,Capita One Housing,CBL,CCS IT Keystone CCSIT,CEDRM,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,Cx Assets, 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,Docuware,Dynamic AI,DynamicAI,Dynamics 365,D365,Dynamics365, 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,Fuzzlab 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,Homeswapper,Housing jigsaw, 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,Keynamics, Landlord,Ledgers,Linkedin,Liquid,Locality,Localz, M3,MAVIS,MD,MDM,MI,MIS,MIS-AMS,MISCS,MRI,MS Dynamics,MRI,MS Dynamics CRM2011,Microsoft365,microsoft 365,MWL,Management,Management Server,Manifest,Measuring,Mebus,More IQ,MoreIQ,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid,MoreIQ 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,Plenfific,Plus,Portfolio Management System,PowerObjects,Pro,Pro-Points,Prodo,Progress,Promaster,Propoints,Proval,Providers,Pyramid, QL,QLX, QLF, QL Yuneo,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,Rubixx, 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,Streetwise, Swordfish,Sx3,Symatrix Human,System alignment,Systems,Systemwise, T-Files,TEAMS,TED,TFiles,TP Tracker,TSG,Tagish Casework,Tagra,Task,TAIM,Technologies (India) PVT Limited,Telecetera,Template,Terminal Services,That,Three Star,Tilt,TiltAffinity,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, Yuneo, ...
. . . . . . . . . . . . ES | FR | DE | IT | UK |

Sunday, 22 April 2018

For The Want Of A Nail

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



Predictive analytics look to me to becoming Social Housing's next 'Self-serve' or 'staff mobile working'. The latter pretty much now being rolled out by pretty much all forward thinking landlords. I have recently written a whitepaper on predictive analytics for arrears case management. Definitely one area which I would take a proven solution off the shelf.

But how should you go about building a model yourself, for other purposes? What might be the gotcha's that are worth thinking about?

Well the first one for me would be focus carefully on your end-game. As I have heard it described quite well, by one data scientist friend, don't build yourself a rather elaborate hammer, then go looking for your nail. Predictive Analytics is a current buzzword, much like 'Digital Strategy' was until recently. At least most organisations understand what the latter practically means now. Before setting out, know what most of your outcomes are going to be.

Next, when you have some outcomes in mind, check your available data supports it. Easier when you start with a well integrated set of systems. Do get in touch with me directly if you still haven't cracked that one. Never try to structure a project around data you just don't have. Ask that crucial question before you start. Where specific data is missing, there may be the opportunity to generate it or collect it specially. You might want to target a particular sub-set of residents/customers, to have reliable data to utilise.

Data quality is the next gotcha. Assume a good deal of your data will be of poor quality. That need not hold you back. Many projects have been delayed until data is thought to be 100% correct. Believe me, you won't have 3 years or more to get to that point. I would urge you to cautiously work with what you have and enforce a data culture to constantly improve it, in parallel to any predictive analytics project.

Assume too, that you will find even more poor data, as you build models & work with it. I have lost count of the number of tenancies & works order requests, with end dates before start dates etc. If your data cannot be corrected, filter it right out, lest it skew models.

One example I heard about, management were too bullish about the apparent good quality of data. After being advised that data cleansing was required in the project, this was dismissed to shorted timescales, against the advice of consultants. Later when poor data quality was revealed, and more time needed to be added to extend the project, to achieve outcomes, it became a credibility issue for the director involved. Don't be caught out by too much good news, hiding the bad.

Finally, when your lovely shiny predictive analytics model is built, ensure you have planned a proper deployment phase. It is not enough that you have 'built it and so they will come'. Work out how you are going to tell the wider organisation what your model can do and seed their imagination as to how they can apply it to their own department issues and decision making. Find out what their particular nail will be, to which they can apply your new shiny hammer.

I promise, soon I will post on what typical calculations for SocialHousing, might work for us, and how this might affect process.

Related Post: Sick of your housing management system? Why not write your own?  


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

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.

Todd Rundgren – For The Want Of A NailTodd Rundgren – For The Want Of A Nail.
(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,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 ..