Explore free courses
Results: 2 courses
Data and Analytics
Data Analysis with Excel, SQL and Power BI
A compact, hands-on course in the three tools employers list most for data analyst jobs. In Excel you'll use formulas, XLOOKUP, PivotTables and data cleaning. In SQL you'll query real tables with SELECT, WHERE, GROUP BY, HAVING, JOINs, CASE, subqueries, CTEs and window functions, writing and checking every query on your phone in the course's built-in SQL practice. In Power BI you'll prepare data with Power Query, build a star-schema model, write DAX measures and design a dashboard. The course follows the skills measured by the Microsoft PL-300 exam (prepare, model, visualise and analyse, manage and secure) and uses African business examples: pharmacy sales, mobile money agents, school records. Video lessons come from Alex The Analyst's popular free courses. Finish with a full analysis project on a real-style dataset, ending in a dashboard and a one-page insights memo.
Data and Analytics
Digital Data Collection, M&E and Impact Reporting
A compact, practical course for programme officers, field enumerators, NGO staff and young professionals entering monitoring and evaluation, one of the most in-demand skills in Africa's development sector. Learn the difference between monitoring and evaluation and the role of accountability and learning; build a theory of change and a logframe with SMART indicators, baselines and targets; plan M&E with the right methods, sample sizes and data-quality checks; build digital forms in KoboToolbox with skip logic and validation and collect data on Android phones; then analyse indicators, disaggregate by sex and location, and report results honestly. The course follows the PM4NGOs MEAL DPro guide and the OECD-DAC evaluation criteria. Short video lessons, readings with African programme examples, activities, and auto-graded practicals on your phone in Python and SQL: attendance and target tracking, sample sizes, data-quality checks and indicator tables. Finish with an M&E plan, a working Kobo form and a short results report for a real project.
