Data Academy Course

Leveraging the City's Open Data [OPEN]

About this course

This course helps you unlock features of the open data portal to improve your own data workflows.

Have you heard of the City’s open data portal? Even if you haven’t, you should know that it’s much more than a transparency website and catalog of data. It actually has a powerful set of features you can leverage in your own data work. This course is most useful for those who want to use data from the portal, or want to understand how your department’s data can be loaded to the portal. It will help you to unlock data portal features to improve your own data workflows.

The class assumes you have working knowledge of Excel and a curiosity to learn new tools.

What you’ll learn in this course

  • Using the open data portal (30 min)
    • Finding a dataset
    • Creating filters and maps
    • Connecting your dataset to analysis tools (PowerBI, Excel)
  • Contributing to the open data portal (30 min)
    • Uploading a dataset
    • Creating metadata & other documentation
    • Publishing and sharing data


This workshop assumes that you are comfortable with data analysis and have manipulated data in Excel.

Upcoming courses scheduled

View the Course Calendar to see a list of upcoming classes. To get notified when enrollment opens for a class, complete the Course Interest Form and select the class (or classes) you’re interested in.

After completing the interest form, you will get an email when enrollment opens 3 weeks prior to class. Enrollment is not guaranteed as sometimes there are more interested employees than available seats.

Note: You must get your supervisor’s approval to attend any Data Academy courses.

More resources