Data Academy

A training program for City and County of San Francisco staff. Explore, refine and enhance skills in data use, data management and process improvement.

The Data Academy is produced in partnership with the Office of the Controller.

Course Catalog

Sign up to receive course announcements

You must sign up with your CCSF work email.

* indicates required

Additional Resources

View the Full Course Catalog Frequently Asked Questions

Health Impact Assessment as a Strategy for Incorporating Health and Equity into Decision-Making

Because much of what influences health happens outside of the doctor’s office, local health departments analyze a multitude of decisions that have the greatest potential to improve or harm health.  The San Francisco Department of Public Health plays a central role in factoring health into many local policies, plans, and programs, such as our transportation network, economic development projects, labor standards and climate change initiatives. This activity-based training will discuss different types of strategies and evidence-based tools used by health impact assessments that all analysts and managers can use to conduct a data analysis project from start to finish and determine whether a policy or plan will promote, enhance, or discourage health and equity.

How To Make Better Decisions Using Design Thinking and Behavioral Economics

Ever wanted to use design thinking to create more effective project outcomes? Plan to have fun practicing these techniques and then commit to trying to apply what youíve learned to one or more of your projects in 24 hours.

Introduction to Lean Process Mapping and Visio

This classroom-based workshop introduces the Lean process improvement method, focusing specifically on process mapping. The course also provides basic training on how to document your process map using Microsoft Visio. This training is recommended for anyone who is new to process mapping. It is ideal for people who have a process improvement project in mind or are just getting started. No prior training or experience in process mapping is required.

Introduction to SQL (Structured Query Language)

Much of the initial and simple data analysis and manipulation is done in Excel spreadsheets. However, with larger and more complex datasets, a relational database (e.g. Oracle, Microsoft SQL Server/Access) is usually a more popular choice. Structured Query Language, or SQL, is an international standard language for data manipulation in a relational database and is an important skill for data scientists and analysts. This workshop will introduce you to SQL so you can manipulate your data more elegantly and efficiently.

Reading Statistics

City agencies hold administrative records for hundred of thousands of individuals, but the abundance of data carries inherent risks for misunderstanding or misreading statistics. This course demonstrates common errors in presenting basic statistics and discusses the basic principles of longitudinal data.

Which Charts to Use

Hundreds of chart types are available these days within sophisticated data visualization tools. However, which ones of these charts would help you tell your data stories better? This back-to-basic workshop aims to help you easily and systematically select the triedand- true chart types based on the data stories you want to tell.

Tableau Certification Preview

This classroom based workshop is the fourth in a series of workshops on Tableau offered by the Data Academy.   Our goal is to familiarize you with the Tableau Qualified Associate Certification. We will provide quick tips on how to tackle the two hour certification exam and apply them to sample problems together.

Lean 101 - One day to better government

Have you ever wanted to change the way your workplace operates but didn’t know where to begin? Wish you could clear the obstacles in your daily work or reduce bureaucracy for your customers?  The Twin Peaks team trains and coaches people at all levels to rapidly improve the work they do every day.

Introduction to Tableau

This classroom based workshop is the first in a series of workshops on Tableau offered by the Data Academy. Tableau Public is a free data visualization software that allows you to quickly create charts, maps, and dashboards with interactive filtering and drill-down capabilities.

Intermediate Tableau I

This classroom based workshop is the second in a series of workshops on Tableau offered by the Data Academy.  Tableau Public is a free data visualization software that allows you to quickly create charts, maps, and dashboards with interactive filtering and drill-down capabilities.

Intermediate Tableau II

This classroom based workshop is the third in a series of workshops on Tableau offered by the Data Academy. Tableau Public is a free data visualization software that allows you to quickly create charts, maps, and dashboards with interactive filtering and drill-down capabilities.

Introduction to R

In this introductory class, participants will learn practical skills necessary for reading data into R from external sources, manipulating the data, and visualizing it.  The course will also cover other basic programming concepts as they are implemented in R.

Leveraging the City's Open Data Portal

This course helps you unlock features of the open data portal to improve your own data workflows. To get the most out of this class, you should have Excel 2010 with the Power Query Add-in (free) or Excel 2013 on your work computer.

Data Usability - designing data for consumption

Basic data design choices can make the difference between simple analysis and hours of frustration. This classroom based workshop will go over how to make certain dataset design decisions that will make your reporting life much easier, hopefully reducing repetitive asks for data and interpretation.

Basics of Information Design

So you have great data, but you want to learn more about how to present it effectively? This class goes over the principles of good information design so that you can present your data in a way that is uncluttered and beautiful.

Introduction to Excel

This classroom based workshop is the first in a series of workshops on Excel offered by the Data Academy.

Intermediate Excel

This classroom based workshop is the second in a series of workshops on Excel offered by the Data Academy. It builds on the fundamentals of Excel and introduces more advanced ways to manipulate and format data in spreadsheets.

Advanced Excel

This video-guided workshop is the third in a series of Excel workshops offered by Data Academy.

Excel Shortcuts

This short workshop is usually offered as a lunch time brown-bag. It serves to compliment the tools you will learn in the other Excel courses offered by the Data Academy. The tricks and tips it includes will save you time when performing analysis in Excel.