1 of 15

Utah Medical Education Council

Clark Ruttinger, Beau Montgomery,

Arthur Philips, Min Suh

IS 6480 Data Warehousing

2 of 15

About UMEC

  • Created in 1997 by H.B.141
    • This legislation authorized the UMEC to conduct ongoing health care workforce analyses and to assess Utah’s training capacity and graduate medical education (GME) financing policies.
      • “Advise the State Board of Regents and the Legislature on the status and needs of health care professionals in training”
      • “conduct surveys…, to assess and meet changing market and education needs”
      • “appoint advisory committees of broad representation on interdisciplinary clinical education, workforce mix planning and projections, funding mechanisms, and other topics as is necessary”
      • 2014- Appointed as Utah’s Nursing Workforce Information Center.

​

3 of 15

Council Composition

  • Dean of the Medical School at the U of U
  • Representatives from:
    • Residency programs in the state
      • IHC (3 programs) – St. Marks, - U of U
    • Health insurance industry
    • Three from general public

​

​

4 of 15

Project Description

  • Academic Leadership Committee
    • Annual Education Data
      • Used to inform nursing policy makers on nursing education in the state.
        • data collected since 2006
          • This project uses 2016-2017 data. Previous years will be pulled in later.
  • DW design will be used as a prototype
    • 30+ siloed data sets on all medical professions in the state to be integrated and standardized for improved analytics capabilities

5 of 15

Need for Data Warehouse

  • Growth of professions analyzed from only physicians in the beginning to currently 15 different professions

​

  • Difficulty to manually analyze growing amount of data

  • UMEC data being used by more entities and for new purposes not originally anticipated.

6 of 15

About the Data set

  • Online Survey- Qualtrics
  • 20 Nursing institutions across the state
    • Public/ private institutions all participated
    • Multiple programs within each institution
      • (LPN, Associates, Bachelors, Masters, PhD etc…)
  • 2 years of data
    • ALC has data back to 2006
      • Past data is more incomplete, further integration as a next step

7 of 15

Data Set

  • Questions Include:
    • Student/ Faculty Demographics
    • Program Capacity
    • Program Graduates
    • NCLEX Pass Rates
    • This data is used in modeling future workforce needs

8 of 15

Logical Model

9 of 15

Dimension Table Integration

10 of 15

Fact Table Integration

11 of 15

Tables Loaded

12 of 15

JPivot Results

13 of 15

Data Integration Difficulties

14 of 15

Future work

​

  • Work out reports for survey measures by program type and year to show change over time.

​

  • Create access roles in Pentaho based on ALC committee desires.

​

  • End goal of a self-service front end dashboards.

15 of 15

Questions