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.
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.
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.
A full-day course covering the key concepts of how to leverage the Python programming language for data analysis. The course covers 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.