ODK, Tableau, PowerBi and OpenStreetMaps for Integrated Data Collection, Visualization and Mapping

Lecture Series  2019-12-16 12:00 a.m.    2019-12-27 12:00 a.m.

Course Name: ODK, Tableau, PowerBi and OpenStreetMaps for Integrated Data Collection, Visualization and Mapping

Venue: Tech for Development Training Center, Nairobi, Kenya

Event Date: 16th to 27th December 2019

Course Fee: KES 150,000 OR USD 2,200

Registration: Register online

Tech For Development-T4D would like to invite you to a high impact Training Course in ODK, Tableau, PowerBi and OpenStreetMaps for Integrated Data Collection, Visualization and Mapping to be held in Nairobi, Kenya from 16th to 27th December 2019.

Why T4D?

We are an international training, capacity building and tech solutions organization that offers tech solutions, scheduled and tailor made training and capacity building solutions to individuals and development agencies in Africa and around the world.

We provide our training programs with a capacity-building goal, so as to ensure that, our training programs contribute to sustainable change.


ODK or Open Data Kit is a set of free and open source tools that are used for field data collection using android mobile phones (Devices) and allows data submission to an online or cloud server. The ODK – Open Data Kit ecosystem includes the following components: ODK Collect, ODK Build, XLSForm, ODK Aggregate and ODK Manage as the major components. Other tools in the ODK ecosystem include ODK Briefcase, ODK Aggregate VM, ODK XLSForm Converter, ODK Validate, GEOODK, ODK Scanner, ODK Printers and the ODK Sensor Framework.

Data collection has always been an integral part of development work. In the past, this task was performed with paper and pen which made it prone to error, difficult to conduct on a large scale, and high in transaction costs.

Mobile data collection (MDC) tools and technologies such as mobile devices and software such as Open Data Kit (ODK) that allow users to create surveys, collect, manage and upload data to storage facilities in real-time, have reduced the conventional challenges associated with remote data collection.

Open data kit, commonly referred to as ODK is a set of popular free and open source tools that allow us to collect data using mobile devices.

If you have always wanted to learn how to collect, manage and analyze data using mobile devices, this training course is for you.

This course is suitable for people working in:

Impact Evaluation, Monitoring and Evaluation, Academic Research, Market Research, Field Research, Agriculture, Health, Education, WASH, Handicapped, Human rights, Emergencies/disasters, Advocacy, Education, Environment, Small business development, Community development, Rural development, Women, Youth, Population, Rehabilitation, Culture, Capacity Building, Appropriate technology, Income, generation, Private sector, Refugees/displaced.

Who should attend

This training course is suitable for anyone who is interested in learning how to collect and manage project data using mobile devices and Open Data Kit – ODK tools.


  • Proficient in English and have an understanding of basic ICT concepts.
  • Prior knowledge in ODK is essential


10 Days

Course Objectives

The course will introduce participants to tools and techniques to gather data for project/programme outcomes to stakeholders using innovative Mobile data collection tools such as ODK and other implementations of the ODK technologies.

At the end of the course, you will be able to design a mobile data collection, analysis and reporting platform using ODK.

Topics to be covered

  • ODK Collect
  • ODK Build
  • ODK aggregate installation on a Virtual Private Server (VPS)
  • Analyze and Export Data in Aggregate
  • ODK Central
  • ODK Manage
  • Importing survey data into statistical applications
  • Data analysis in Excel
  • Data Visualization using Tableau
  • Data Visualization usingPower Bi
  • Exporting GPS data for Mapping/Visualizing
  • OpenStreetMap

Module I

Introduction to the course

  • ICT refresher
  • Mobile data collection systems architecture.
  • Mobile based data collection tools, techniques and platforms
  • ODK ecosystem
  • ODK XLSForm syntax for survey authoring

Connecting ODK Collect to the Server

  • Connecting to your own Aggregate Server
  • Connecting to a Google Drive Account

Collect Menus, Settings and Security Explained

  • Main Menu
  • General Settings
  • Admin Settings

Module II

Using Offline Maps

  • Offline Maps Overview
  • Getting Map Tile Sets
  • Transferring offline tilesets to devices
  • Selecting offline tilesets

Advanced Use and Best Practices

  • Android Debug Bridge with Collect
  • Improving Location Performance
  • Projecting ODK to another Screen

Module III

ODK Aggregate Installation

  • Installation on Digital Ocean(Recommended)
  • Installation on Tomcat
  • Installation on Amazon Web Services (AWS)
  • Installation on Google Cloud
  • Installation on Microsoft Azure
  • Installation a Virtual Machine

Backing Up ODK Aggregate

  • Backup Forms and Restore them
  • PostgreSQL Backup and Restore
  • MySQL Backup and Restore

Data Submissions in Aggregate

  • Filtering Submissions
  • Visualizing Submissions
  • Exporting Submissions
  • Publishing Submissions
  • Using Google Earth to visualize geographic data

Administering ODK Aggregate

  • Permissions Explained
  • Preferences Explained (Google APIs and Enketo Configuration)

Module IV

ODK Briefcase

  • Pull and push forms from ODK Servers
  • Export Data from forms
  • Decrypt encrypted forms
  • Backup forms
  • Working both with command line and offline

ODK Central

  • Using the Sandbox
  • Installing ODK Central on Digital Ocean
  • Configuring DKIM
  • Using custom mail server
  • Using custom SSL Certificate
  • Command Line Tools
  • User accounts and management
  • Role-based user permissioning
  • Organize users, permissions, and forms
  • Form and submission upload and management
  • Automatic, encrypted off-site data backups to Google Drive
  • REST API for integration and extensibility

Module V

Form Buiding

XLS Form

  • XLSForm Online
  • XLSForm Offline
  • pyxform

Form Operators and Functions

  • Operators
  • Functions

Logging Enumerator Behaviour

Launching External Apps

Module VI

Data visualization using Tableau

  • Connecting to data
  • Visual Analytics
  • Dashboards and Stories
  • Mappings and Scatter Plots
  • Calculations
  • Understanding Aggregation, Granularity, and Filters
  • Joining and Blending Data

Integrating ODK Aggregate to Power Bi

  • Interactive Visualizations
  • Creating Dashboards
  • Creating Reports

OpenStreetMap (OSM)

  • OpenStreetMap Interface
  • Search and Direction
  • Toolbar
  • Map Key and Map Share 
  • Map Note and Query Feature
  • OSM Basemap and Plugins
  • QGIS with OpenStreetMap
  • OSM Map Download for a Particular Area
  • Exporting OSM File to a Shapefile
  • OpenStreetMap and Web Mapping


The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.


Upon successful completion of this training, participants will be issued with a certificate of participation.

Training venue

The training is residential and will be held at T4D Training Centre in Westlands Nairobi, Kenya. The course fees cover the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

Tailor- made

We can also tailor-make our courses for you. This way, you/your organization will benefit by:

  • Using own tools during the training
  • Being able to choose areas of interest you wish the trainer to put more emphasis on
  • Taking the course in-house or at a venue of choice
  • Cutting on the cost of transport and accommodation

For further inquiries, please contact us on details below: 

Email: outreach@t4d.co.ke

Mobile: +254 (0) 729166479


Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: outreach@t4d.co.ke

Mobile Number: +254 706909947

Training fee

The course fee is KES 150,000.00 or USD 2,200.00 exclusive of VAT. The course fees covers the course tuition, training materials, two (2) break refreshments, lunch and study visits. Participants will cater for their travel and accommodation costs.


Payment should be transferred to Tech For Development - T4D account through bank on or before the course starting date.

Send proof of payment to outreach@t4d.co.ke

Cancellation policy

  1. Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.
  2. Participants may cancel attendance 14 days or more prior to the training commencement date.
  3. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met.


Kindly visit this link to see video and photo testimonials of our previous training events.  


Need more information? Kindly visit this link to see answers to frequently asked questions.

Contact information

Tel: +254 706909947
Email: outreach@t4d.co.ke
Website: www.t4d.co.ke

Kind regards.

Kelvin K. Mwangi
Customer Relationship Officer,
Tech For Development.
Innovation for impact




Tech For Development Training Center

Contact Info