building an observation data layer
DESCRIPTION
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! - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/1.jpg)
Bryan Enslein
![Page 2: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/2.jpg)
What is an Observation Data Layer?
•Layer with points of data collection•First stage of data interpretation before manipulation
![Page 3: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/3.jpg)
Why is this Needed?Data is not Lacking!Communication lacking!Observation Layer bridges gap between user
and supplier
![Page 4: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/4.jpg)
How is this Done?SQL Server and HISDASH is the current user interfaceUser selects site, variable, dates
![Page 5: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/5.jpg)
The ProcessData from Flat File or Excel in various formatsTransform into MyDB
Format recognized by Observation Database Data LoaderUpload to Observation Data Model
![Page 6: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/6.jpg)
http://www.cuahsi.org/his/odm.html
![Page 7: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/7.jpg)
Check Data With ODM Tools
![Page 8: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/8.jpg)
Web Services
![Page 9: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/9.jpg)
![Page 10: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/10.jpg)
ODM.ws Spreadsheet
![Page 11: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/11.jpg)
Future WorkImplement SQL
Server Integrated Services
Automates the process
![Page 12: Building an Observation Data Layer](https://reader035.vdocuments.us/reader035/viewer/2022062301/56816168550346895dd0f2f3/html5/thumbnails/12.jpg)
Questions?