Loading...
HomeMy WebLinkAbout8 Purchase Business Intelligence SoftwareAgendaItem#8.TRUCKEEDONNERPublicUtilityDistrictCONSENTTo:BoardofDirectorsFrom:IanFitzgeraldDate:March06,2019Subject:ConsiderationtoPurchaseBusinessIntelligenceSoftware1.WHYTHISMATTERISBEFORETHEBOARDBoardapprovalisrequiredforprocurementsover$15,000.2.HISTORYAttheJuly18,2018BoardMeeting,aworkshopwaspresentedtodiscussthereorganizationoftheElectricUtility.ThisreorganizationincludedaproposalforanewDataAnalystandAdministratorpositionwithintheITDepartmenttosupportDistrictoperationswithstatisticalmodelinganddatabaseworkforElectricandWaterUtilityoperations.OnOctober8,2018,theDataAnalystandAdministratorpositionwasfilled.Oneoftheprimaryrolesofthispositionistosupporttheimplementation,troubleshooting,andmaintenanceoftheDistrict’sdata,BusinessIntelligence(BI),andreportinginfrastructure.OnecurrentDistrictsoftwaretools,LogiAnaylitics,anembeddedanalyticstoolinuseattheDistrictsince2008,providestheDistrictwiththeabilitytoembedandshareinformationinpublicfacingapplicationssuchasMyH20,andtheOutageCenterontheDistrict’swebsite.TheDistrictcurrentlyholdsanannuallicensingcontractwithLogiintheamountof$21,000annually,andwhileLogicontinuestoperformwellinthenicheroleofembeddedanalytics,thereisanopportunitytoleverageself-serviceanalyticsdashboardsDistrictwide.3.NEWINFORMATIONThegrowingdemandsontheDistrict’senterpriseapplications,theneedforactionableintelligencetoimproveoperationalefficiencies,andagrowingcustomerbasethatisdatadependent,requirethattheDistrictimplementanimprovedarchitecturethatcentralizesdataandsupportsself-serviceanalytics.TheDataAnalystandAdministratorhasdeterminedthatexistingMicrosoftSQLServerdatabaselicensingprovidesasufficientandadequateframeworkwithwhichtoimplementandbuildacentralizeddatarepositoryfortheDistrict.Logi,althoughitperlormsverywellinpublicfacingembeddedusecases,doesnotprovidetheDistrictwiththeappropriatetoolsneededtosupportaninternalBusinessIntelligenceandreportinginfrastructure.Assuch,aprocesstoidentifyanappropriatetoolwasinitiatedinDecember,2018.Thestaffevaluationprocessforbusinessintelligencesoftwarestartedwithfeedback tt2-oL-9i.-E3JUO3SVLND)0N1SNOIIfl7OSVGHOV±frpu(G9QE-OL-9j.-E3JjUOQsvvio)0N13AGSNOIIflJOSVN1SASEt7C-OL-9I--13]1UOQsvvio)GIdI7dV\JISSNOIIfl7OSt)iVOL9I.-OL-2i-i:13]1UOQSVIND)SSIHdH1NVIJOHflVI.SJO3J1UO36U!MOIIOeqt.U!MneqjJOS3JUO3SVV’JDiueiinouOpesqseionbinopeTsenbeJppsaeqjP8MOIIO8J8MseinpeooidjUeWeJfl3OJdeA!1!ledwoo6U!p!AOJdsp!qMOlSe!3U86.ieqjooe6juApeN10113P1S!Geqs!wJed(Se!3Ue6oiqnUieqopu!wo!IDoeiiseqqM6U!Sq3Jfla1U!Ot)epooS13!JS!Qeqo09090EUO!3eSSVV’JDq6notspqepisoe61UAPejoeq!6eeii‘i3!J1S!Geq6U!pflIOU!‘SjU8WUJ8AO6iooiSVV’JDeq:O1jdsneqjwoiJM%OSp!qAIeA!1!ledwoosiq!wo!IuDoeq.WS!Uq3eW6USq3Jfldtsvv’io)enpeqPJMVed!nj!wo!IDeqqbnoiq6u!o!Jd6uujqoU!pepeeooidweieL_IljU!OdS!qV8Jfl13fl]1S4U!6UflJOU8JpuiSj3!JS!Q8L]OUO!lflIOSpeiieeideqjswioid8JM1OStie)eoue6ejusseu!sneqjouo!3eesU!6u!lInseJ‘eoueLledxeIflP!A!PU!M8L1uopeseq8JM1OSeqpeioosueq.ieqwewweqoJO1]1S!U!WpVRisAiuV1G•17puUisAiuV/iuiunoooV]o!ues•EJO1U!P]OO3SID•isAiuV1GJO!U89eo!AJeSiewoisnoUO!MeSUOQ.I-:sieqwewwe6uMoojeqAqA!IBUO!T3UflIeine-iinpu‘eouwioped‘A!3!IdW!Suo3npo]dqoeenteoSMio6eqw]oidqoeo6u!se1uo-spuq)jeeM-nweA!sueu!Uu6eqpuM8!A8Jio8JM1OSIJ8A8SpepeesT3!J1S!Geq‘eAoqpejssesqeMeqwosbuuoospus6u!NuJpeu!qwooequopesSM8!A8JJeSflUOAI8A!SflIOXepesqswJojidsseu!snqJoSbU!NU]ew!-eJSep!AOJdLflwJoidMe!AeJpesqieedS!MOJ3SUOi3!IddVSS8U!Sfleio83!AppuN6!SU!Sep!AO]d1LflWJ!AJOs!APpuqieseiqo6eS!‘iouieswioideoue6!eIuSS8U!SflPUUS3!AIUVuosnooLIT!MW]!6U!1IflSUOOpusAuJMOSesudjeiueuuS!‘]eueQq3]8Se5UO!13!IddVSS8U!Sfleq‘3:MOeqI!1eP8.IOWU!qoePMOJDDDU‘J8UJ‘DHVe:SeSqeMMe!AeJ1U8pUeU8PU!UMOUNheMeeiqAqpep!AoJU‘s6upjuipu SolutionsSimplifiedprovidedthelowestquoteforatotalof$29,153.Thequoteincludesthefollowing:ItemQuantityUnitPriceTotalPriceRapidStartEngagement1$12,925$12,925CreatorLicense-1Year2$834$1,668ExplorerLicense-1Year35$416$14,560$29,1534.FISCALIMPACTTheRapidStartEngagementisaone-timecostandrepresentsafourdayon-siteprofessionalservicesengagementwithTableauprofessionalstoinstall,configure,andimplementbestpracticerecommendationsfortheDistrict.Therecurringannualfeeforlicensingis$16,228,andwillbeincludedinfutureyear’sannualprocurement.SufficientfundsexistintheInformationTechnology’sadoptedFYi9capitalexpenditurebudgetforthisprocurement.5.RECOMMENDATIONAuthorizetheGeneralManagertoexecuteacontractwithTableauthroughSimplifiedSolutionsforTableauServerservicesandlicensingforanamountnottoexceed$29,153plustax.,kIanFitzgeraldMichaelD.HolleyInformationTechnologyDirectorIdOGeneralManager