About This Course
In today's data-driven world, organizations across development, government, health, agriculture, and the private sector depend on accurate, timely, and visually compelling data to guide decisions. Yet many teams operate in silos — field data collectors use paper forms or disconnected mobile apps, analysts work in spreadsheets, and reports are produced without geographic context. This fragmented approach leads to delays, errors, and missed insights.
This 10-day Integrated Data Collection, Visualization and Mapping Training bridges that gap by combining four powerful, industry-leading tools into a single, coherent workflow. Participants begin with Open Data Kit (ODK), mastering the design of smart digital forms for mobile data collection in both connected and offline environments. They then transition to OpenStreetMap (OSM), learning to create, edit, and leverage community-sourced geospatial data to give their datasets geographic meaning. The programme then advances into the world of data visualization, where participants develop professional-grade dashboards and reports using Microsoft Power BI and Tableau — two of the most widely used business intelligence platforms globally.
Through hands-on exercises, real-world datasets, and project-based learning, participants gain practical proficiency rather than theoretical familiarity. By the end of the training, each delegate will have built a complete data pipeline: collecting field data on a mobile device, mapping it spatially, and presenting findings through interactive, publication-ready dashboards. TrainingComplex delivers this programme with experienced facilitators who bring field-tested expertise from development sectors, ensuring the learning is grounded in authentic professional challenges.
Who Should Attend
- Monitoring, Evaluation, Accountability and Learning (MEAL) Officers and Managers
- GIS Analysts and Geospatial Data Specialists
- Data Managers and Database Administrators
- Public Health Officers and Epidemiologists involved in field surveys
- Research Officers and Field Coordinators in NGOs and INGOs
- Government Statisticians and Planning Officers
- Project Managers overseeing data-intensive programmes
- Agricultural Extension Officers and Environmental Field Officers
- ICT Officers supporting field operations and data systems
- Academic Researchers and Postgraduate Students in data-intensive disciplines
Learning Objectives
- Design and deploy mobile data collection forms using ODK Collect and ODK Central, including skip logic, constraints, and multimedia capture
- Manage ODK submissions, aggregate data, and export structured datasets for downstream analysis
- Navigate and contribute to OpenStreetMap, including editing features, tagging, and using JOSM and iD editors
- Conduct field mapping and import GPS traces and field data into OSM and QGIS
- Connect and transform data sources in Microsoft Power BI using Power Query and the data model
- Build interactive Power BI dashboards with slicers, drill-throughs, map visuals, and DAX measures
- Connect Tableau to multiple data sources and perform data preparation within Tableau Prep
- Design advanced Tableau dashboards using calculated fields, parameters, filters, and geographic visualizations
- Integrate ODK-collected data with Power BI and Tableau for live or scheduled reporting
- Apply cartographic principles to produce clear, informative maps from field survey data
- Interpret and present data narratives effectively to technical and non-technical audiences
- Apply best practices in data quality, ethics, and security across the entire data collection and visualization pipeline
Course Modules
Module 1: Introduction to Digital Data Ecosystems and the Integrated Workflow
- Understanding the end-to-end data pipeline: collection, storage, analysis, and visualization
- Overview of ODK, OpenStreetMap, Power BI, and Tableau and their roles in the workflow
- Data quality fundamentals: accuracy, completeness, timeliness, and consistency
- Setting up working environments: installing ODK Collect, JOSM, Power BI Desktop, and Tableau Public
- Mapping data flows between tools: how ODK exports feed into Power BI and Tableau, and how OSM layers contextualize field data
- Common failure points in integrated pipelines: format mismatches, projection errors, and refresh bottlenecks
Module 2: Designing Smart ODK Forms with XLSForm
- Introduction to XLSForm structure: survey, choices, and settings sheets
- Question types: text, integer, select_one, select_multiple, geopoint, and image
- Implementing skip logic, relevance conditions, and input constraints
- Form validation, required fields, and field labels for multilingual deployments
- Using repeat groups to capture nested or roster-based data, such as household members or repeated plot observations
- Testing and debugging forms with ODK Validate and the Enketo web previewer before field deployment
Module 3: Deploying and Managing ODK Central
- Setting up projects and users in ODK Central
- Publishing forms and distributing them to field teams via QR codes
- Monitoring submission status and reviewing incoming data in the ODK Central interface
- Exporting data in CSV, GeoJSON, and OData formats for analysis
- Configuring role-based access control in ODK Central to manage permissions for data collectors, project managers, and administrators
- Archiving completed projects and managing form versioning to maintain a clean audit trail across data collection cycles
Module 4: Field Data Collection Best Practices and GPS Mapping
- Configuring ODK Collect settings for offline use and GPS accuracy thresholds
- Conducting structured field interviews and observation-based data entry
- Capturing geopoints, geotrace, and geoshape data for spatial analysis
- Data security during field collection: encryption, access controls, and device management
- Developing field team protocols: enumeration area assignment, daily data submission schedules, and back-check procedures
- Troubleshooting common field issues: form sync failures, low GPS signal in dense environments, and handling partial submissions
Module 5: Introduction to OpenStreetMap and Community Mapping
- Understanding OSM data structure: nodes, ways, relations, and tags
- Navigating the OSM website and using the iD editor for basic map editing
- Contributing to OSM: adding roads, buildings, health facilities, and points of interest
- Using the HOT Tasking Manager for coordinated humanitarian mapping campaigns
- Applying OSM tagging conventions and consulting the OSM Wiki to ensure attribute consistency across contributors
- Validating peer contributions in the Tasking Manager: reviewing geometry quality, tag completeness, and flagging errors for correction
Module 6: Advanced OSM Editing and Geospatial Data Integration
- Using JOSM for offline editing, batch uploads, and quality validation
- Downloading OSM data with Overpass Turbo and converting to shapefiles
- Overlaying ODK-collected GPS data on OSM base maps using QGIS
- Exporting and styling map layers for use in Power BI and Tableau
- Building Overpass API queries to extract targeted feature sets, such as all water points or health facilities within a defined boundary
- Resolving common spatial data conflicts: coordinate reference system mismatches, duplicate features, and topology errors between ODK and OSM datasets
Module 7: Getting Started with Microsoft Power BI
- Power BI Desktop interface: report, data, and model views
- Connecting to data sources: Excel, CSV, ODK OData feeds, and web APIs
- Data transformation with Power Query: cleaning, reshaping, and merging tables
- Building the data model: relationships, cardinality, and cross-filter direction
- Handling data type conversions and locale-specific formatting issues in Power Query to ensure numeric and date fields parse correctly from ODK exports
- Using Power BI's field parameters and calculation groups to make reports flexible and reusable across multiple form versions or project cycles
Module 8: Building Interactive Power BI Dashboards
- Creating core visuals: bar charts, line graphs, tables, cards, and map visuals
- Using slicers, filters, and drill-through pages for interactive exploration
- Writing DAX measures: SUM, CALCULATE, DIVIDE, time intelligence functions
- Publishing reports to Power BI Service and configuring scheduled data refresh
- Designing mobile-optimized report layouts in Power BI Desktop for field supervisors accessing dashboards on smartphones and tablets
- Implementing row-level security in Power BI Service to restrict data visibility by region, project, or user role
Module 9: Getting Started with Tableau and Data Preparation
- Tableau Desktop interface: data source pane, sheet, dashboard, and story views
- Connecting Tableau to CSV, Excel, and spatial files from ODK and OSM exports
- Using Tableau Prep Builder for data cleaning, pivoting, and joining datasets
- Understanding dimensions, measures, and the Tableau data model
- Managing data extract versus live connection trade-offs when working with large ODK submission files or frequently updated OSM shapefiles
- Using Tableau's metadata editor to rename fields, assign default aggregations, and add descriptions that standardize how data is interpreted across multiple workbooks
Module 10: Advanced Tableau Visualizations and Geographic Mapping
- Building calculated fields, parameters, and table calculations in Tableau
- Designing geographic visualizations: filled maps, symbol maps, and density maps
- Using custom shapefiles and WMS map layers from OSM in Tableau
- Building interactive dashboards with actions, filters, and device-specific layouts
- Creating dual-axis map visualizations to simultaneously display ODK point data and OSM polygon layers, such as health facility locations within administrative boundaries
- Optimizing dashboard performance for large spatial datasets: reducing mark counts, aggregating at appropriate geographic levels, and using extract filters to limit scope
Module 11: Integrating ODK Data with Power BI and Tableau for Live Reporting
- Connecting Power BI to ODK Central via OData for near-real-time dashboards
- Automating data refresh pipelines using Power Automate and scheduled queries
- Linking Tableau to live and extracted ODK data sources
- Managing version control and form updates without breaking existing dashboards
- Handling schema changes gracefully in both Power BI and Tableau when new questions are added to ODK forms mid-collection, using defensive transformation steps and null-handling logic
- Documenting pipeline architecture with data flow diagrams and refresh logs to support handover, troubleshooting, and organizational knowledge retention
Module 12: Data Storytelling, Dashboard Design Principles, and Reporting Ethics
- Principles of effective data visualization: hierarchy, contrast, alignment, and color
- Crafting a data narrative: framing the problem, showing evidence, and calling to action
- Adapting dashboards for different audiences: donors, field staff, and government partners
- Data ethics: anonymization, informed consent, and responsible use of geographic data
- Avoiding common misrepresentation pitfalls: truncated axes, misleading map projections, cherry-picked date ranges, and conflation of correlation with causation
- Accessibility standards for dashboards: ensuring sufficient color contrast, providing text alternatives for chart visuals, and designing for colorblind-safe palettes
Module 13: Capstone Project: End-to-End Data Pipeline Presentation
- Finalizing ODK forms, collected data, and OSM base maps for the capstone dataset
- Building the integrated Power BI or Tableau dashboard with map and chart components
- Presenting the data pipeline and key findings to the group for peer and facilitator feedback
- Reflection on lessons learned, organizational application planning, and next steps for continued learning
- Documenting the full capstone pipeline in a one-page technical brief covering data sources, transformation steps, tool connections, and design decisions
- Developing a post-training implementation roadmap: identifying priority use cases, data governance responsibilities, and skill-building milestones for the participants' own organizations
Requirements & Prerequisites
Participants should have basic computer literacy and be comfortable working with spreadsheets such as Microsoft Excel or Google Sheets. Prior experience in data collection, monitoring and evaluation, or field research is beneficial and will help contextualize the tools covered. No prior programming knowledge is required, though familiarity with basic data concepts such as rows, columns, and data types will be an advantage.
Training Methodology
- Hands-on ODK form building labs where participants design, test, and deploy real forms on Android devices or emulators
- Guided field mapping exercises using OSM iD editor and JOSM, simulating a real community mapping scenario
- Step-by-step Power BI desktop walkthroughs using authentic development-sector datasets, including survey and health data
- Tableau guided projects where participants build dashboards from raw ODK export files
- Peer critique sessions where participants review each other's dashboards against data communication best practices
- Case study analysis of how leading NGOs and government agencies use integrated data systems in East and West Africa
- Integrated capstone project in which each participant builds a complete data pipeline from ODK form design through to a published Power BI or Tableau dashboard with map layers
- Live Q&A and troubleshooting clinics for tool-specific challenges encountered during practice
- Group mapping sprints using OpenStreetMap tasking manager on a shared area of interest
- Take-home reference guides, checklists, and templates for ODK form design, DAX formulas, and Tableau calculated fields
Organisational Benefits
- Reduced reliance on paper-based data collection, lowering error rates and data entry costs
- Faster turnaround from field data collection to actionable reports and dashboards
- Improved geographic targeting of programmes through integrated mapping capabilities
- Standardized, replicable data collection workflows that improve consistency across field teams
- Enhanced decision-making through visually compelling, real-time dashboards in Power BI and Tableau
- Stronger donor reporting capacity with professional-grade data products
- Increased organizational data literacy and internal capacity to manage digital data systems
- Ability to layer field survey data with publicly available OSM geospatial data for richer analysis
- Reduced dependency on expensive external consultants for data collection system design and visualization
- A workforce equipped to adopt and champion emerging digital data tools across the organization
Where Is Integrated Data Collection, Visualization and Mapping Training (ODK, Tableau, Power BI and OpenStreetMap) Training Offered?
This course runs in-person across: Mombasa, Dar es Salaam, Lagos, Addis Ababa, Nakuru, Kisumu, Pretoria, Arusha, Naivasha, Kampala, Johannesburg, Accra, Dubai, Abuja, Nairobi, Zanzibar, Riyadh, Cape Town, Kigali, plus Live Virtual (online) cohorts. Browse live dates for your city below.
Upcoming Schedules
| Location | Format | Dates | Price |
|---|
| Mombasa, Kenya |
In-Person |
5 Oct 2026 – 16 Oct 2026 |
KES 230,000 |
| Dar es Salaam, Tanzania |
In-Person |
5 Oct 2026 – 16 Oct 2026 |
USD 4,600 |
| Lagos, Nigeria |
In-Person |
5 Oct 2026 – 16 Oct 2026 |
USD 5,000 |
| Addis Ababa, Ethiopia |
In-Person |
12 Oct 2026 – 23 Oct 2026 |
USD 4,800 |
| Nakuru, Kenya |
In-Person |
12 Oct 2026 – 23 Oct 2026 |
KES 230,000 |
| Kisumu, Kenya |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
KES 240,000 |
| Pretoria, South Africa |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
USD 6,600 |
| Arusha, Tanzania |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
USD 4,200 |
| Naivasha, Kenya |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
KES 240,000 |
| Kampala, Uganda |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
USD 3,800 |
| Johannesburg, South Africa |
In-Person |
19 Oct 2026 – 30 Oct 2026 |
USD 7,000 |
| Accra, Ghana |
In-Person |
19 Oct 2026 – 28 Oct 2026 |
USD 7,600 |
| Live Virtual |
Online |
19 Oct 2026 – 28 Oct 2026 |
KES 160,000 |
| Live Virtual |
Online |
24 Oct 2026 – 13 Dec 2026 |
KES 160,000 |
| Dubai, United Arab Emirates |
In-Person |
26 Oct 2026 – 4 Nov 2026 |
USD 8,200 |
+234 more dates — view live schedule →
Frequently Asked Questions
Do I need prior experience with any of these tools to attend?
No prior experience with ODK, Tableau, Power BI, or OpenStreetMap is required. Participants should have basic computer literacy and comfort with spreadsheets. The course is structured to build skills progressively from fundamentals to advanced application.
Will I receive a certificate upon completion?
Yes. Participants who attend and complete the full 10-day programme will receive a TrainingComplex Certificate of Completion in Integrated Data Collection, Visualization and Mapping. The certificate is recognized by many employers in the development, public health, and research sectors.
What software and equipment do I need to bring?
Participants should bring a laptop with at least 8GB of RAM running Windows 10 or later. Required software — including ODK Collect (via Android device or emulator), JOSM, Power BI Desktop, and Tableau Public — will be installed during the first session, and installation guides are shared in advance. An Android smartphone or tablet is useful but not mandatory.
Is this course suitable for someone working in humanitarian or development organizations?
Absolutely. The course is specifically designed with development, humanitarian, public health, and government professionals in mind. All datasets, case studies, and exercises are drawn from real-world field scenarios in Sub-Saharan Africa and similar contexts, making the learning immediately applicable.
Can my organization send multiple staff members and receive group pricing?
Yes. TrainingComplex offers group enrollment discounts for organizations sending three or more participants to the same cohort. Please contact our training coordinators directly to discuss tailored group rates, in-house delivery options, and customized content to match your organizational data systems.
