Skip to main content

Exhibit D · UGA School of Medicine

FERPA-compliant admissions data foundation

A FERPA-compliant Microsoft Fabric data foundation for medical school admissions, led as a six-person capstone.

Client
UGA School of Medicine with the Carl Vinson Institute of Government
Role
Project leader and data manager of a six-person MSBA capstone
Dates
Spring 2026
  • Microsoft Fabric
  • Lakehouses
  • Notebooks
  • Pipelines
  • Semantic models
  • Power BI
  • Azure Key Vault
lakehouses
9
fields inventoried
805
mock applicants
2,051
dashboard tabs
6
01Role

Project leader and data manager

Project leader and data manager of a six-person MSBA capstone, Spring 2026.

  • Chartering
  • Weekly status reporting
  • Stakeholder communication
  • Task decomposition
  • Handoff package
  • Final presentation
  • Governance and architecture framing
02What It Delivered

A Fabric-centered medallion architecture

A Fabric-centered medallion architecture (Bronze, Silver, Gold, Ops) with 9 lakehouses, 15 notebooks, 2 pipelines, 2 semantic models.

Layers

  1. 01Bronze
  2. 02Silver
  3. 03Gold
  4. 04Ops
lakehouses
9
notebooks
15
fields inventoried
805
mock applicants
2,051

Bronze, Silver, Gold, and Ops layers as stacked planes; a mock applicant record passes through each in turn. 9 lakehouses, 15 notebooks, 805 fields inventoried, 2,051 mock applicants.

03Field Inventory

805 fields across 30 systems

A field inventory of 30 systems, 60 objects, 805 fields, and a 77-entity canonical model.

systems
30
objects
60
fields
805
entity canonical model
77
04Admissions Pipeline

2,051 mock applicant records, end to end

The AMP/AMCAS admissions pipeline moving 2,051 mock applicant records end to end into a published six-tab Power BI dashboard.

  1. Source

    AMP/AMCAS

  2. Pipeline

    2,051 mock applicant records, end to end

  3. Output

    Published six-tab Power BI dashboard

Executive Overview

Mock data · no values drawn

05Architecture

The system on Microsoft Fabric

Hover or focus a node to trace its lineage.

  • AMP/AMCAS feeds 2 pipelines
  • One45 feeds 2 pipelines
  • 2 pipelines feeds Bronze
  • Bronze feeds Silver
  • Silver feeds Gold
  • Gold feeds 2 semantic models
  • 2 semantic models feeds Power BI dashboard
Sources AMP/AMCAS and One45 feed 2 pipelines into the Bronze, Silver, and Gold lakehouse groups; Gold feeds 2 semantic models and the Power BI dashboard.
  • Azure Key Vault · secrets
  • RBAC model · 4 security groups
06One45 Pipeline

A weeks-long authentication blocker

The One45 pipeline, including a weeks-long authentication blocker diagnosed to a client_id versus client_key mismatch.

Mismatch

client_idversusclient_key
07Access Control

Four security groups

An RBAC model with four security groups and Azure Key Vault secrets.

  • Security group

    1

  • Security group

    2

  • Security group

    3

  • Security group

    4

Secrets

Azure Key Vault

08Handoff

Seven weekly status reports

Seven weekly status reports and a five-part handoff package.

  1. Report1
  2. Report2
  3. Report3
  4. Report4
  5. Report5
  6. Report6
  7. Report7

Handoff package

  1. Part 1
  2. Part 2
  3. Part 3
  4. Part 4
  5. Part 5