Finance Committee Agenda and Packet 2018 08 17

Home Browse Search

City Council Finance Committee Meeting Minutes 07/16/18 Page 3 of 6 prepared and can be emailed to the Finance Committee Members upon his return. Chairperson Maloney stated that the dashboard can be included with the August Finance Committee Meeting packet. Finance Committee Chairperson Maloney asked about the lower than anticipated revenue indicated on the Recreation/Senior Center Dashboard for membership, daily user and swim lesson fees. City Manager Balser stated that the declines were not anticipated and that she would obtain additional information for the Committee. Public Works Director Kurt Kowar demonstrated for the Finance Committee various dashboard reports that were created using Tableau software. Director Kowar stated that the software creates a live link between the Tyler financial software and American Data Group (ADG) software which houses Public Works metric data. Member Muckle and Maloney stated the dashboards were really good and provide a great direction for reporting. Finance Committee Member Maloney asked about the staff time and effort to produce the reports on an ongoing basis. Director Kowar stated that the effort is minimal should the City decide to go forward with the Tableau software. Deputy City Manager Megan Davis stated that the City is currently pilot -testing Tableau and other similar software solutions. Ms. Davis stated the City is looking for a product that could be used City-wide, would extract data from common database sources, and would have a similar look and feel. Ms. Davis and City Manager Balser stated the goal would be to use such software to create department dashboards, key performance indicators, budget projections and be available on the City's web site. IT Director Chris Neves stated the City does not currently have access to the recreation center and golf course software databases. City Manager Balser stated she is hopeful City Council will approve the new data analyst position proposed in the 2019 budget, which position will be key to creating the City-wide data links and custom reporting desired. Finance Committee Chairperson Maloney asked if the Tableau software is a subscription and what the costs are. Director Neves stated the software is by subscription and costs approximately $20K per year. Director Kowar asked the Finance Committee if they still want to see real-time mapping of various maintenance operations. Deputy City Manager Davis stated that real-time mapping of capital projects is available now. Finance Committee Members stated that real-time mapping of street -sweeping and snow plowing operations would be beneficial and allow businesses and residents to view the location of City maintenance equipment and crews during weather events. 4