A Summary of the Meeting of May 30-June 1, 2001. Generating New Knowledge from Linked Administrative Data


Bong Joo Lee of Chapin Hall introduced the presenters. A Powerpoint presentation used by Ms. Hoglund of Minnesota follows the text.


Hawaii doesn't see itself as funding programs. Instead, it sees itself as funding outcomes or results. These results are brought into being by the efforts of multiple partners. They find it easier to track results when they control the funding, rather than when the federal government was separately funding some efforts. To serve as a baseline, Hawaii created school and community profiles. The profiles are to be built from 2000 Census data aggregated at the state high school complex level. School and community profiles link 50 core indicators that track such areas of concern as school readiness, child health, substance abuse prevention, and child safety. To address goals in these areas, Hawaii uses what it calls performance partnerships that link multiple government and community agencies that work together toward the shared goals.


Kath Hoglund, the Data Warehouse Administrator of the Minnesota Department of Human Services said that Minnesota's goal is to use its organized information to create new knowledge.

Currently, the Minnesota warehouse links:

  • TANF, Medicaid, Housing, Employment, and Child Support data both for the TANF federal report and for use in a TANF longitudinal study
  • Medicaid data to Public Health data to help study diabetes and asthma
  • Medicaid data to Social Security data to identify disabled children who are not receiving services
  • Statewide TANF performance measures

They have learned

  • To approach development incrementally
  • That, when feasible, to link the data in the source systems prior to extracting data to the warehouse
  • That the source data is most reliable when it is part of the purpose of the system
  • That similar data submitted by disparate systems often yield unreliable comparisons
  • That technology is no longer the issue; key issues are legal and political

Slide 1

Minnesota Department of Human Services Data Warehouse

Slide 2

Presenter Info

Slide 3

Linking Data provides a founation for creating new knowledge

Slide 4

Minnesota department of human Services was looking for a system to encompass the entire business....


Minnesota's solution: A Data Warehouse

Slide 6

What is a Data Warehouse

Slide 7

What is an Execitive Information System(EIS)?

Slide 8

What is Data Mining?

Slide 9

Minnesota DHS Data Warehouse

Slide 10

Minnesota DHS Data Warehouse

Slide 11

Logical Evolution of Reporting Using Data Warehousing

Slide 12

Incremental Approach

Slide 13

Minnesota Data Warehouse's Technology

Slide 14

DHS Configuration

Slide 15

Vital Statistics

Slide 16

Software Tools Accessing Our Data Warehouse

Slide 17

State of Minnesota department of Human Services Data Welhouse Logical Data Model

Slide 18

Technology is no longer the issue, the issues are legal and political

Slide 19

What have we done?

Slide 20

What have we learned?

Slide 21

Where are we going?