Analytics – Data Outputs

Mobenzi Researcher provides 4 data output options: Grid, Export, Map and Charts.

Grid

The Grid view is the default mechanism for displaying submission data when the Analytics screen loads.

Response data can be explored by navigating through each section using the section dropdown or Previous and Next section buttons.

The first section is always metadata. It contains automatically generated/captured fields including:

• Fieldworker Name – this is based on who was assigned the handset from which the submission was uploaded.
• Received Date – this is the date/time at which the submission was received by the system.
• Start Date – this is the date/time (according to the handset) at which the survey was started. Note that if the survey was suspended and resumed later – it is the original start date/time that will be used.
• End Date – this is the date/time (according to the handset) at which the survey was completed.
• Duration – this is the calculated duration (in seconds) that the survey took.
• Device – the make, model and asset code of the device from which the submission was received.
• Language – the language in which the survey was conducted in.
• Modified By – the name of the user who last modified the submission. If no modifications have been made, this will be the fieldworker who uploaded the submission.
• Modified On – the date on which the submission was last modified. If no modifications have been made, this will be the Received Date.
• Latitude & Longitude – the GPS coordinates available at the time the survey was started. Note that the handset polls for GPS location and uses the last known coordinate when a new survey is started. If no location was available at the time the survey was started, a zero is displayed. Note that if the survey was suspended and resumed later – it is the GPS coordinate captured when the survey was first started that will be used.
• Version – the survey version which was used by the fieldworker. If this version is less than the current version of the survey, the fieldworker was using an older version of the survey.

As each section is accessed, the relevant fields contained will be displayed as columns and the submissions matching the filters applied will be shown in the rows below. Fieldworker Name and Received Date are always displayed as the first two columns.

To assist in tracing a submission from one section to the next, click on the submission to highlight it. It will remain highlighted as you move from one section to another.

You can decide which columns to show by clicking “Select Columns”. If you hide a column, it won’t appear in any of the output tabs and will also be excluded from the export.

25 submissions are displayed per page.

An “(R)” is appended to section names which contain repeating data. When a repeating section is loaded into the grid, a new row is shown for each iteration. The “Instance” column indicates the iteration.

Export

Mobenzi Researcher supports 2 data export formats: Comma Separated Variables (CSV) and Excel 2003/2007. Only submissions matching the filters applied will be exported.

The export function has been designed to split questions based on section. This is to facilitate iterative data elements (i.e. where a section’s questions are repeated based on a captured value). By splitting the data into separate sections, each iteration can be shown as a row, one iteration below the other rather than generating a separate column each time a question is repeated.

When exporting data in CSV format, a file will be generated for each section. When exporting in Excel format, a worksheet will be generated for each section. The first 3 columns of each file/worksheet contain key metadata about the submission:

• [Submission Id] – a system generated identifier which is unique to that submission.
• [Fieldworker Name] – the name of the fieldworker who uploaded the submission (based on who was assigned the device at the time).
• [Fieldworker Id] – a system generated identifier which is unique to that fieldworker. Two fieldworkers with the same name will still have unique identifiers.

For repeating sections there are additional relevant columns:

• [Repeats On Question] – the name of the question on which the section repeats. If the section is not repeated, this will be displayed as “N/A”.
• [Repeat Question Value] – the value which was captured for the question on which the section repeats. This is the number of times the section iterated and thus the number of rows which will be generated for that submission in that particular section.
• [Repeating Index] – indicates the iteration number of the row in question. This value is zero-based, i.e. the first iteration is 0, the second is 1 and so on.

Each question is represented as a single column, except for multi-select questions where each option receives a column and a “1″ or “0″ indicates whether the option was selected or not.

In addition to the actual data, each export includes a number of additional files/worksheets:

• The “Submissions” file/worksheet contains a summary of all submissions which are included in the export. Only metadata is included.
• The “Codebook” file/worksheet lists every question used in the survey. Each question receives a unique ID from the system. For select-type questions, each option is also listed along with its associated value.
• For reference purposes, a “Questions” file/worksheet is generated which lists each question contained in the survey, the text displayed and the question type.
• A “Raw Data” file/worksheet is produced which is a “flat” structure, suitable for importing the data into other systems or performing other types of transformations.

Map

A submission result set can also be viewed geographically with each submission plotted on a map as a pin corresponding to the GPS location at which the submission was captured. Please note that only submissions captured on GPS-enabled handsets (where the coordinate was available at the time of conducting the survey) will be plotted.

Clicking on a pin will display a data overlay which includes some system generated information by default such as the date the submission was received and who submitted it. But you can configure the overlay to include other information – in fact any field or question contained in the survey can be displayed.

Charts

Mobenzi Researcher generates charts automatically for numeric and select question types.

For numeric questions, basic statistical figures such as min, max, mean, variance and standard deviation are calculated. The data matching the applied filter is also represented using a histogram.

For single select questions, a bar graph and pie chart are produced. For a multi-select, only a bar graph is displayed.