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

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.

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.

Power BI

This course is designed to give you a strong foundation in Power BI and a jump-start on your 1st Power BI project. Power BI is a powerful, low-cost program that focuses on the entire business intelligence chain: from data wrangling to visualizing to sharing to automation.

Project Management

This course will cover fundamental concepts in project management and is meant for a beginner audience. It will focus on the use of project management tools for improved day-to-day management of and contribution to City projects.

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.

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?  This training aims to introduce you to the Lean methodology and the tools you need to rapidly improve the work you do every day.

Lean Leaders – Learn to lead your own process improvement project

Lean Leaders is a multi-day Lean Process Improvement training that raises up change agents in City departments through hands-on observation, making rapid innovations, and coaching staff through change. Participants work with their supervisor and leaders in their department to identify a process problem that they will work on throughout the training. Each trainee will leave the training equipped to lead their own improvement projects and make measurable change to a department business process.

Innovating City & County Services Using Design Thinking, Behavioral Economics and Visual Facilitation

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.

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.

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.

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.

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.