1 / 12

Building an Observation Data Layer

Building an Observation Data Layer. Bryan Enslein. What is an Observation Data Layer?. Layer with points of data collection First stage of data interpretation before manipulation. Why is this Needed?. Data is not Lacking! Communication lacking!

maili
Download Presentation

Building an Observation Data Layer

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 an Observation Data Layer Bryan Enslein

  2. What is an Observation Data Layer? Layer with points of data collection First stage of data interpretation before manipulation

  3. Why is this Needed? • Data is not Lacking! • Communication lacking! • Observation Layer bridges gap between user and supplier Data Data

  4. How is this Done? • SQL Server and HIS • DASH is the current user interface • User selects site, variable, dates

  5. The Process • Data from Flat File or Excel in various formats • Transform into MyDB • Format recognized by Observation Database Data Loader • Upload to Observation Data Model

  6. http://www.cuahsi.org/his/odm.html

  7. Check Data With ODM Tools

  8. Web Services

  9. ODM.ws Spreadsheet

  10. Future Work • Implement SQL Server Integrated Services • Automates the process

  11. Questions?

More Related