Friday 15 January 2021

Each Time I Tell People

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

This week I encountered in a conversation, a reference to a ‘database’, in an organisation with few specific application systems. On further investigation, (a simple, “Can you share your screen, so I can see your database”), all is revealed. What is being described is an Microsoft Excel Spreadsheet.

Now before we get fully into this post, I am not Excel-ist (or even spreadsheet-ist, if there are any Lotus SmartSuite users out there – Respect!). I am a big fan of Excel, but not for storing important data, like in a database.

I was considering just the other day, if I had £50 for every spreadsheet and each time I tell people, I had described as “not a database” or said, “stop using that spreadsheet as a database fella (he/she OBVs)”, I would have a substantial pension annuity built up by now. So many data manipulation functions have been added to Excel over a few decades, it provides a deceptive veneer. Add to that, the problem that 90% or more of spreadsheet users, have never had any formal training at all, just adds to the problem. Staff just in some cases do not understand that rows are best set up to be entities (eg each row a property, case, rent account etc, a column a particular value or field of a specific type).

Excel in the big maths scheme of things...

Many spreadsheets I see, could actually be easily transferred to Microsoft Word, with very little effort, with many people not even noticing, if a few tables were incorporated.

One big reason I hear from client staff, is that they maintain a spreadsheet because they can protect the data from the barbarians outside. In doing so, they become a silo, (although they are unlikely to twig that).

Reliance on Excel, often wastes a considerable amount of time and effort, often keeping certain staff members expert in their own silos.

My job is usually, (in the event that staff have not twigged it as yet!), is to extoll the virtues of a real database or application based on one and in most cases, transport them there as fast as possible.

So why migrate away from Excel? In contrast to Excel, databases allow users to only enter data once, as it offers the functionality to link other records together. Clearly, we might record a single asset and multiple complaints or anti-social behaviour events against it. Spreadsheets struggle with this kind of stuff.

When Excel contains more than a few hundred rows, users experience significant slowdowns. Databases utilise indexes and other means of speeding up access and reporting. Audit is generally easier too, where data can be (sometimes accidentally) lost in traditional spreadsheets. Many rows can trip up the biggest enterprises at times too!

Excel does provide sharing of a kind, although its not quite up to a proper database and often causes more problems than it actually solves. I have used Excel sharing occasionally successfully when with others scoring supplier demos, but you wouldn’t rely on running any organisation critical processes on it, believe me.

If you are reading this from a small organisation, running exclusively on Excel, you are probably overdue in giving me a call. Many small social housing providers do run on spreadsheets, many under 200 units in size and typically doubt that anyone like me would be interested in helping them organise better. In the last year, I have assisted housing providers managing 36, 160, 190 and 390 units, as well as the five to thirty thousand homes brigade. We can match suitable solutions to your needs.

If you are reading this from an organisation already with Integrated Housing Solutions and you have hundreds of spreadsheets still, perhaps you need help from a different direction. I have often helped teams with trust issues, or where additional useful and integrated functionality, can be squeezed out of existing solutions. Often the reasons for not using system modules (often already purchased and being paid for…), are sometimes tenuous. Convenience for a single team, can be over-valued beyond wider organisation integration and efficiency.  

In summary, I encounter spreadsheets usually as the rock in the road to transformation, rather than an enabler. Consider how you use spreadsheets in your organisation and consider if there should be a better way.

Related Post: Get your self-service right, or maybe come back when you can


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

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.

Steve Gold – Each TimeSteve Gold – Each Time.
(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,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,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, 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, 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,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid,MRI Socialhousing,MRISocialhousing, 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,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,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,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, ...
. . . . . . . . . . . .

Friday 8 January 2021

Smoke ‘Em

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

I am sure regular readers to my posts here, are familiar with my reflections on application software and how it differs markedly from real world product, such as the humble washing machine.

While we wouldn’t ask for a demo of a washing machine, in the real world we are used to having to check out details in bigger purchases. For house purchases, we generally engage a surveyor, because that is how our mortgage lender evaluates the value of the property we are about to purchase. When buying a car, particularly a used one, we drive it, we may even get the RAC or AA to do a proper check over it. For software (a £750k+ purchase), we might engage a Critical Friend, to ensure we are asking the right questions and will in practice get what’s being sold.

Software sales persons are often at the end of the ‘trust-worthiness scale’, together with politicians and estate agents. Using an analogy of the latter, some software has ‘potential’ (i.e. its not fully written yet), other options are like a ‘Do-er Upper’ (i.e. few reports come as standard and you will be working on those yourselves, like adding an extension or an indoor bathroom). ‘Professionals only’, well, maybe set up screens will be missing and you will need a good working knowledge of VI screen editor.

To caveat, I don’t regard all software sales folk as untrustworthy, in fact some I would trust some with my life. Honestly. It depends what’s being sold, is it really going to fit your needs and will it provide the benefits expected/promised? That’s a fluid thing too. Application software and suppliers vary over time. They can be world leading one year and laggards the next. Its up to you (Caveat emptor), to find the holes in the inevitable Swiss cheese, which is software.

So, what are some of the signs you are caught in some smoke and mirrors, in the demo where the supplier is showing you their wares?

Firstly, unless you see their wares, inevitably they are missing certain wares. They might be missing for lots of reasons. They may not have even evolved beyond a sales persons imagination, they may be on a roadmap, or very close to release. All three of these should flag up alarms for the customer to various degrees. Highest risk is the former and the lowest risk is the latter. If the latter is reality, even though a release is ‘just around the corner’, if the supplier cannot demo, they should at least be able to show you images of what’s coming. After all, if its in the ‘next’ release, someone has already been writing it from a spec and testing it by now, eh?

A great way to reassure the buyer is to let you know its being released soon.

Be as irritating as me and ask, who is taking that release and when? Will it be the full product or a MVP? The MVP is a ‘Minimum Viable Product’. The important word there is ‘minimum’. You may be able to do the minimum to get the job done, or not, depending how special your processes are. What your software supplier might regard as ‘the minimum’, might differ greatly, to what you might regard as the acceptable minimum.

Secondly, verify are you seeing product, or wire-frame prototype models? Are you just seeing Powerpoint slides or a PDF? Now you are probably asking who would be so stupid to buy just from those? Well, I am far too polite to name the guilty (as always), but I have come across many. A lot often saw no product forthcoming, or waited 3 or more years to receive a mongrel version of the utopia, originally promised. That includes social landlords of over 30,000 homes in size too, making schoolboy errors like that.

Thirdly, a dead ringer to spot is over-zealous waffling. If you have got a supplier in, over Teams/Zoom etc, for a limited period to see their wares, you don’t want to be lectured about where the sector is going, what might come out of the Grenfell enquiry, or the latest social care scandal etc. If your supplier had solutions to all the described ills, they would be showing you and knocking you dead with them, not death by PowerPoint. If you didn’t see the solutions, chances are they are not actually there. Possibly they are very dated or disjointed solutions, looking nothing like the really sexy bits they were desperate to show you. Do by all means, question it and give your supplier a chance to show you. Me & Paddy power however, might not give you great odds, you will see the goods.    

Fourthly, its being unable to complete a demonstration of something end-to-end. Software is developed from start to finish and in a demo its easy to show the initiation of any process. Anywhere the supplier seems to hit an issue, being only able to show you part of something, be suspicious. Remember these guys hopefully have had sometime to prepare this demo and are using demo kit that’s used for many demos. I know from being on the dark side 10 years ago, ‘Demoland’ is like Disneyland. Everything is cool there and everything (should) work. If its not working on demo database & kit, it’s a good chance its not working in reality.

Lastly, if a supplier is allocated, say a couple of hours and while others are generally up to the limit on time, one or more might be done & dusted really quickly or pad out the time with some diversion on to some unrelated/unwanted product. This should ring alarm bells. If you are seeing something you didn't expect to see, check its a freebie the supplier is just chucking in for you (unlikely). If its not relevant to you to see, politely tell them so. Otherwise, that's thirty minutes of you and your staff team lives, you will never get back!

In fact that same adage can also be applied to test systems too. If a supplier cannot get a test system working correctly, just the act of migrating to live, will never fix it. I remember back on the dark side, a big fat bullshi**er developer, trying to convince me that something that was even incapable of writing correctly to a test database, would magically be ok on a live situation. He knew his fat ar*e would not be on the line, at the live site when it all went wrong. Just like sales persons will not have their bottoms on the line, if you choose badly and its you and your team holding the baby.

I hope this has helped you hone your antenna for entering the smoke and mirrors zone. Clients often congratulate me for sniffing out the more subtle areas. Most are in truth, are hiding there in plain sight. Bear this in mind, during your next software procurement, feel free to get in touch. If you need help, maybe just minimal assistance in some situations, I am sure we can work together to obtain best outcomes for you, your team and your organisation.  

Related Post: For training materials, start with video


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

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.

Fun Lovin’ Criminals – Smoke ‘EmFun Lovin’ Criminals – Smoke ‘Em.
(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,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,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, 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, 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,Microsoft Dynamics 365,Microsoft dynamics GP 2013,Miracle,MobileIron,Mobysoft,Monopoly board images and pictures,Montal,Mr Void,MriEngage,MrVoid,MRI Socialhousing,MRISocialhousing, 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,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,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,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, ...
. . . . . . . . . . . .