Training Course in ODK, Tableau, PowerBi and OpenStreetMaps for Integrated Data Collection, Visualization and Mapping
Venue: Tech for Development Training Center, Nairobi, Kenya
Event Date: 17th to 28th February 2020
Course Fee: KES 150,000 OR USD 2,200
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 17th to 28th February 2020.
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.
Course Description
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.
Requirements
- Proficient in English and have an understanding of basic ICT concepts.
- Prior knowledge in ODK is essential
Duration
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 using Power 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
Methodology
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.
Accreditation
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
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
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
Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.
1. Participants may cancel attendance 14 days or more prior to the training commencement date.
2. 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
Contact information
Tel: +254 706909947
Email: outreach@t4d.co.ke
Website: www.t4d.co.ke
Kind regards.
Lennox I. Mucheni
Customer Relationship Officer,
Tech For Development.
Innovation for impact