A training program for City and County of San Francisco staff. Explore, refine and enhance skills in data use, data management and process improvement.
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.
Sponsored by SFGIS, this course consists of five 3-hour sessions. Course content moves quickly through the basics of ArcGIS Pro before diving into more advanced topics in later sessions. A prior basic understanding of ArcGIS Pro is helpful due to the fast-paced nature of the class, but is not necessary if you are willing to work hard!
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.
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.
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.
This introductory course covers probability and common errors to avoid when problem solving using quantitative methods. It is intended for analysts and managers responsible for delivering public services and who are interested in the following subjects: data analytics, management, lean process improvement, quality management, and continuous learning. After this course, participants will have an understanding of basic terminology, how to calculate the probability of events, and methods to avoid biases.
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 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.
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.
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.
Data Academy does not offer an Advanced Excel course, finding that those who would like to take such an offering frequently have individual data analysis and manipulation needs. Please see this course page for more details.
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.
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.