Learn how to edit, analyze, and export the data you’ve received from your Data Sender with DataWinners. View your Data Senders and Identification Numbers on a map. Delete or modify submissions made in error.

Guides and Tutorials

Analyze Data

With DataWinners, you have an unlimited amount of space to store your data.

Your data is stored in DataWinners server throughout your DataWinners subscription. But you can export your data at anytime and store it where you choose.

No. You can’t undelete, but you can resubmit the data yourself. Go to the Data tab, then click on Web Submission and resubmit the data yourself.

You can sort your data by data sender or by submission date. You also have the search option allowing you to display only the data you want.
You can do all these analysis in the Analysis page and the Submission Log page.

To delete a data record, click on the “Submission Log” page for the Questionnaire, select the data record you wish to delete by clicking on the corresponding box in the left-most column, then select “Delete” from the Actions drop down menu.

Yes. DataWinners’ Analysis pages can perform simple analysis of collected data, including mapping, charting and graphing functions.

Yes. To edit a data record, click on the “Submission Log” page for the Questionnaire, select the data record you wish to edit by clicking on the corresponding box in the left-most column, and select “Edit” from the Actions drop down menu. Make all the necessary changes and click “Save changes.”

Please watch our video tutorial: How to Edit Submissions.

Submission Log error

Click to enlarge

With DataWinners, you can view your collected data in table formats, pie and bar charts. Data can be filtered by submission date, by data sender, by case and you can even make a search for keyword.

Analysis Chart

Click to enlarge

Within your DataWinners account itself, you can have very basic charts.

If you want to generate custom reports, we’ll need to develop a customized application for you. If you’re interested, the costs will depend on your specific needs.

Analysis charts

Click to enlarge

This not yet possible but you can use the below workarounds:

  1. You can merge data from the Questionnaires in Excel using the unique IDs as an identifier. (example: teacher’s unique ID)
  2. If you plan to use Smartphone to collect data, you can create your questionnaires with XLSForm and merge all your Questionnaires in one Questionnaire. You can use teachers ID as an identifier, then have multiple groups for your different questionnaires. The Data Senders can skip the sections they do not have to fill out.

On any map, the pins represent either the registered Data Senders or the registered Identification Numbers. You can choose to display only Data Senders or only Identification Numbers

Overview

Click to enlarge

Data can be exported to Excel in one click.

DataWinners has also an API functionality allowing users to push the data collected with DataWinners to a third party application, automatically.

 

  1. Export your data to Excel from Analysis or Submission Log page
  2. Open SPSS Analytics
  3. Click on File > Open > Data > Choose Excel in the file dropdown list
  4. Select the Excel file containing your data > Paste
  5. Choose the sheet in the dropdown list > Click on OK
  6. Register the syntax so you won’t have to redo these steps for your future data.

No. Data can be exported to Excel only.

If you have a very long Questionnaire of more than 250 questions, note that the maximum number of Submissions which can exported at a time is 10,000 Submissions.

Filter your data date for example and export your data per wave.

Yes, you can use our API to extract the data automatically from your DataWinners account to your own server. To learn more, please read our API Documentation.

 

Our API can be used to fetch data from the DataWinners’ database to your server. Fetching data to an external database is not yet available.

  • Submission Feed : app.datawinners.com/feeds/{form_code}?start_date={date}&end_date={date}
    *form_code = Questionnaire code
  • Identification Number API:
    https://app.datawinners.com/api/get_for_form/UID/
    * UID = The Identification Number Type.

Data Sender API:
https://app.datawinners.com/api/get_for_form/reg/

You can use our API to do so. To know more about our API, read the following document Submission Feed and Send SMS in our Website.

DataWinners has a very good API allowing you to link it to any external application. Data can be even pushed to external databases such as DHIS2. To learn more, please read our API Documentation.

A Duplicate is a submission containing the same data as another submission within a predefined period. It can be:

  • Submissions with the exact same answers for each question
  • Submissions with the exact same Identification Number
  • Submissions made by the same Data Sender

Only successful Submissions are analyzed for duplicates.

A Duplicate

Click here to enlarge

 

To review possible duplicate Submissions, please follow the steps below:

  1. Choose the period using “Submission Date” filter
  2. Choose what case of duplicate Submissions you are looking for – use the drop down “Show Duplicates For”:
    • Submissions with the exact same answers for each question
    • Submissions with the exact same Identification Number
    • Submissions made by the same Data Sender

Note: Nested questions in Advanced Questionnaires are not evaluated for duplicates in the current version of DataWinners

Duplicate Submissions

Click to enlarge

 

Removing or editing duplicated Submissions will help you to clean up and improve the quality of the collected data.

Yes. To edit a Submission, please follow the steps below:

  1. Select the Submission you wish to edit by clicking on the corresponding checkbox in the left-most column,
  2. Select “Edit” from the Actions dropdown menu,
  3. Make all necessary changes and click “Save changes.”
Delete or Edit a Submission

Click to enlarge

No. It is not yet possible to view your data on the Smartphone application. You can view your record only from the Web application.

Data Senders must be registered as Users to be able to access the data page. To do so, delete them from the Data Senders list and register them as a User. Then you can link them to the specific Questionnaires you want them to send in data.

Each week for example, the Project Manager can export the basic information, print it out and share with the Data Senders.

All the choices are displayed in a single column, separated by a comma (“,”).

As a workaround, you can split the data in different columns using Excel: Select the cells, go to Data –> Text to columns –> Choose “Delimited” in the pop-up window, then choose a delimiter (a semi-colon or a comma) and your data will be parsed into separate columns.

DataWinners can export up to 4094 at a time.
To avoid problem, you can filter your data — by date for example — and export it in multiple batches.

Please try downloading the file again. The Excel file may be corrupted if the Internet connection is not very good when downloading your data.

The analysis page shows only successful Submissions.

If you cannot find your data in the Analysis page, please go to the Submission Log page. Successful and error Submissions are displayed in this page.

If you cannot see your data in these two pages, please go to the Failed Submissions page. Click on the “Data” button at the top of the page and then on “Failed Submissions.”