About SWA Data Analysis
A data analysis tool built for NGOs, researchers and small teams.
What it does
Upload a CSV, Excel or JSON file (including KoboToolbox and ODK exports). The tool cleans the data, sets aside rows that cannot be trusted, and builds pivot tables, charts and programme indicators broken down by sex, age group, location and time. You download an Excel report, an HTML report, the cleaned data and the list of rejected rows.
Why you can trust the numbers
- Every pivot table and indicator is calculated twice by independent methods. If they disagree, the report is marked as failed.
- Rows are never silently changed or dropped: problem rows are listed with the reason.
- Rows read always equal rows analysed plus rows set aside plus blank rows.
- Excel results are live formulas, so Excel recalculates them for itself.
What it does not do
It reports counts, sums, averages and percentages. It does not run significance tests, apply survey weights or correct for sampling. Results are only as representative as the data you upload.
Who is behind it
SWA Data Analysis is built and run by swasamson.site.