Better Mayor Metrics (Gary, IN)

[lincoln247]

About the group

About a year ago, the City of Gary, Indiana launched a bare-bones effort to collect and share data using Excel.

A year later (now), over 200 metrics are being collected on a regular basis (yay!), but the sharing and review process is very tedious, manual, and somewhat confusing.

This group is seeking feedback, ideas, and technical assists to make it better.

Group leaders

Lincoln Chandler, lincoln.chandler@gmail.com

Who we're looking for

• People interested in learning about helping out a city big on vision, but low on capital.
• Microsoft Excel: experience in protecting cells (read-only), visualization, version control
• People with Access / database skills; we're not quite there yet but developing specs would be nice.

Tools

MS Office, yup - that's it.

Relevant Links

TBD

Where we meet

The cafeteria - exact location TBD

Chi Hack Night slack channel

The Chi Hack Night Slack is a great place to coordinate between hack nights. We encourage you to set one up and share it here!

[lincoln247]

Example of a monthly report, combining all departments: 201802 Citywide Mayor Metrics-rev.xlsx