Thursday, July 5, 2018

Bringing order to chaos: ICH's data services


Karen Finnegan, MPH 
Research and Evaluation Scientist 

As an epidemiologist trained in health systems research, I spend much of my time with quantitative data—numbers, statistics, writing code in SAS or R. However, my favorite projects are those which are a jumble of data and require making sense of a heap of numbers before we can even begin the analysis. My background is in global health, specifically in using service numbers collected by governments to document the number of diagnoses made at community health centers and hospitals throughout the country. In those databases, it is common to have missing data for a few months—maybe even a year—at a time.
Drawing on this background, my favorite ICH projects are those which are rich in data, but only when we do some digging to understand what we have. The challenges have been varied. We’ve worked with:
  • Data from a 14-year period with each year stored in a different database;
  • Data collected by different people over time and documented in different ways;
  • Changing variable names and definitions;
  • Surveys with low response rates;
  • Organizational data with changing metrics and variability across departments;
  • Data stored in Access, Excel, SQL, online databases, and on paper;
  • Changing electronic medical records databases.

Each data challenge has its own unique solution and determining how to use the data is part of the fun. My work at ICH has involved large and small databases, each of which has its own compelling story to tell.

Last year, we assisted the Mental Health First Aid program at Cambridge Public Health Department in managing their registration data. Mental Health First Aid educates community members about how to support people who are experiencing a mental health or substance-use related crisis. The program had registration data for hundreds of trainees, but data were stored in numerous files, there was no way to automatically know when people were due for a refresher course, and reporting on numbers trained was an onerous challenge. Our support included:
  • Developing an online registration form to streamline data collection
  • Building a registration database with fields which automatically flag participants who did not complete the initial training or who are eligible for refresher training
  • Creating reports to make monthly, quarterly, and annual reporting a streamlined process.

By creating a user-friendly database that meets the needs of the program, we were able to support the data collection process and pave the way for future evaluation work.

1 comment:

  1. I am bold enough among many others to state that there is now a potent cure to this sickness but many are unaware of it. I discovered that I was infected with the virus 3 months ago, after a medical check-up. My doctor told me and I was shocked, confused and felt like my world has crumbled. I was dying slowly due to the announcement of my medical practitioner but he assured me that I could leave a normal life if I took my medications (as there was no medically known cure to Herpes). I went from churches to churches but soon found that my case needed urgent attention as I was growing lean due to fear of dying anytime soon. In a bid to look for a lasting solution to my predicament, I sought for solutions from the herbal world. I went online and searched for every powerful trado-medical practitioner that I could severe, cos I heard that the African Herbs had a cure to the Herpes syndrome. It was after a little time searching the web that I came across one Dr Itua(A powerful African Herbal Doctor), who offered to help me at a monetary fee. I had to comply as this was my final bus-stop to receiving a perfect healing. My last resolve was to take my life by myself, should this plan fail. At last it worked out well. He gave me some steps to follow and I meticulously carried out all his instructions. Last month, to be precise, I went back to the hospital to conduct another test and to my amazement, the results showed that negative,Dr Itua Can As Well Cure The Following Desease…Cancer,Hiv,Herpes, Hepatitis B,Liver Inflammatory,Diabetis,Fribroid, Dercum,fibromyalgia,Get Your Ex Back,Als,SYPHILLIS. You can free yourself of this Herpes virus by consulting this great African Herbal Doctor via this e-mail: drituaherbalcenter@gmail.com or call and whatsapp him on +2348149277967 He will help you and his herb medication is sure. he has the cure on all disease .You can talk to me on INSTAGRAM..tashamoore219....

    ReplyDelete