North East Association for Institutional Research

Using DuckDB in RStudio for Institutional Research: Fast, Local SQL for Enrollment, Retention, and Reporting
Date/Time
7/14/2026
10:30 AM - 12:00 PM Eastern
Event Registration
Register for this Event
Event Type(s)
Workshop Webinars
Event Description
This introductory session explains how DuckDB can speed Institutional Research workflows inside RStudio by providing an in process analytical SQL engine that runs inside RStudio.

Participants in this session learn:
  • How to connect to DuckDB in RStudio and run SQL against local files and in memory tables.
  • How to combine DuckDB with R packages like dplyr and dbplyr to keep familiar R syntax while gaining SQL performance.
  • IR patterns for DuckDB including fast cohort extraction, large file joins, and exporting query results for dashboards and reports.
Intended Audience: All levels. Best for IR staff who work with institutional datasets and want faster SQL analytics inside RStudio. A basic understanding of R, RStudio, and SQL is recommended though not required. The workshop will not focus on DuckDB or RStudio installation but will provide guidance on how to install, set up, and use DuckDB in RStudio. 

Format:  Webinar - recorded sessions in which attendees view content and interact only via chat

Cost:  $40 - Member; $100 Non-Member

Presenter: James Salamon, Massachusetts College of Pharmacy and Health Sciences (MCPHS) 

Tuesday, July 14, 2026; 10:30 AM - NOON
Outlook/vCalendar/Google
Click on the icon next to the date(s) to add to your calendar:
7/14/2026   Outlook Calendar Apple Calendar Google Calendar
Email Reminder
Click here to setup an email reminder for this event


return to North East Association for Institutional Research (NEAIR), Inc.