Projects

Welcome! Here you’ll find posts describing previous projects, including personal projects, that reflect some of my skills, interests, and growth. Feel free to explore! Use the filters to browse by category and dive into the areas that interest you the most.

Chinook BI Report: SQL-Driven Insights for a Digital Music Store

SQL
R
Shiny
Python
Dash
Tableau
Dashboard
Data Analysis
Business Intelligence
Exploratory Analysis
Retail Analytics
Chinook
Short
DuckDB

A portfolio project showcasing end-to-end analytics using SQL, R (+ Shiny), Python (+ Dash), and Tableau. Highlights KPI development, dashboard engineering, and business insight generation.

Aug 5, 2025
Morrigan M.

DETECT-RPC

RCT
REDCap
Public Health
Elder Mistreatment
EHR/EMR
Cerner
EPIC
Primary Care
IRB
Protocol Design
Dashboard
Health Informatics
Work Product
Academic Research

Multi-site randomized controlled trial evaluating DETECT-RPC, a revised elder mistreatment screening tool for primary care. Engaged with protocol and IRB development, EMR ETL planning, REDCap survey design, clinician training, and dashboard engineering. Coordinated across seven institutions.

Aug 1, 2025
Morrigan M.

DETECT 5-Year Follow-Up Evaluation

R
FastLink
Public Health
Elder Mistreatment
EMS
APS
Record Linkage
Data Cleaning
Fuzzy Matching
Reproducible Analysis
Health Informatics
Manuscript
Data Analysis
Work Product
Academic Research
Long
Mentorship

Extended public health informatics project analyzing the DETECT elder mistreatment screening tool embedded in EMS software. Developed a scalable fuzzy matching pipeline for fragmented APS records, linked across systems, and conducted stratified agreement and temporal trend analyses. Co-authored academic manuscript and mentored team members through high-volume data wrangling and linkage design.

Aug 1, 2025
Morrigan M.

Link2Care RCT: Data Rescue for a Multi-Modal Intervention Study

R
REDCap
SPSS
SAS
RCT
Public Health
Homelessness
Health Disparities
Social Justice
Record Linkage
Data Cleaning
Reproducible Analysis
Health Informatics
Work Product
Academic Research
Long

Rebuilt and documented a fragmented dataset for Link2Care, an RCT targeting health and housing outcomes among formerly incarcerated homeless adults. Standardized variables across QDS, REDCap, Excel, SPSS, and SAS inputs, created reproducible pipelines, and generated a full codebook. Final dataset included 1,606 subjects and 1,129 variables.

Jan 22, 2024
Morrigan M.

DETECT 1-Year Pilot Evaluation

R
FastLink
Public Health
Elder Mistreatment
EMS
APS
Record Linkage
Data Cleaning
Fuzzy Matching
Reproducible Analysis
Health Informatics
Manuscript
Data Analysis
Work Product
Academic Research
Long

Public health informatics project focused on evaluating the 1-year performance of the DETECT elder mistreatment screening tool embedded in EMS software. Built fuzzy-matched subject IDs, linked data across EMS and APS systems, and conducted multi-level fidelity and reporting analyses using R. Fully reproducible pipeline with annotated narrative code and manuscript draft.

Sep 11, 2023
Morrigan M.
No matching items
Back to top