A training program for City and County of San Francisco staff. Explore, refine and enhance skills in data use, data management and process improvement.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
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.
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.
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.
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.