A Data Request Interface

[Peter WONTUO]

Dear All,

 

As part of the development effort to get OpenHDS to function well and efficiently, I wish to introduce a possible of adding a Data Request Interface, a process that is widely done manually by many data extractors of DSS data.  Please, your views on this will be most welcome to the developing group, I hope.

 

Data Request Interface

At the OpenHDS expo, one of the major argument with existing systems was how best to keep data quality high because one of the causes was attributed to data users/managers working directly on the data tables at the back end.  This I must say was a necessary evil because systems developed for DSS operations never had any data request interface hence Managers in their quest to answer the numerous dynamic unstructured data request have no option either than “attacking data” from the back end.

With my long experience with DSS activities and a small study I did with the Navrongo system, I wish to share with you how close to I managed this hoping it will be a developing interface for the OpenHDS developers.

Step 1 – Data Warehouse

All Data request should be extracted from an archived most current round data.  In that case, when a round is fully completed, that data set is archived in a data warehouse for data request extraction.

Step 2 – Data Extraction

Data request either the entire study area, selected FWA, Locations or Households.

Data request could be all age group or selected age group

Data request could be both gender or selected (M or F)

Data request could be by some percentage randomized or not

Data request could be on some selected variables or all

Step 3 – Output

Output could be electronic, hard copy or both

This data request list could be expanded to include more other option.

Thanks

 

 

======================================================

Peter Wontuo (PW)

Health Research Officer (IT)

Navrongo Health Research Centre (NHRC) - GHS

P. O. Box 114 > > Navrongo KNED/UER - Ghana W/A

Tel:  +233-3821-22380(Director)/22310(Admin)/22716(Server Room)

Fax: +233-3821-22320 - Cell:  +233 24 4010034 / 20 7389978

Alt email: pwo...@hotmail.com; Peter....@gmail.com

Website: www.navrongo.org  NOTE the change in my email address to pwo...@navrongo.mimcom.ORG

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 

·Adding manpower to a late software project makes it later.  Luke 6:41-42

 

 

[Iwara Arikpo]

Dear Peter,
Thanks very much for this wonderful initiative.
Iwara (CRHDSS Nigeria)

--
You received this message because you are subscribed to the Google Groups "openhds-users" group.
To post to this group, send email to openhd...@googlegroups.com.
To unsubscribe from this group, send email to openhds-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/openhds-users?hl=en.

[Mike Ushie]

Thanks for the update, we hope to key in well

On Fri Dec 17th, 2010 10:27 AM PST Iwara Arikpo wrote:

>Dear Peter,
>Thanks very much for this wonderful initiative.
>Iwara (CRHDSS Nigeria)
>
>On Fri, Dec 17, 2010 at 3:22 PM, Peter WONTUO
><PWo...@navrongo.mimcom.org>wrote:
>
>> Dear All,
>>
>>
>>
>> As part of the development effort to get OpenHDS to function well and
>> efficiently, I wish to introduce a possible of adding a Data Request
>> Interface, a process that is widely done manually by many data extractors of
>> DSS data. Please, your views on this will be most welcome to the developing
>> group, I hope.
>>
>>
>>

>> *Data Request Interface*

>>
>> At the OpenHDS expo, one of the major argument with existing systems was
>> how best to keep data quality high because one of the causes was attributed
>> to data users/managers working directly on the data tables at the back end.
>> This I must say was a necessary evil because systems developed for DSS
>> operations never had any data request interface hence Managers in their
>> quest to answer the numerous dynamic unstructured data request have no
>> option either than “attacking data” from the back end.
>>
>> With my long experience with DSS activities and a small study I did with
>> the Navrongo system, I wish to share with you how close to I managed this
>> hoping it will be a developing interface for the OpenHDS developers.
>>
>> Step 1 – Data Warehouse
>>
>> All Data request should be extracted from an archived most current round
>> data. In that case, when a round is fully completed, that data set is
>> archived in a data warehouse for data request extraction.
>>

>> Step 2 – Data Extraction
>>
>> Data request either the entire study area, selected FWA, Locations or
>> Households.
>>
>> Data request could be all age group or selected age group
>>
>> Data request could be both gender or selected (M or F)
>>
>> Data request could be by some percentage randomized or not
>>
>> Data request could be on some selected variables or all
>>
>> Step 3 – Output
>>
>> Output could be electronic, hard copy or both
>>

>> This data request list could be expanded to include more other option.
>>
>> Thanks
>>
>>
>>
>>
>>

>> *======================================================*
>>
>> *Peter Wontuo (PW)*
>>
>> *Health Research Officer (IT)*
>>
>> *Navrongo Health Research Centre (NHRC) - GHS*
>>
>> *P. O. Box 114 > > Navrongo KNED/UER - Ghana W/A*
>>
>> *Tel: +233-3821-22380(Director)/22310(Admin)/22716(Server Room)*
>>
>> *Fax: +233-3821-22320 - Cell: +233 24 4010034 / 20 7389978*
>>
>> *Alt email: **pwo...@hotmail.com; Peter....@gmail.com*<http://mc/compose?to=pwo...@hotmail.com>
>> **
>>
>> *Website: **www.navrongo.org* <http://www.navrongo.org>* NOTE the change
>> in my email address to **pwo...@navrongo.mimcom.**ORG*<http://mc/compose?to=pwo...@navrongo.mimcom.ORG>
>> **
>>
>> *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> *
>>
>> *·Adding manpower to a late software project makes it later. Luke 6:41-42
>> *

>>
>>
>>
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "openhds-users" group.
>> To post to this group, send email to openhd...@googlegroups.com.
>> To unsubscribe from this group, send email to

>> openhds-user...@googlegroups.com<openhds-users%2Bunsu...@googlegroups.com>

[Dave R]

Peter, I can see how this would be a very useful feature for the data
managers. Is it usually only Individual level data that managers are
after? From the screen shots you attached, it appears users can filter
the fields they want to show up on the output.

On Dec 17 2010, 9:22 am, "Peter WONTUO" <PWon...@navrongo.mimcom.org>
wrote:

> Dear All,
>
> As part of the development effort to get OpenHDS to function well and
> efficiently, I wish to introduce a possible of adding a Data Request
> Interface, a process that is widely done manually by many data
> extractors of DSS data.  Please, your views on this will be most welcome
> to the developing group, I hope.
>
> Data Request Interface
>
> At the OpenHDS expo, one of the major argument with existing systems was
> how best to keep data quality high because one of the causes was
> attributed to data users/managers working directly on the data tables at
> the back end.  This I must say was a necessary evil because systems
> developed for DSS operations never had any data request interface hence
> Managers in their quest to answer the numerous dynamic unstructured data
> request have no option either than "attacking data" from the back end.
>
> With my long experience with DSS activities and a small study I did with
> the Navrongo system, I wish to share with you how close to I managed
> this hoping it will be a developing interface for the OpenHDS
> developers.
>

> Step 1 - Data Warehouse

>
> All Data request should be extracted from an archived most current round
> data.  In that case, when a round is fully completed, that data set is
> archived in a data warehouse for data request extraction.
>

> Step 2 - Data Extraction

>
> Data request either the entire study area, selected FWA, Locations or
> Households.
>
> Data request could be all age group or selected age group
>
> Data request could be both gender or selected (M or F)
>
> Data request could be by some percentage randomized or not
>
> Data request could be on some selected variables or all
>

> Step 3 - Output

>
> Output could be electronic, hard copy or both
>

> This data request list could be expanded to include more other option.
>
> Thanks
>
> ======================================================
>
> Peter Wontuo (PW)
>
> Health Research Officer (IT)
>
> Navrongo Health Research Centre (NHRC) - GHS
>
> P. O. Box 114 > > Navrongo KNED/UER - Ghana W/A
>
> Tel:  +233-3821-22380(Director)/22310(Admin)/22716(Server Room)
>
> Fax: +233-3821-22320 - Cell:  +233 24 4010034 / 20 7389978
>

> Alt email: pwon...@hotmail.com; Peter.Won...@gmail.com
>
> Website:www.navrongo.org<http://www.navrongo.org>   NOTE the change in
> my email address to pwon...@navrongo.mimcom.ORG
>
>
>
> *Adding manpower to a late software project makes it later.  Luke
> 6:41-42
>
>  image005.jpg
> 28KViewDownload
>
>  image006.jpg
> 30KViewDownload

[Peter WONTUO]

Hi Dave,

At time they may request for sample locations or households but that is very uncommon. Yes, they may also specify variable that they will want to have. I did this based on the commonly requested pattern. I hope other sites could come out with what pertain at their sites.
Regards

Peter

--