Skip to content
Home » Training

Training

training

Do your people have the data skills they need to apply their talents and deliver meaningful results?

We provide engaging, relevant, and impactful learning experiences using practical learning frameworks with real-world applications to build proficiency in the key skills your people need to develop actionable insights from your data.

What we do

We teach the functional skills necessary to make data a strategic asset for organizations.

We provide training in the functional skills necessary to perform reliable, repeatable, and actionable data analysis with tools such as Excel, PowerBI, Tableau, QGIS, RStudio, and Python, building proficiency and mastery of key skills, including collecting, storing, formatting, cleaning, summarizing, aggregating, and communicating data.

We teach methods of descriptive analysis, statistical analysis, predictive modeling, data visualization, machine learning, mapping, and spatial analysis using real-world data and case studies to provide realistic and relevant learning experiences in each of our classes.

HOW WE DO IT

We deliver classes in-person, online, and in hybrid learning environments.

Our live sessions, whether in person or online, are dynamic experiences where students interact with the instructor and each other to share knowledge and experience. Our classes minimize lectures to maximize time spent on learning exercises with real government data. Learning comes from solving realistic problems in a supportive environment. This supports the development of skills that can be directly applied to the learner’s day-to-day work.

In-Person
Training

eLearning
Modules

Online Courses & Webinars

Data Analysis

Introducing key concepts and essential functional skills in data analysis, including collecting, organizing, summarizing, and communicating insights for impact.

  • Data Analysis Fundamentals
  • Introduction to Spreadsheets
  • Analyzing Data with Excel
  • Advanced Data Analysis with Excel
  • Statistical Analysis with Excel
  • Analyzing Data with R
  • Analyzing Data with Python
  • Analyzing Data with SQL
  • Machine Learning and AI for Government

  • Data Visualization

    Introducing key concepts and essential functional skills for visualizing data for insight, impact, and action, whether in spreadsheets for reports or interactive dashboards.

  • Data Visualization Fundamentals
  • Visualizing Data with Excel
  • Principles of Data Dashboard Design
  • Visualizing Data with PowerBI
  • Visualizing Data with Tableau

  • Spatial Analysis & Digital Mapmaking

    Introducing key concepts and essential functional skills for collecting, analyzing, and visualizing spatial data to drive critical decision making.

  • Introduction to Open Source Mapping
  • Introduction to GIS Fundamentals
  • Spatial Data Analysis with QGIS and PostGIS
  • Digital Mapmaking with QGIS
  • Data Leadership & Management

    Introducing participants to the critical issues and important opportunities that come with being a more data-driven organization.

  • Introduction to Open Data
  • Data Analytics for Managers
  • Leading with Data

  • Contact us to learn about options for customizing the learning experience for your staff

    Trusted Trainers For

    Data Analysis With Excel

    A full-day course introducing key concepts in data analysis, including problem ideation, process mapping, and communicating data. Leveraging design thinking and collaboration, we model a culture of data-driven problem exploration and understanding.

    A one-day class introducing the skills necessary to clean, process, and visualize government open data with Microsoft Excel. This class reinforces problem ideation and process mapping skills taught in Introduction to Data Analytics, as well as introduces best practices for documenting work. 

    A one-day class reinforcing the skills necessary to clean, process, and visualize NYC Parks data, as well as introducing advanced functions and formulas, including joins, logic functions, and more advanced data visualization techniques with Microsoft Excel. This class reinforces problem ideation and process mapping skills taught in Introduction to Data Analysis and reinforces best practices for documenting work.

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

    Data Leadership and Management

    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.

    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 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 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.

    Mapping and Spatial Analysis

    A full-day course introducing key concepts in data analysis, including problem ideation, process mapping, and communicating data. Leveraging design thinking and collaboration, we model a culture of data-driven problem exploration and understanding.

    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.

    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 covers 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 for up to 20 employees familiar with how to load and visualize spatial data in QGIS or another GIS applications. The course covers advanced techniques of data extraction, transformation, and loading, as well as key concepts in data management, documentation, and analytical integrity using real-world data using an open-source spatial relational databases with QGIS to answer interesting and important analytical questions.

     

    A one-day class reinforcing the skills necessary to leverage a geographic information system (GIS) to clean, process, and visualize government open data. The class introduces key concepts and skills necessary to use a GIS for data analysis, reinforcing the problem ideation and process mapping skills taught in Introduction to Data Analysis.

    Advanced Data 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.

    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.

    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 one-day class reinforcing the skills necessary to leverage a relational database to clean, process, and visualize government open data. The class introduces key concepts and skills necessary to use the Structured Query Language (SQL) for data analysis, reinforcing the problem ideation and process mapping skills taught in Introduction to Data Analysis. 

    A 70-hour course covering the key concepts, applications, and practice of machine learning with Python. The course assumes little prior familiarity with either Python or machine learning, introducing basic descriptive statistics as they apply to predictive analytics, as well as supervised and unsupervised learning.