I will automate excel reports and monthly kpis from survey data

Libya

I speak Arabic, English

KoboToolbox Expert Excel and Power BI Reporting Automation

I design professional surveys in KoboToolbox/ODK and build automated reporting systems in Excel (Power Query + Kobo API v2) and Power BI. I help NGOs and teams reduce manual work, improve data quality...
About this Gig

I will transform your KoboToolbox data into a clean and automated Excel reporting system with accurate monthly KPIs.


Using Excel and Power Query, I structure and clean your dataset so key metrics update efficiently whenever new data is added. This reduces manual work, improves accuracy, and ensures consistent reporting for management and decision-making.


You can choose to work from exported KoboToolbox files or connect directly using Kobo API v2 for automatic refresh.


This service is ideal for businesses, teams, and organizations that need reliable KPI tracking without rebuilding reports every month.


What you will receive:

  • Clean and structured dataset
  • Automated monthly KPI calculations
  • Totals, percentages, and segmented analysis
  • Cumulative tracking where required
  • Organized Excel file ready for ongoing use
  • Clear instructions for future updates


I focus on clarity, efficiency, confidentiality, and building reporting systems that save time and scale with your data.

Technology:

Excel

Expertise:

API integration

My Portfolio