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

Delivering Better Data & Research Insights [OPEN]

When someone approaches you with a problem, how do you ensure that the method you’ve chosen will give you answers? How do you distill problems into actionable research or data questions? And once you’ve got your question, how do you decide between quantitative or qualitative methods?

Intro to ArcGIS Online [OPEN]

Unleash the power of ArcGIS Online!! 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 Online and explore the ease with which it accomplishes advanced geoprocessing functions and its efficient data management tools. The class will consist of four short lecture/demonstrations paired with self-paced exercises.

Intro to ArcGIS Pro [OPEN]

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.

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 QGIS [OPEN]

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.

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 [OPEN]

Data analysis and manipulation is often done in Excel.  However, with larger and more complex datasets, a relational database (e.g. Oracle, Microsoft SQL Server/Access) is often a more popular and effective choice. This course introduces attendees to a global database language SQL (Structured Query Language).

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 [OPEN]

This course helps you unlock features of the City's open data portal to improve your own data workflows.

Intro to Power BI [OPEN]

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 [OPEN]

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.

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.

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.