Fundamentals of Data Analytics for Social Impact Programs

Develop your career as a data analyst for social impact programs. You will learn how to develop mobile data collection tools and collect data using KoboToolbox, data cleaning, and data analysis using Microsoft Excel and IBM SPSS

15,000+ already enrolled

About this course

What if you could learn all the skills you need to start your career as a data analyst for social impact/humanitarian programs?

Now you can! This course introduces you to all the data analytics processes from data collection all the way to data analysis using the most popular tools: KoBo Toolbox, Excel and SPSS. The course is packed easy-to-follow video lessons, hands-on activities, and quizzes to cement the concepts in. To top it all, it’s FREE!

What you’ll learn

The course is divided into 5 module:

  • The introduction module introduces you to the concept of data analytics. You will learn the definition and what’s involved in data analytics; the different types and processes in data analytics
  • In module 2, you will learn how to develop mobile data collection tools using one of the most popular and free platform, KoboToolbox. You will develop a form, deploy it on mobile devices, collect data, send the data to the server and download it to be used for analysis
  • Then, you will pick off from the data you have collected to clean it in Excel readying it for analyses
  • In module 4, you will learn Microsoft Excel’s powerful data analytics features. In particular, you will learn how to use Excel tables to sort, filter and summarize data. Then, you will learn ow to use pivot tables and pivot chats to analyze and visualize data
  • Finally in module 5, you will learn how to use SPSS for data analyses. You will start by importing data from Excel and editing variables. Then you will move on to summarize the data using frequencies and summary statistics. To finish it off, you will learn how to explore relationships between variables. Throughout the lessons, you will build charts that go together with the analyses mentioned.

Course content

Module 1: Introduction
  1. Course overview
  2. What is data analytics?
  3. Types of data analytics
  4. Data analytics processes
  5. Summary
  6. Quiz
Module 2: Developing mobile data collection tools using Kobo Toolbox
  1. Introduction to mobile data collection
  2. Getting started with KoBo Toolbox
  3. Creating a project and adding questions
  4. Grouping questions
  5. Rosters and question referencing
  6. Calculated fields
  7. Validation logic
  8. Skip logic
  9. GPS
  10. Deploying the form on mobile devices
  11. Data entry and uploading
  12. Accessing and downloading the data
  13. Summary
  14. Quiz
Module 3: Data cleaning using Excel
  1. Introduction to data cleaning
  2. Data cleaning in Excel
  3. Summary
  4. Quiz
Module 4: Data visualization and analysis using Excel
  1. Introduction to Excel for Data Analysis and Visualization
  2. Data amanagement in Excel using tables
  3. Data analysis using pivot tables
  4. Data visualization using pivot charts
  5. Summary 
  6. Quiz
Module 5: Data Analysis using SPSS
  1. Introduction to SPSS for data analysis
  2. Importing data and editing variables
  3. Univariate anaysis for categorical variables
  4. Univariate analysis for continuous variables
  5. Exploring relationships between scale and categorical variables
  6. Exploring relationships between 2 categorical variables
  7. Exploring relationships between 2 continuous variables
  8. Summary
  9. Quiz


Alexander Mtembenuzeni

Data Analyst, Instructor

Alexander has over 8 years experience training social impact organizations in data analytics. He also has consulted for small and big organizations alike – developing data collection tools, building M and E systems and analyzing data. He is a 4.5/5-rated instructor on where he has several courses with a combined over 5,000 students. He also loves blogging and creating tutorial videos for the Data for Development YouTube channel.

Student feedback

Frequently asked questions 

Does this course offer a certificate?

Yes. You will automatically get a certificate of completion as soon as you complete the course and pass the graded quizzes and project

How long will it take for me to complete the course?

We recommend investing 2 hours of learning per day. With that time investment, you will finish the course including the hands-on practices in 7 days.

Which days and times does the course run?

This course is self paced. Once you enroll, you can go through the learning content at any time, and at your own pace!

Will my access to the course expire?

No. Once you enroll, you have lifetime access to the course material.

Instant access

Start as soon as you enroll

Approximately 7 days to complete

Suggested 2 hours per day


Enroll to get this and all our FREE courses

Beginner level