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

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

1. 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

1. 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

1. 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.

1. Supervision and Backstopping

• The Team Leader supervises overall.
• KE3supervises 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.

1. 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:

• Daisy L. Mwila: Daisy_Mwila@dai.com
• Cc: Gabriela_Georgieva@dai.com

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