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

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

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.

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.