1 / 10

Building A P-20 Data Model

Building A P-20 Data Model. Dr. Domenico “Mimmo” Parisi Professor and Director Shon Myatt Software Architect June 17, 2011. Building A P-20 Data Model. Why link data longitudinally? Where is the data located? What data is available? Identify/Document data Create logical model

azura
Download Presentation

Building A P-20 Data Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Building A P-20 Data Model Dr. Domenico “Mimmo” Parisi Professor and Director Shon Myatt Software Architect June 17, 2011

  2. Building A P-20 Data Model • Why link data longitudinally? • Where is the data located? • What data is available? • Identify/Document data • Create logical model • Build /Populate physical model • Build BI system • Questions?

  3. Why link data Longitudinally?

  4. Why link data Longitudinally?

  5. Where is the data located? • MDHS • MDE • MDH • Head • Start • MDE • IHL • SBCJC • MDA • MDE • MDES • MDHS • MDRS • SBCJC

  6. Identify/Document data • Identify Programs and Respective Data • Create Codebook for Individual Programs • Create Program Data Mapping (PDM) for all Programs within an Organization • Create PDM for all Programs across all Organizations • Example: • MDHS Program Spreadsheet • MDHS Codebook • R&R PDTS - Mississippi Child Care Resource and Referral Network Professional Development Tracking System • MDHS PDM Spreadsheet • Early Childhood PDM Spreadsheet

  7. Create Logical Model High level overview of data interaction • INDIVIDUAL: • Parent • Teacher • Child has Individual 0..n has • ORGANIZATION: • Place of Employment • High School • Community College has has 0..1 1..n Organization Program 0..n • PROGRAM: • K12 Enrollment Program • Workforce Course/Training • WIA Enrollment 1..n has

  8. Build/Populate Physical Model • Construct database from logical model • Generate the physical database on the server that will house all of the data • Import data into physical model • Data Integrity • Manual/Automated data cleansing • Third-party Processing • Ex. Consolidate Race Codes, Ethnicity, etc.. • SLDS Data • Clearinghouse Automated Process

  9. Build BI System • Creation of BI and Appropriate use of Data • Reliability • Validity • One-Stop Online Portal • Data Governance

  10. Thank You Questions?

More Related