HomeMy WebLinkAbout8, Consideration to Procure Business Intelligence Software
ACTION ITEM #8Business Intelligence SoftwareConsideration to Procure Business Intelligence SoftwareConsideration to Procure March 6, 2019
Consideration to Procure BI Software service analytics for District staff-Does not provide self•Provides reporting in public facing applications; MyH20 & Outage Center•Current District
software BI tool in use since 2008•Logi Analytics•infrastructurePrimary role to develop Business Intelligence (BI and reporting •Data Analyst and Administrator role is filled•2018 October
8, •for a Data Analyst and Administrator within the IT DepartmentWorkshop to discuss Electric Utility reorganization included a proposal •July 18, 2018 Board Meeting•BACKGROUND / HISTORY
Consideration to Procure BI Software
NEW INFORMATION service BI software initiated in December, 2018-Process to identify self•Analytics provides advanced public facing contentLogi•Existing Microsoft SQL Server database
•BI Architecture •service analytics-Requires improved architecture centralizing data and supporting self•Need for actionable information to improve operational efficiency•Growing demands
on the District’s enterprise applications:•Consideration to Procure BI SoftwareConsideration to Procure BI Software
NEW INFORMATION What is Business Intelligence?•Consideration to Procure BI SoftwareConsideration to Procure BI Software
NEW INFORMATION G2 CrowdBARCGartnerelection process started with industry rankingsS•Consideration to Procure BI SoftwareConsideration to Procure BI Software
NEW INFORMATION InformationCapable of advanced powerful platform delivering Actionable •service reporting by the users-Allows for self•Provides the right balance of functionality and
simplicity•Tableau selected as the preferred solution •Senior Accountant/Analyst•GIS Coordinator•Data Analyst & Coordinator•Conservation & Customer Service Data Analyst•Trial evaluations
with District staff•Consideration to Procure BI SoftwareConsideration to Procure BI Software
FISCAL IMPACT capital expenditure budget for this procurementSufficient funds exist in the Information Technology’s adopted FY19 •(CMAS) purchasing mechanismSimplified Solutions through
the California Multiple Award Schedule •16,228$•Annual licensing fee•Tableau to implement best practice recommendations for the Districtsite engagement with -One time cost of $12,925
representing a four day on•Rapid start engagement•Consideration to Procure BI SoftwareConsideration to Procure BI Software
RECOMMENDATION licensing for an amount not to exceed $29,153 plus tax.through Simplified Solutions for Tableau Server services and Authorize the General Manager to execute a contract
with Tableau •Consideration to Procure BI SoftwareConsideration to Procure BI Software