Skip to Main Content

Data Services Class Descriptions

Information, materials, and schedules for all currently offered Data Services classes.

NYU Data Services: NYU Libraries and Information Technology logo.




For assistance, reach out by chat below or submit a request

We can be reached by email at

Join our Discord server

If you've met with us before, tell us how we're doing

Service Desk and Chat

Staffed Hours: Fall 2023
     Mondays:     12pm - 5pm
   Tuesdays:    12pm - 5pm
   Wednesdays:  12pm - 5pm
   Thursdays:   12pm - 5pm
   Fridays:     12pm - 5pm

chat loading...

Do you have unstructured geographic data and need to make a map? This class introduces essential strategies for cleaning data in preparation for visualization and analysis with GIS software platforms. We will use data scraped from a personal CitiBike user account as a test case for learning data remediation strategies for GIS analysis.

Google Sheets and Geocode by AwesomeTable (note: Data Services does not support this add-on, but you are encouraged to add it to your Sheets account in advance of the class)

Duration: 60 min

Room description:

Some tutorials are held remotely and require NYU sign on to access, while others are held in person, without a remote component. Please note the correct modality and location of the tutorial when registering

Prerequisites: Basic familiarity with Google Sheets formulas
Skills Taught / Learning Outcomes:
  • Identify meaningful units of analysis in order to structure data for mapping
  • Manipulate data in order to visualize and process it within various GIS platforms
  • Deploy essential formulas like CONCAT, COUNTIF, WEEKDAY, and others in order to clean up unwieldy data
  • Ascertain the value of establishing date, number, and categorical string variable types of data
  • Structure data to maximize the success rate of existing cloud-based geocoding APIs
Class Materials:
Related Classes:

Data Cleaning Using OpenRefine
Introduction to ArcGIS (ArcMap)
Data Cleaning and Management with Python

Additional Training Materials: Cleaning up your Excel 2013 data via LinkedIn Learning (NYU NetID required)

Upcoming sessions for this tutorial