Building an Observation Data Layer

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
(No Transcript)
10
ODM.ws Spreadsheet
11
Future Work

• Implement SQL Server Integrated Services
• Automates the process

12
Questions?