RESOURCE COLLECTION
Course Catalog
Click into each course to learn more about learning objectives, logistic details, and any prerequisites.
Resources
Power BI
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.
Intermediate Power BI
This course will provide a strong foundation in Data Structure and Data Modeling through the tool of Power BI.
Advanced Power BI: Data Modeling (self-paced)
The goal of the video course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust.
Advanced Power BI: Mastering DAX (self-paced)
The goal of this video course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios.
Data Analysis
Developing Effective Research for Better Insights
This workshop will cover how to clarify requests, narrow down problems into actionable research questions, and choose between quantitative or qualitative methods.
Intro to R
This workshop will teach the practical skills necessary for reading data into R from external sources, manipulating the data, visualizing it, and covering other basic programming concepts as implemented in R.
Intro to SQL
This workshop will introduce you to SQL (Structured Query Language) so you can manipulate your data more elegantly and efficiently.
Intro to Statistics
This workshop will teach participants the building blocks necessary to understand the data they work with and conduct more advanced analysis in the future. Statistical concepts covered include probabilities, data variability measures and distributions, significance testing, and more.
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 Citywide Data Platform and Open Data
This course helps you unlock features of the internal Citywide Data Platform and the public-facing open data portal to improve your own data workflows.
Service Design in Government
The workshop teaches a systematic problem-solving process, strategies to enhance project planning, and effective meeting facilitation.
Mapping
Intro to ArcGIS Online
This workshop will cover display and exploration of spatial data, geo-located surveys, dashboards and Story Maps.
Intro to ArcGIS Pro
This workshop will leverage City of San Francisco geospatial data to demonstrate creating and editing GIS data as well as performing basic intermediate level spatial analysis techniques.
Intro to Python for GIS Analysis
This workshop will cover basic python use in GIS analysis.
Intro to QGIS
By completing this workshop you will be able to use QGIS to tinker with spatial data, perform analysis to answer interesting questions, and make beautiful maps
Process Improvement