Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Saturday, 8 June 2024

Victim Of Changes, Progress (the database)?

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

We all try to stay ahead of the curve. No sooner we have Windows 7, we have Windows 10, then 11. It’s a constant fight to stay current and protected. 

The Silverlight support deadline has been & gone. Woe betide any Socialhousing organisations still on Keystone asset management cowering behind their firewall.

One de-support notice that might have passed your attention however, is the close of Progress OpenEdge database version 11.7, next April 2025. Apache Tomcat 8.5 security support has already ended, back in March 2024. While from April Progress based solutions will still operate, however will no longer receive security updates and patches. While not generally web facing, that reduces but not totally eliminates risk.


Progress, very much a database of the 1980’s and mid-90’s still has a large footprint in UK Social Housing. This is due to the number of IBS/Capital OpenHousing and MRI/Orchard housing systems still in use and the large footprint of openAccounts as finance solution, often sold with those solutions. Of course a lot of folk are looking to the market to research alternatives, some with housing/Finance combined.

The sector does have a severe problem with not keeping application solutions up to date. Of course this is not limited to the above examples. I have found it endemic across many applications, regardless of contracts attempting (but generally failing) to enforce frequent upgrades.

Many users will be expected to be way behind with versions of OpenAccounts, Pro2, Ebis, OpenPeople as well as housing solutions.

While there is a good nine months to upgrade, bear in mind that many dozens of sites will need to take this leap and also a year-end will sit in the way of finance users. So how if you are a site affected by this, to move forward smoothly?

Getting across to Progress Version 12 is crucial and a pre-cursor is to get upgraded to MRI Orchard’s latest version, in order to be Progress v12 ready. This will be more clunky for organisations many versions behind. This will involve applying a number of incremental versions with attendant testing/UAT. Interfaces are the most important areas to concentrate on, in addition to any local development outside of what’s supported as supplier IP. Although often helpdesks fall down in spectacular manner!

For OpenAccounts, the target needs to be v10.1 – If this can be achieved by late summer, this would be ideal. Where existing users are still on OA versions 8 or 9, it’s a heavier upgrade path. Getting up to v10.1 will then provide Progress v12 compatibility.

Where Orchard/OpenHousing is used in conjunction with openAccounts, there are bound to be dependencies. Be sure to check these out in detail with whoever supports your solutions.

This all kind of underlines the good sense of upgrading often where you can. You know it makes sense!

 

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

*** Join the discussion with Claire & Aiden ***

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

 



If you are stuck on a legacy SocialHousing system, reach out
please just get in touch , for a chat over a slice of LDC ☕😋

       Related Post: Is your finance chart of accounts, the size of Saturn ?

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

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.

Judas Priest – Victim Of ChangesJudas Priest – Victim Of Changes.
(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,CxFeedback, DRS,Deeplake,Designer Software,Development Systems,Director,Document,Documotive,Docuware,Dynamic AI,DynamicAI,Dynamics 365,D365,Dynamics365,Dynaway ECMK,EDM,EDRMS,ERP,ESRI,Elmhurst,Enghouse Interactive,England,English,EnterpriseBI,Estatecraft,Esuasive,Etive,Exhibition,Exponential-e, Facebook,Factorwise,Field Service management,Finance,Financial Systems,Financials,FLS,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,Visitour,Visualmetrics,Voice,Voice and data,Voluntas, Wales,Welsh,Wheatley,Windows Server,Workflow and,Work Hub,Works Connect, XML,Xen App,XenApp,Xmbrace, Yuneo,TS Acutance Consulting, ...
. . . . . . . . . . . . ES | FR | DE | IT | UK |

Tuesday, 6 October 2020

Serco Don’t Lose That Number!

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


Earlier this week, a few thousand people and probably a dozen at least of my contacts, probably grinned with a knowing smile. 

Of course I am writing about the UK’s national Serco Test and Trace spaff-up, relying on Excel spreadsheets, to collate and process Covid-19 tests. 

If I had £500 for every time I had told people off for calling 'info in spreadsheets', a database, I could have retired by now.

The situation could be laughable, if it were not so important and crucial.

Now, if anyone wants to spread blame around, I would personally start with Microsoft. Why So, you might ask🤔

The original Lotus 1-2-3, as anyone who broke their teeth on it during the 1980’s may remember, only had a maximum of 8,192 rows (and 256 columns). Now if it had stayed at that size, a very limited number of fools would have tried to store lots of data in it and sensibly selected a proper database to do the job. But no. As Reeve’s and Mortimer might have said, “They couldn’t let it lie” -  .

Microsoft’s Excel gave us 65,536 rows, immediately giving the illusion of it being a ‘database’, not a useful summary manipulation and presentation tool, which is what a spreadsheet does best. I have been involved in so many projects where users, managers and directors in some cases, have been firmly wedded to spreadsheets, needing to migrate to proper solutions, with protection, data control and robust audit. I have often proposed amnesty, after replacement system go-live, where spreadsheets can be dropped.

My proposal is that if the fearsome and opposing communities in Northern Ireland, could put their weapons beyond use, we should have a spreadsheet version of the Good Friday Agreement, where users do the same and promise never to return to them again. For some its starting to catch on thankfully.


For sure, Excel can be a good place to start for an initial prototype, but no one should continue to try to run a whole enterprise on it. Serco are not alone. Eight years ago or so, I worked with a big organisation, dealing with £8m of monthly transactions on Excel with its one million row and memory limit creaking & ready to break. Fifteen years earlier, with a turnover a 50th of that, spreadsheets just kind of worked. For that organisation it took about 4 months to procure and 12 to implement, a proper finance, feeder and self-service solution and they never looked back.

Serco however have apparently been paid £12b of taxpayers dosh and should have been able to build their own database quite quickly with 20 or so of the right ICT staff, none of which would have probably stuck with Excel, if there was any capability of a millions of test a day Moonshot a-coming.

In my time manipulating data, I have witnessed many things Excel does trying to be clever, without telling you. Truncating to 65,536 is common where old solutions can only use XLS format to export. No doubt you might have experienced that too. The type and length of unique ID’s seen in the SocialHousing sector, is ripe for Excel to helpfully swap then to scientific notation. How we laughed at that one, several weeks down the line.


 
So, beware the spreadsheet, its not a database. Don’t do a Serco Track & Trace, learn from their mistakes.

Who in YOUR organisation needs to take that advice to heart?

Related Post: Keep an eye on your staff using spreadsheets, adding up totals, with a calculator too!


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

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.

Steely Dan – Rikki Don’t Lose That NumberSteely Dan – Rikki Don’t Lose That Number.
(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, 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, ...
. . . . . . . . . . . .

Sunday, 7 August 2016

The Old One Two

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


We are hearing much lately about mergers and to a lesser extent demergers. a subject for a future blogpost I am sure. However, how to integrate data into your existing HMS (Housing Management system), is something every merger needs to seriously consider.

Group structures vary. Will elemental RSL's be an integral part of the group, or be very autonomous within it?

Most HMS allow setting up of partner RSL's as a totally separate database, or as a different Owning Body, landlord or owner coding, within a single database. How to decide, which path is best for you?

Well, separate databases generally need separate logins, so that might prevent use of a shared call or service centre. Do you think that might be a future feature? If it is then a shared database might be the way forward.

It helps if your HMS supports limiting users to different Owning Body, Landlord, Company, Area, Housing Officer, etc restricted by user access security. It might be as well to check that out. Also if one of those codings are currently being used for something else, in your current Housing Management System. This would allow users to only see/maintain the properties within their assigned part of the group. Where allowed, it can generally be relaxed, if staff are covering for others on leave etc.

However,  often it can be felt easier at day-one to segregate into two databases, although that might not be best long term. Its far easier to break systems out of one database, than merge from two. In fact I can recall one decision to split two systems, decided by an RSL, to cement a decision that the HMS in question, could not do multi organisation . Quite wrong as it turned out, but it all turned out right in the end.

Still, getting back to the original question, do we look to migrate into or out of the current group database? Well some of the questions  to ask are about the groups that may be formed. Will a common service centre, deal with enquiries from all of the group? If so, then a common database is going to be essential. A split database would be problematic to a service centre to deal with to two different demographics. Two logins, or Alt-Tab between each.

Generating KPI's is somewhat easier from a single database, reports can easily be run for the whole group (all units), or filtered on a single Owning Body or Landlord designation. Chances are, within a group, shared or similar SLA's may be agreed, so performance across group members can be compared.

KPI's from two separate databases would mean all codes would have to be identically set up and maintained, in order to allow easy KPI comparisons. Of course, two databases would need two upgrades on every release and discipline to keep codings/features in line at that point too.

I have seen group structures offer a very flexible relationship and a in comparison, quite a strict relationship with partners. I do not opinionate  on what is good or bad, partners need to determine if that meets their own cultures. That decision as to if we are looking at two(or more) databases is central to any merger and one to be taken at the very start.

This is a key decision and will determine relationship for many years ahead.

If I can help with any merger you are engaged with, please be in touch, we are here to help.

Catch the blog monthly archive at
https://archive.org/details/@housingitguy 


Related Post: Basecamp, a cracking way to look at project management within #UKhousing Management? 

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

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.


Kevin Ayers - The Old One TwoKevin Ayers - The Old One Two.
(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, HRA,housingtITguy,Housing Support Pro,HousingSupportPro,Housing Options,Hometeam, Housing Group,hotpixuk, HousingIT,hotpix,Hardware,Hitex,Housing Contact Company,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, PM,Progress,Promaster,Proval,Pyramid,PRINCE2,prince,Pamwin,PlanForm, Propoints, Pro-Points 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, 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, 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,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley,Works Connect,worksConnect, Xmbrace,XML ,XenApp,Xen App ..

Wednesday, 11 March 2015

Adolescent Sex

If you do the Twitter thing, follow me at @hotpixUK
or LinkedIn here http://uk.linkedin.com/in/tonysmiththathousingitguy
Thank you to one of my Twitter followers last week at the Housing Technology Conference for providing a perfect definition of ‘Big Data’. Have you ever considered that its actually more like ‘Adolescent Sex’ and it was confirmed to me with a roomful of housing system bods down at the Oxford Belfry.

I asked, in a session with CIH visionary Barry Marlow, who here is using ‘Big Data’ as all we seem to hear these days is that it’s our saviour. Barry too has been sucked in to the big data hype. Not one of about 45 people raised their hands. My response was “Actually Barry, what we have proved here is that housing has not yet actually got to grips with ‘Small Data’. In fact we are still drowning under thousands of spreadsheets, carefully groomed and maintained by our staff in silos.

How confident are you of how many spreadsheets can be found in your shared drives & user areas? A few dozen, few hundred, few thousand, tens of thousands? Paddy Power give me poor odds on it, but I would wager towards the latter. So did the attendees in our session.

My twin sister from another mother @NasrinFazal, crystallised it by the following graphic:

Dan Ariely:
Big data is like teenage sex: everyone talks about it, nobody really knows how to do it, so everyone claims they are doing it ...

Now, you could say that big data is in fact lots of collections of small data. Our problem is that we have on the whole been pretty pants, at actually using the expensive systems we spend £hundreds of thousands on, in creating joined up data of use to us.

If you are feeling smug, try asking the question, “How many properties have we got and of what bedroom sizes & types”? If you need to consult more than one system or application and you cannot reconcile to a single figure, you are probably not “practising safe data” are you?

Related Post: Why does our Workflow not make everyones housing work, flow then?

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

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

Japan - Adolescent SexJapan - Adolescent Sex.
(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, or you could benefit from any of our services please get in touch and let me know!

You can access a quick list of 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 or issue.
File Under: 360,1stTouch,4Js. , 07854655009 , ," """" ",,#UKHousing,#HousingDAY, #HomesForBritain, #Shout,1st Touch,3squared,Accuserv,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, #HousingTech2015, 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, 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 , #HousingTech2016, #HousingTech2017, 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 ,Fusion, Getting best from,gotonysmith, Grasp,Grip,GeoSolveIT,GIS,GGP, HouSys,Housing software,HG,Housemark survey,Housing Blueprint,Housemark, HRA, Housing Options, 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,Internetalia, Invu,Ireland,Irish,Inphase , 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,PlanForm, Propoints, Pro-Points 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,Scenario, Scotland,SDM,sector,TonySmithHou,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, TonySmithHousing, Systemwise,SM,Sequoa,Serros,SP,Scout,score,Swordfish,Serengeti,SOTI,southview,Sunguard,Service Charges,Spotlight Service, Spotlightservice, SunAccounts Template,Task,Terminal Services, tonys , tonysm , tonysmi , tonysmith, tonysmitht, gotonysmith, tableau Business Dashboards, 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, 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,Version One,Visualmetrics,Voluntas, Wales,Welsh,Windows Server,Workflow and tasking,Wheatley, Xmbrace,XML ,XenApp,Xen App .