BeStUSeoFDAtAinpUBLicSectoR
WinneR
ShoRtLiSt
BusinessLinknorthWest
Brentcouncil experianBusinessinformation
initiateSystems AssessingthenorthWestbusiness
clientindexSystem universe
With270,000residentsandinformationspreadacrossninesources,Brent hMRevenueandcustoms
Councilwantedtocreateagoldenviewasawayofimprovingservicelevels cDMStransactisGroup
andgeneratingnewrevenue.Itbuiltanewclientindexhubtoprovideafully- opencaseclearanceacceleration
integratedviewandsupportfront-linestaff.Thejudgesadmiredthegreat programme
innovationinvolvedandthefactthatthecouncil“gotonanddidit”.
Over1.5millionrecordswerebeingstoredinninedisparatedatabases, UKWiR
exposingthecounciltohighadministrationcosts,potentialbenefitfraudand Dataforceonline
poorcustomerservice.Itdecidedtofindacustomerdataintegrationand corroboratingthetheorythat
masterdatamanagementsystemthatwouldcapture,readandanalyseallof deprivationisbehindconsumerdebt
theserecordsbeforebringingthemtogetherinasingleview. inthewaterindustry
Informationtobeincludedfromeachsystemwasidentifiedandmappedin
ordertounderstandthedifferingformatsandwaysofstoringvariables.Adata
matchingalgorithmwasthendevelopedtobringtheserecordstogether.A
dedicateddatastewardwasassignedtoeachmaincouncilserviceor
departmentwhichowneddata–counciltax,benefits,housing,CRM,adultcare,
children’sservices,electoralroll,onlinecustomerportalandlibraryservices.
Theywereresponsibleforjointlyauditingdataquality,selectingandverifying
whatdatawouldbepassedintothehub.
Sampledatawastakenbydatastewardsfromtheirownsystemsand
comparedtothematcheddatatoidentifyproblemareas.Threefullmatching
exerciseswerecarriedoutuntilthemostaccurateroutinewascreated.A
hierarchywasalsocreatedforpopulatinggoldenviewfieldsfromsourcesystems.
TheclientdataindexallowsBrentCounciltotrackallcitizensthrough
changeofaddressornameordeath,withautomaticregistrationacrossall
systems.Withthisintegratedview,pointsofcontactarenowbetterableto
assistpeople.Italsoallowsforbetterenforcementofschoolcatchmentareas,
benefitinvestigationsandfrauddetectionthroughimprovedcross-checking
andaccuracy.Thesystemisbeingusedasabenchmarkforall7UKlocal
authoritiesthroughtheDataConnectsbestpracticegroup.
Sponsoredby:
tAnGiBLeDAtA
Establishedsince1996,TangibleDatahavedevelopedcoreskillsindataintegration,blendingskillsandexpertisefroman
unrivalledbreadthofmarketinganddatadisciplines.Ourmixofproductsandserviceshaveenabledustopushthe
boundariesofwhatispossibletoachievewithmarketingdata. Investingheavilyindevelopment,TangibleDatahave
delivered highimpactdatasolutionsforaprestigiousandmultisectorclientbase,providingtheinsighttoinformstrategic
planningandachievefinancialbenefits.
22|DAtAStRAteGYAWARDS2009
Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22  |  Page 23  |  Page 24  |  Page 25  |  Page 26  |  Page 27  |  Page 28  |  Page 29  |  Page 30  |  Page 31  |  Page 32  |  Page 33  |  Page 34  |  Page 35  |  Page 36  |  Page 37