...
Every CommCare project will eventually need to interpret the Case and Form data collected by mobile workers. The design of a data pipeline involves two fundamental questions: the method of export (e.g., basic export interface) and the automation of analysis (e.g., VBA queries). Both of these aspects should be regularly reassessed in projects planning large-scale data analysis (exporting 50,000+ rows at a time).
Method of Export | Scale (rows) | Requirements |
|---|---|---|
Data Exports | 0 - 50,000 | Excel |
Daily Saved Exports | 0 - 100,000 | Excel |
OData Feeds | 0 - 500,000 | PowerBI/Tableau Desktop |
CommCare Data Export Tool | 0 - 1,000,000+ | Excel, Python, programming knowledge, database knowledge, server setup |
CommCare Sync | 0 - 1,000,000+ | Excel, Python, programming knowledge, database knowledge, server setup |
| Info |
|---|
Data Exports |
The basic data exports interface in CommCare allows exporting up to 50,000 rows of case and form data submitted by mobile workers. CommCare offers robust data exporting features with the ability to customise exports as needed.
...