Consolidating Reporting Across 40 Countries Using SDK:Analyze

There are many challenges in conducting research studies in a variety of countries in remote parts of the world:
  1. How do you collect the data? Should you use paper? Excel? Mobile?
  2. How do you coordinate activities among such a wide cross section of people?
  3. How do you then analyze the data in a timely fashion to spot trends, problem areas, or areas where things have improved?

This case study will focus on the third pain point above: data analysis.

More specifically, how do you analyze data from 40 different countries, share that analysis to a variety of folks, and do it in **real time** so you can make changes on the fly?

Several types of organizations use SDK:Analyze to improve analysis processes: NGOs, Faith based organizations, and large public health organizations. In this particular case, a Very Large Public Health Organization (VLPHO) needed a way to track and analyze capacity building across 40 countries on multiple continents for vaccine preventable diseases. They were already using SDK:Collect to do mobile data collection in the field using android (and in some cases, iPhones) to gather the following:

  1. What activities are being performed?
  2. Who is performing them?
  3. How are they performing them?
  4. What challenges have they encountered?

Before implementing SDK:Analyze, they'd manually pull data out of SDK by downloading it to excel, building some graphs and charts by hand, and distributing the report via email. If you've read the case study this far, you're probably very familiar with this routine. In fact, odds are you've done it a bunch yourself - I know we have on the Secure Data Kit team!

But there's a better way, right? (hint — the answer is YES! SDK:Analyze!)

Working closely with our contacts at VLPHO, we redesigned a responsive, web based, interactive report that feeds off the data collected with SDK:Collect to generate the report automatically using the most current data.

"The report generated from our SDK data has given us a comprehensive and detailed overview of activities being conducted in over 40 countries by experts working to combat vaccine-preventable diseases. We are now able to understand activities, challenges, level of work and resources utilized at the country, regional and global levels. If generated by our former means of analyzing SDK data (Excel), the information in this report would have taken well over two weeks to compile. We look forward to working further with Standard Co to develop a means of analyzing our data in real time" - Client

With the data they were collecting, VLPHO needed a report that satisfied 3 primary objectives:

  1. Map building: With geospatial data (from country level all the way down to a specific household), the report would be able to dynamically create maps that help communicate overall progress and activity.
  2. Statistics: Giving a snapshot of where a particular project is is critically important.
    i.e. Participant Reporting Rates for All Countries averaged 33.4% of Total Expected in 2018
  3. Charts / Graphs: How is it easiest to spot a trend? Is it better to showcase data using a tabular set or a bar chart? This is the most classic of visualization examples and anyone who's spent any time in Excel knows this example first hand. But if you're doing dozens of charts, automating that function to ensure you get the right data into the right chart at the right time is a dramatic time saver!

One clear advantage to a real time report is the team at VLPHO was able to quickly determine a challenge area that they did not anticipate: transportation. In the past, this could have taken weeks or months to determine. Now they can see it immediately as data is submitted. They can take corrective action or reach out to the field to coordinate transportation immediately.

All in all, VLPHO has been able to automate their charts, graphs, maps and statistics for this project, allowing decision-makers to visualize change in real time. Insights like those showcased above — specifically transportation deficits — could've been overlooked, lost in a sea of Excel spreadsheets, or never even prioritized to begin with had the leaders at VLPHO not employed SDK:Analyze.

As global health organizations continue to adopt digital tools, their need for data analysis will continue to grow from simply charting & noting statistics to actually making decisions with real time information.

Are you ready to analyze your data in real time? Schedule a free DEMO today and we'll show you how your organization can continue transforming lives with SDK:Analyze!