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: 16th to 27th March 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 16th to 27th March 2020.
Why train with us?
- Our focus is on helping your organization achieve workplace performance improvements.
- Our rigorous pre-training evaluation ensures a robust training model that aligns training with the culture, strategic direction, and internal resources of your organization.
- Our extensive experience, expertise and client base - We have conducted training to over 10,000 attendees from 20 countries around the world.
- We boast of staff and associate trainers/facilitators with a combined 400+ years of experience training and facilitating in fields of technology, research, software development, ICT4D, GIS, M&E and soft skills.
- We are not independent contractors; all our people work as part of your Project Team.
- Attendees benefit from our post training support and mentorship provided to each attendee for 12 months after completion of any training course.
- Small class sizes - No more than 15 people to ensure you get the most from our trainers.
Course Description
Data collection and management has always been an integral part of development work. This course covers the whole ecosystem around data from data collection, visualization and mapping.
ODK or Open Data Kit
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.
Tableau
Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data into the very easily understandable format. Data analysis is very fast with Tableau and the visualizations created are in the form of dashboards and worksheets. The great thing about Tableau software is that it doesn't require any technical or any kind of programming skills to operate.
Power BI
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. We all live in a data culture where business decisions should be based on facts, not opinions. Power BI can help make your job easier and more effective at the same time by converting all that data into charts and graphs to help you visualize your data in meaningful ways.
OpenStreetMap (OSM)
OpenStreetMap (OSM) is a collaborative project to create a free editable map and a free geographic database of the world. Its aim is to eventually have a record of every single geographic feature on the planet. While it started with mapping streets, it has gone far beyond that to include physical geography features such as footpaths, buildings, waterways, pipelines, woodland, beaches e.t.c and administrative boundaries. OpenStreetMap's data is free to use by anyone, for any purpose. It is released under a license that allows you to copy, change, and redistribute the data.
This is the most comprehensive course as it cuts across all angles from Data Collection, Visualization to Mapping therefore if you looking to learn how to collect, visualize, analyze and map data, 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: [email protected]
Mobile: +254 (0) 729166479
Accommodation
Accommodation is arranged upon request. For reservations contact the Training Officer.
Email: [email protected]
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 [email protected]
Testimonials
Kindly visit this link to see video and photo testimonials of our previous training events.
FAQS
Need more information? Visit this link to see answers to frequently asked questions.
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.
- Participants may cancel attendance 14 days or more prior to the training commencement date.
- 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: [email protected]
Website: www.t4d.co.ke
Kind regards.
Lennox I. Mucheni
Customer Relationship Officer,
Tech For Development.
Innovation for impact
MEAL Lead, Social Behavior change evaluator, Strategic planning Specialist passionate about vulnerable people. Keen on sustainable organic household gardening.
5 年Am interested in this training.