Training Materials for Classes

Below are the links to materials for our in-person courses in open data, data analytics, and information visualization. We're still working to bring our high-quality teaching materials to the web so check back for content as it becomes available.

Learn more

Class Descriptions

 

Advanced GIS with QGIS and PostGIS

A full-day course for up to 20 employees proficient in loading and visualizing spatial data in QGIS or another GIS applications. The course covers advanced QGIS features and PostGIS functions for processing and analyzing real-world data to answer interesting and important analytical questions.

 

Analytics for the Data-Driven Manager

A two-day workshop for mid-level managers to explore data-driven thinking and data analysis. Using relevant examples from U.S. cities, open data, and Microsoft Excel, we give participants a taste of how analysts ask and answer questions using data and how policymakers apply those insights to real-life scenarios.

Class Outline / Lecture Slides / Class Handout - Day 1 / Class Handout - Day 2

 

Data Analysis with Python

A full-day course covering the key concepts of how to leverage the Python programming language for data analysis. The course will cover the basic syntax of Python as it relates to performing basic exploratory data analysis, as well as how to create impactful charts, graphs, and other information visualizations using NYC Open Data for operational decision making.

Class Outline / Lecture Slides / Class Handout

 

Data Analysis with R

A full-day course covering the key concepts of how to leverage the R programming language for data analysis. The course will cover the basic syntax of R as it relates to performing basic exploratory data analysis, as well as how to create impactful charts, graphs, and other information visualizations using NYC Open Data for operational decision making.

Class Outline / Lecture Slides / Class Handout

 

Data Analytics for Managers

This course introduces participants, especially managers and executives, to the concept of data-driven decision-making and management. Participants will learn how to better use data for setting goals and defining objectives, while identifying the proper metrics for those objectives and the elements of meaningful management dashboards. Participants will also learn how to assess the right analytical tools to manage projects, processes, and analytic staff within their departments.

Class Outline / Lecture Slides

 

Data Visualization with Excel

A full-day course covering the key concepts of how to create truthful and visually-compelling visualizations of important data. The course will cover how to create impactful charts, graphs, and other information visualizations in order to effectively communicate critical analysis to decision-makers, policymakers, and other key stakeholders.

Class Outline / Lecture Slides

 

Excel Tools: Summarizing Data

This course will address one of the greatest challenges managers face today: making sense of the data they already have. Being able to quickly and efficiently summarize and analyze data is essential to making better business decisions. Using Excel 2010, participants will be taught some of the most effective techniques in summarizing and displaying data to extract actionable intelligence quickly and accurately.

Class Outline / Supplemental Materials

 

Intermediate GIS with QGIS and PostGIS

A full-day course for up to 20 employees familiar with how to load and visualize spatial data in QGIS or another GIS applications. The course will cover how to load, process, and analyze real-world data using an open source spatial relational databases with QGIS to answer interesting and important analytical questions.

Class Outline / Lecture Slides / Class Handout

 

Introduction to GIS Fundamentals

A full-day course in basic spatial concepts and key features of QGIS for loading, styling, and analyzing spatial data with an emphasis on using real-world data to answer interesting and important analytical and operational questions. No experience with spatial data or GIS applications is assumed.

Class Outline / Lecture Slides / Class Handout

 

Introduction to Open Data

As the primary users of open data, city employees often have questions about the uses and issues around open data. With the growing trend towards making an ever-increasing amount of data available to the public, it's important city employees at all levels understand the opportunities and challenges of open data. This half-day course introduces participants to the idea and practice of open data with a discussion of the history of open data, the nature of open data, examples of how open data has been used to help cities be more responsive to their citizens, and examples when open data has been abused. The course offers city employees the opportunity to ask questions about open data, explore open data portals, and get hands-on experience working with open data in a basic exercise.

Lecture Slides

 

Introduction to Open Source Mapping

The process of creating maps has gone through radical changes over the past few decades. What was once a specialized craft using expensive tools and carefully curated data has now become something anyone can do as new, easy-to-use, and inexpensive (often free) tools have allowed professionals and hobbyists alike to create beautiful and informative maps with open data. This half-day course will briefly review the principles of mapping, discuss sources of online spatial data, and survey some of the open-source tools available, including QGIS and CARTO. Participants will get the opportunity to use these tools in a hands-on exercise.

Lecture Slides

 

Introduction to Statistical Analysis

This course introduces participants to the use of statistics for understanding and communicating city data. Using Excel, participants will learn how to use measures like mean, median, mode, standard deviation, and variance interval to understand the content of city data for making operational decisions. Participants will also learn how to display statistical information in meaningful ways.

Class Outline / Supplemental Materials

 

Leveraging Analytics

A full-day workshop for high-level managers and leaders to explore data-driven thinking and data analysis. Using relevant examples from U.S. cities, open data and Microsoft Excel, we give students a taste of how analysts ask and answer questions using data and how policymakers apply those insights to real-life scenarios.

Class Outline / Lecture Slides

 

Python for Census Data Analysis

An introduction to the use of Python to query Census data through the API in order to faciliate easier access and use of Census data for analysis

Class Outline / Lecture Slides

Back to top