BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
PRODID://NEAI//214719
BEGIN:VEVENT
DTSTAMP:20260525T152207
VTIMEZONE:America/New_York
DTSTART:20260714T143000Z
DTEND:20260714T160000Z
UID:214719
SUMMARY:Using DuckDB in RStudio for Institutional Research: Fast, Local SQL for Enrollment, Retention, and Reporting
LOCATION:
DESCRIPTION:Using DuckDB in RStudio for Institutional Research: Fast, Local SQL for Enrollment, Retention, and Reporting\n\n07/14/26 10:30 AM EST\n - 07/14/26 12:00 PM EST\Description:\nThis introductory session explains how DuckDB can speed Institutional Research workflows inside RStudio by providing an in process analytical SQL engine that runs inside RStudio.\n\nParticipants in this session learn:\n\n	How to connect to DuckDB in RStudio and run SQL against local files and in memory tables.\n	How to combine DuckDB with R packages like dplyr and dbplyr to keep familiar R syntax while gaining SQL performance.\n	IR patterns for DuckDB including fast cohort extraction, large file joins, and exporting query results for dashboards and reports.\n\nIntended 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. \n\nFormat: \n\n\nWebinar - recorded sessions in which attendees view content and interact only via chat\n\nCost:  $40 - Member; $100 Non-Member\n\nPresenter: James Salamon, Massachusetts College of Pharmacy and Health Sciences (MCPHS) \n\nTuesday, July 14, 2026; 10:30 AM - NOON
X-ALT-DESC;FMTTYPE=text/html:Using DuckDB in RStudio for Institutional Research: Fast, Local SQL for Enrollment, Retention, and Reporting<br /><br />07/14/26 10:30 AM EST - 07/14/26 12:00 PM EST<br />Description:<br />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.<br />
<br />
Participants in this session learn:
<ul>
	<li>How to connect to DuckDB in RStudio and run SQL against local files and in memory tables.</li>
	<li>How to combine DuckDB with R packages like dplyr and dbplyr to keep familiar R syntax while gaining SQL performance.</li>
	<li>IR patterns for DuckDB including fast cohort extraction, large file joins, and exporting query results for dashboards and reports.</li>
</ul>
Intended Audience: All levels. Best for IR staff who work with institutional datasets and want faster SQL analytics inside RStudio.&nbsp;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.&nbsp;<br />
<br />
Format:&nbsp;
<style type="text/css"><!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}-->
</style>
Webinar - recorded sessions in which attendees view content and interact only via chat<br />
<br />
Cost:&nbsp; $40 - Member; $100 Non-Member<br />
<br />
Presenter: James Salamon, Massachusetts College of Pharmacy and Health Sciences (MCPHS)&nbsp;<br />
<br />
Tuesday, July 14, 2026; 10:30 AM - NOON
PRIORITY:3
TRANSP:TRANSPARENT
BEGIN:VALARM
TRIGGER:-PT5M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR