top of page

CLASSES

BRING THIS TRAINING TO YOUR ORGANIZATION.

Data Analysis with Excel

Introduction to Data Analytics

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.

Lecture Slides / Class Handout / Slide Source Code

Excel for Data Analysis I

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. Working collaboratively in small groups, participants develop an analytical question they explore throughout the class, presenting their data story at the end of class for constructive feedback.

Lecture Slides / Class Handout / Slide Source Code

Excel for Data Analysis II

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. Working collaboratively in small groups, participants develop an analytical question they explore throughout the class, presenting their data story at the end of class for constructive feedback.

Lecture Slides / Class Handout / Slide Source Code

Data Visualization with Excel

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.

Lecture Slides / Class HandoutSlide Source Code

intro-data-analytics
data-vis-excel
excel-analysis-i
excel-analysis-ii
bottom of page