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 the monthly City Analyst Network newsletter

You must sign up with your CCSF work email.

* indicates required

Getting Things Done (Online)

*During COVID response period, this training will be offered online.* Getting Things Done is the Lean Team’s antidote to the obstacles we each encounter in our daily work life: the overflowing inbox, the never-ending to-do list, the mountain of papers on your desk. Based on David Allen’s book of the same name, Getting Things Done will give you super-practical tools to start applying lean principles to increase your personal productivity.

Lean 101

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

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.

Service Design in Government

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.

ArcGIS Pro

Unleash the power of ArcGIS Pro! This four-hour workshop is designed for both new GIS users and those who are familiar with Arc Map or QGIS. We will become familiar with core GIS functionality in ArcGIS Pro and explore the ease with which Pro accomplishes advanced geoprocessing functions and its efficient data management tools. The class will consist of four short lecture/demonstrations paired with self-paced exercises.

Data Usability

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.

Intro to Group Facilitation

Do you participate in or lead meetings where important decisions are discussed?  Whether in the context of weekly staff meetings or an inter-agency working group, well-designed meeting can lead to better decisions.  Data Academy is offering a new half-day training on group facilitation, where attendees will learn key approaches and skills to support inclusive and efficient decision-making.

Intro to 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.

Intro 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.

Intro to SQL

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.

Intro to Statistics

In this two-part introductory statistics course, participants will learn the building blocks necessary to understand the data they work with and conduct more advanced analysis in the future. Topics covered in the first part include: statistical terminology, introduction to sampling, summarizing data through central tendency measures, understanding data variability measures, and examining distributions of data. The second part will build on this content, with topics covering: introduction to probabilities, how to tell if statistics are meaningfully different from one-another, and how to make inferences about populations using samples. It is recommended that students attend part one or be familiar with the topics discussed in part one before attending part two of this series.

Intro to Survey Design

This classroom-based workshop is an interactive course meant for beginner to intermediate surveyors. It covers basic topics like: when should you survey, how to talk about surveys, and how to design a survey.

Leveraging the City's Open Data

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.

QGIS

Unleash the power of QGIS! This four-hour workshop is designed for both new GIS users and those who are familiar with GIS. We will become familiar with core mapping functionality in QGIS and explore the ease with which it accomplishes basic data management, geoprocessing functions and visualization. The class will consist of three short lecture/demonstrations paired with self-paced exercises.

Excel Best Practices

Do you ever wonder if Excel can help you do more with data? This class will teach you to set up your information in a way that maximizes Excel's capabilities and make your data as accessible and useful as possible. This is not an Excel skills class, but provides discussion and practice is how to use the program to greatest effect. This course is for basic Excel users - you should know how to move around a spreadsheet but don't need extensive knowledge.

Intro to Excel

This classroom-based workshop is the first in a series of workshops on Excel offered by the Data Academy. It covers very basic topics and assumes no prior experience with the program.

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 formulas and ways to manipulate and format data in spreadsheets.

Excel Shortcuts

This short workshop serves to compliment the tools you will learn in other Excel courses offered by the Data Academy, and your existing skills. The tricks and tips it includes will save you time when performing analysis in Excel. This class uses keyboard shortcuts and some more advanced concepts and formulas to improve productivity and efficiency working in Excel.

Intro to 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.

Intermediate Power BI: Data Modeling

This course is the 2nd in DataSF’s series on PowerBI.  This course will provide a strong foundation in Data Structure and Data Modeling through the tool of PowerBI.  Analyst tasked with getting multiple data sources to talk to each other in PowerBI will find this class of use.

Intro 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

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.

Advanced Tableau

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.

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.