Development of a Land Audit Dashboard using Power BI integrated with ODK and QGIS data sources

Job description

TERMS OF REFERENCE FOR NON-KEY EXPERT

Title of Assignment
Development of a Land Audit Dashboard using Power BI integrated with ODK and QGIS data sources

Budget Line/ Expert Category

1 Senior NKE

Relevant project activity #

Output 3.3: District Audit Methodology Carried out by Capacitated District Authorities

Audit Question

N/A

Location

Lusaka, Zambia

Duration

54 days

Expected start date

12/05/2025

Expected end date

12/09/2025

The EU support to the National Land Audit (NLA) project aims to improve land administration and management in Zambia. The project focuses on:

Improving the National Spatial Data Infrastructure (NSDI), updating it with information that is publicly available and accessible, and producing land cover, and land use maps at the National level

Making available and accessible key results of the National Land Audit

Testing and validating Innovative National Land Audit methodologies

Providing guidance for shaping a full National Land Audit implementation and forming a post audit action plan

I. Background of the Assignment

A key output is the development of a dynamic and interactive Land Audit Dashboard that will visualize key indicators linked to the nine (9) audit questions, using data collected from:

Field surveys (ODK)

Geospatial datasets (QGIS)

Administrative land information systems

This dashboard will support decision-making for:

Policymakers

Stakeholders

The public

II. General Objective of the Assignment

GENERAL OBJECTIVES

Develop an interactive, spatially enabled and user-friendly Land Audit Dashboard using Microsoft Power BI, integrating datasets from ODK and QGIS, to visualize and analyze indicators related to the 9 National Land Audit questions.

SPECIFIC OBJECTIVES

Conduct user requirement analysis to identify key needs and expectations for the Land Audit Dashboard among NLA, MLNR, and other stakeholders.

Design the structure and indicators of the National Land Audit Dashboard mapped to the nine audit questions.

Ensure the dashboard design meets user needs, including data visualization, filtering, and spatial display capacities.

Develop an automated and scalable data workflow from ODK to Power BI.

Develop an interactive dashboard design reflecting user requirements.

Produce visualizations (tables, charts, maps) that dynamically display the land audit results.

Align and process datasets from ODK, and spatial data layers from QGIS, for integration into Power BI.

Integrate data from ODK forms, QGIS spatial layers, and administrative datasets.

Map audit indicators to the 9 core audit questions, enabling drilldowns and thematic analysis.

Deploy the dashboard on the National Land Audit (NLA) server environment, ensuring secure and controlled access.

Conduct full testing, documentation, and validation of the dashboard.

Provide user and administrator training on dashboard usage and updates. Conduct training for NLA and district staff on dashboard usage, maintenance, and data interpretation.

Provide a comprehensive user manual and technical documentation.

EXPECTED RESULTS

Fully functional and interactive Land Audit Dashboard in Power BI aligned with the nine audit questions.

User needs and requirements clearly documented and reflected in the dashboard design.

Integrated and automated data pipeline combining ODK and QGIS datasets.

Dashboard deployed and operational on NLA’s secure server.

Comprehensive testing of dashboard functionalities and performance.

Trained NLA and district staff on dashboard use and maintenance.

Detailed user manual and technical guide for dashboard operation.

Recommendations for future enhancements and broader roll-out.

III. Scope of Work

Target Groups

Ministry of Lands and Natural Resources (MLNR)

Zambia Statistics Agency

Smart Zambia Institute

Ministry of Agriculture

Civil society and customary land rights organizations (limited access layer)

SPECIFIC ACTIVITIES

Sub-Activity Location Number of workdays
Briefing with the EUD and with the MLNR Lusaka 1
User needs assessment and requirements collection workshops Lusaka 4
Review of ODK datasets, QGIS spatial layers, and audit questions Lusaka 2
Data integration from ODK (surveys), QGIS (spatial), and administrative datasets Lusaka 2
Design of dashboard structure and indicator framework Lusaka 3
Dashboard design proposal Lusaka 1
Dashboard development in Power BI and integration with ODK and QGIS Lusaka 12
Linking spatial layers in QGIS with tabular data for interactive mapping Lusaka 4
Internal testing and validation of dashboard functionality Lusaka 3
Deployment on NLA server, configuring access roles Lusaka 2
Testing of dashboard functionalities with selected stakeholders Lusaka 2
Incorporation of feedback and final adjustments Lusaka 2
Documentation development (admin and user guides) Lusaka 4
Final testing of deployed dashboard Lusaka 2
User training (admin and end-user) Lusaka 5
Final presentation and live demonstration to stakeholders Lusaka 1
Debriefing with the EUD and with the MLNR Lusaka 1
NKE Reporting Lusaka 3
Support during user acceptance testing (UAT) and adjustments Remote 5

Total number of days: 54

IV. Deliverables and Reporting Requirements

FORMAL DELIVERABLES
The working language of the assignment will be English.

An electronic copy of each of the below-mentioned deliverables should be submitted first to the Team Leader and KE3 within the respective timeframe. The Team Leader will submit them to the Contracting Authority and MLNR.

Objective Specific Deliverables Deadline
1 User needs assessment report and dashboard design proposal Day 10
2 Integrated dataset (ODK, QGIS, admin data) ready for Power BI model Day 20
3 Beta version of the Land Audit Dashboard with mapped audit indicators Day 30
4 Tested and validated dashboard Day 40
5 Final deployed dashboard on NLA server Day 45
6 Training sessions conducted Day 47
7 User and administrator manuals/documentation Day 48
8 Final presentation to stakeholders Day 50

ADMINISTRATIVE OUTPUTS

Monthly Time Sheets including task description signed and submitted to Team Leader.

Monthly report describing activities, outputs, and indicators achieved.

V. Supervision and Backstopping

The Team Leader supervises overall.

KE3 supervises technical aspects.

Project Officer in Lusaka supports with logistics, meetings, and admin.

The expert must contact the Team Leader prior to start.

The Project Manager and Director (Contractor HQ) review all formal deliverables.

VI. Candidate Selection Criteria

Qualifications

Bachelor’s degree in IT, Data Science, GIS, Statistics, or related field

General Professional Experience

5+ years in Power BI dashboard development, data modeling

Knowledge of ODK and integration techniques Survey Data

Experience in QGIS and geospatial data handling

Familiarity with land administration/audit indicators desirable

Specific Skills

Proven ability to link spatial and statistical data, design interactive dashboards

Fluent in English (written and spoken)

Experience in delivering user/admin training

VII. Logistics and Timetable

Expert based in Lusaka; may travel to provinces/districts as needed

Assignment dates: Start – 12/05/2025 | End – 12/09/2025

Application Instructions:

Interested candidates are invited to submit their applications (cover letter and CV) to:

Ms. Daisy L. Mwila: Daisy_Mwila@dai.com

Cc: Gabriela_Georgieva@dai.com

Deadline: 2nd May 2025
Only shortlisted candidates will be contacted.