Each year, dozens of news articles (and more school projects, data stories, and research papers than we know about!) are written using data from the Mayor’s Management Report (MMR). This report has been published twice a year since the 1970s, and data since 2016 is available in an Open Data set and an interactive tool called the Dynamic Mayor’s Management Report. In this presentation, analysts who compile the MMR at the Mayor’s Office of Operations will show you the data behind the news stories. We’ll walk you through using public data to identify trends that are relevant to public interest, and how to find multiple data points related to the same theme so you can see the broader picture. This event is an introduction to a specific dataset and various uses, and is suitable for anyone with interest in this topic, regardless of technical skill. Anyone who is interested in creating narratives or data stories for school or public use, or who is interested in understanding how data makes it from City agencies to the pages of a newspaper, is welcome to attend.

Power Query is perhaps the most useful but also most unknown of Microsoft programs. Ryan Yeung, Director of Performance Evaluation and Analytics, and Lori Lam, Data Analyst, from the Department of Citywide Administrative Services (DCAS) will demonstrate how to connect Power Query to the NYC Open Data and how to automate tedious Extract, Transform, Load (ETL) processes for use in Microsoft Excel or Microsoft PowerBI.

Join Data Dissemination Specialist Joli Golden to explore easy to use tools like QuickFacts and Census Narrative Profiles to find free local data to leverage in your grant proposals. See how to access the most current and relevant demographic statistics from the American Community Survey and the 2020 Census in data.census.gov. Take a look at how using different levels of geography in your searches and easy to create thematic maps can help you to build a more compelling case for grants. This training is recommended for all data users.

Have you ever wondered how parks in your neighborhood compare with others? Meet the Vital Parks Explorer! In this session, the Innovation & Performance Management (IPM) team from NYC Parks will share some highlights of how this public-facing tool was built. The Explorer visualizes access to parks amenities and services across the city. From inception and prototype, to public release, three data professionals working in local government will give you a behind-the-scenes look at how data, analysis, visualization, and user experience considerations shaped the final product. This event is for all New Yorkers who care about parks and might be of particular interest to advocates of public spaces, civic data enthusiasts, web app developers, designers, geospatial data scientists and engineers. We look forward to your participation and feedback!

Speaker bios:
Lilian Chin is a Data Analytics Specialist on Parks’ IPM team, where she has worked since September 2023. As part of IPM, she supports a wide-range of data-driven initiatives for Parks’ Maintenance and Operations. This includes visualizing the Work Order backlog, streamlining data pipelines for park assets, developing methodologies for the Park Condition Score, building in-house dashboards, and improving data quality and documentation.

Kate Sales is a Data Analytics Specialist on Parks’ IPM team. In the last year, she has worked on projects that touch many aspects of Parks including collecting and combining volunteer data for the Let’s Green NYC initiative, creating dashboards for Vital Parks for All, and helping others learn how to visualize data. Before Parks, Kate was a GIS analyst at the urban planning consulting firm Urban3 in Asheville, NC, her hometown. She recently completed her Master of Urban Planning at CUNY Hunter College and earned her BA in geography at Macalester College.

Benno Mirabelli is a Data Scientist on Parks’ IPM team. He works on various data analysis, reporting, research, and optimization projects. Some examples of his ongoing work include the routing analysis based on LION data for the recently released Vital Parks Explorer, research on understanding usership patterns and visitor volume at parks, and new management tools that assist with grass maintenance, planning, seasonal worker assignments and more. He holds a PhD in Applied and Computational Mathematics.

This session unveils two dashboards developed by the New York City Council Data team to transform large public datasets into accessible, actionable tools for the City Council. The CouncilCount and Max311 dashboards use data from the U.S. Census and NYC’s 311 Service Requests to offer insights tailored to the unique needs of each Council District.

Join us if you’re curious about creating dashboards for the public good, transforming large datasets into simple visuals, and delivering insights to decision-makers.

During this event, we will walk attendees through the dashboard development process. The CouncilCount dashboard provides demographic, socioeconomic, and other census data, curated specifically to help Council members better understand and serve their communities. Max311, on the other hand, leverages 311 Service Requests to track and analyze trends in community concerns, complaints, and issues reported by district.

The event will be a mix of presentation, live demo, and Q&A. We’ll start with an overview of the Council’s goals and challenges around public data, followed by a walkthrough of each dashboard. After demonstrating specific use cases, we’ll open the floor to questions and discussion on using open data for local government insights.