Introduces city employees to time-saving data management, cleaning, and design concepts to simplify reporting and data analysis. Also included post-training survey to measure impact.
by DataSF, City of San Francisco
Target Skill Level:
This two-hour training reviews how to design simpler datasets, reducing repetition when fulfilling data tasks, and easing interpretation. This course primarily uses tools and formulas in Excel, such as concatenate, index, and match, to create flexible lookup tables. Participants leave with the following skills:
Using functions in Excel to clean and prepare data for analysis
New mindsets for approaching data preparation and cleaning
Data Academy is a training program for city and county staff in San Francisco hosted by DataSFand the Office of the Chief Data Officer in the City and County of San Francisco, produced in partnership with the Office of the Controller. Other course offerings, such as “Introduction to Excel” and “The Basics of Information Design,” are available on the DataSF website.
A June 2017 blog shares reflections on the impact of training for the San Francisco government staff and agencies, and provides a great example of measuring the difference that training makes to the mission of an organization.