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.

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.

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

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

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.

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.

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.

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.

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

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. From the Submission Log page, follow these steps:

  1. Click on the Errors Tab,
  2. Select the Submissions you want to delete,
  3. Select “Delete” from the Actions dropdown menu.

error-submission

Yes. Deleted entries are still present in the Deleted Submissions page. You cannot have them back in your Submissions log but you can re-enter them:

  • Re-make the submission using the Web form. You can even select the Data Sender name.
  • If you have a very big Questionnaire, it would take time to enter manually. In that case, you can export the Deleted submission(s) to Excel and re-import using the “Import Submissions” function.

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

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

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.

No. As DataWinners use a flat database, this not yet possible. But below a few workarounds to help you with your data analysis:

  1. You can merge your data in Excel using the unique IDs as an identifier for all your Questionnaires.
  2. If you use Smartphone to collect data, you create one unique Questionnaire combining your different Questionnaires, using XLSform. You can have multiple groups for your different Questionnaires. The Data Senders can skip the sections they do not have to fill out.

With DataWinners, the collected data inside a repeat is always displayed in different sheets when exporting data. You can group your data in Excel once exported.