HELPAZONE
Find Your Help
À la carte catalogue

One specific tool to master, now.

You can find free Excel or Power BI tutorials online. What they'll never give you: a trainer correcting your own file live, a deliverable built on your real data, and 6 months of support if you get stuck afterwards. Eight standalone courses, no commitment to a full pathway.

See the catalogue ↓ Request a quote
1

Your own file, live. The trainer corrects your data during the session, not a generic exercise.

2

A deliverable, not just a certificate. You leave with a working file or dashboard.

3

6 months of support. A free tutorial stops at the video; we don't.

Tools in this catalogue
ExcelPower BIDHIS2 AggregateDHIS2 TrackerKoboToolboxCommCareNVivoOutils IA
Tool training

À la carte training catalogue

Every course here is also part of a Helpazone certifying pathway (MEAL, BI or Data Analyst) but can be taken standalone, for anyone who needs one specific tool without a longer commitment.

Advanced office skills

Excel Professional: reporting, automation and business dashboards

For SMEs and teams who only need Excel, without committing to the full Data Analyst pathway. Get reliable files, automated reports, and tracking tables your team can maintain on its own.

Duration3 days (24h)
Price360,000 Ar (≈ $84)
LocationMadagascar · in-person / online
PrerequisitesNone
Support6 months free
CertificateHelpazone Excel certificate
Day 1

Handle and clean data

  • Essential formulas, relative and absolute references
  • Data cleaning, duplicate and inconsistency detection
Day 2

Pivot tables and visualisation

  • Pivot tables, slicers, conditional formatting
  • Charts and sales / stock / expense tracking tables
Day 3

Automate with Power Query

  • Connecting multiple sources, repeatable transformations
  • Workshop: automated monthly report on your real data

🎯 Skills you'll gain

  • Build reliable, verifiable formulas
  • Clean and structure a dataset
  • Produce pivot tables and charts
  • Automate a recurring report with Power Query

This module matches the Data Foundation level of the Data Analyst pathway. A 3-hour equivalence test can convert your certificate into a Data Foundation badge.

Enrol in Excel Professional →
Business Intelligence

Power BI Professional: from data connection to a published dashboard

For SMEs and teams who only need Power BI, without committing to the full BI pathway. Connect your sources, build your measures, and publish a dashboard your organisation will actually use.

Duration5 days
Price750,000 Ar (≈ $174)
LocationMadagascar · in-person / online
PrerequisitesBasic Excel skills
Support6 months free
CertificateHelpazone Power BI certificate
Day 1

Connection & modelling

  • Power Query: multi-source connection, transformation
  • Relationships, star schema (Kimball methodology)
Day 2

DAX

  • Measures, time intelligence
  • Calculated columns and filter context
Day 3

Visualisation

  • Storytelling, brand themes
  • Choosing the right visual for the message
Day 4

Dashboard

  • Slicers, cockpit workshop
  • Tooltips, bookmarks, interactive navigation
Day 5

Publishing

  • Row-Level Security (RLS): one report, different data by role
  • Secure sharing, scheduled refresh
  • Workshop: dashboard published on your real data

🎯 Skills you'll gain

  • Model data using a star schema
  • Write reliable DAX measures
  • Choose the right visualisation for the message
  • Publish and share a dashboard securely

This module matches the BI Practitioner level of the BI pathway. To earn the badge (not just the certificate), also validate Data Foundation, directly or via our 3-hour equivalence test.

Enrol in Power BI Professional →
Aggregate data

DHIS2 Aggregate: configuring and analysing routine data

The most widely used DHIS2 model: counts and totals by period and organisation unit: the classic case of routine monthly reporting. Configure, set up and analyse independently.

Duration4 days
Price600,000 Ar (≈ $140)
LocationMadagascar · in-person / online
Support6 months free
Day 1

Getting started & configuration

  • Architecture, users, roles
  • Aggregate metadata: data elements & datasets
  • DHIS2 Android app for offline field data entry
Day 2

Form configuration

  • Sections, flows, periods
  • Validation rules
Day 3

Indicators & data quality

  • Indicator groups
  • Anomaly detection: min-max rules, outlier values
  • Completeness, consistency, sharing
Day 4

Analysis & reporting

  • Pivot tables, Data Visualizer, GIS maps
  • Workshop: a ready-to-use aggregate dashboard

🎯 Skills you’ll gain

  • Configure the architecture and user roles
  • Set up forms and validation rules
  • Build indicators and monitor aggregate data quality
  • Produce dashboards and GIS maps
AssessmentGraded workshop + final dashboard
CertificateHelpazone DHIS2 Aggregate attestation

DHIS2 Aggregate is part of the MEAL Practitioner pathway, alongside KoboToolbox and CommCare.

Enrol in DHIS2 Aggregate →
Individual tracking

DHIS2 Tracker: individual tracking programmes

The DHIS2 model for longitudinal tracking of individual entities (a patient, a beneficiary) with enrollments, programme stages and conditional logic. Closer, in spirit, to CommCare's case management.

Duration4 days
Price600,000 Ar (≈ $140)
LocationMadagascar · in-person / online
Support6 months free
Day 1

Tracker programme design

  • Tracked entity types, attributes
  • Programme stages
Day 2

Programme rules

  • Conditional logic, validations
  • Automatic calculations, conditional field display
Day 3

Deployment & collection

  • Capture app (mobile / web)
  • Managing enrollments and relationships between entities
Day 4

Tracker analysis

  • Event reports and cohort tracking
  • Workshop: an individual tracking dashboard

🎯 Skills you’ll gain

  • Design a Tracker programme suited to individual tracking
  • Build conditional programme rules
  • Deploy Tracker data collection in the field
  • Produce a cohort analysis
AssessmentGraded working Tracker programme
CertificateHelpazone DHIS2 Tracker attestation

DHIS2 Tracker complements the MEAL Practitioner pathway for individual beneficiary tracking.

Enrol in DHIS2 Tracker →
Mobile data collection

KoboToolbox : From form design to data exploitation

Design robust forms, deploy them in the field with the KoboCollect app, and work with clean data ready for DHIS2, Power BI or Excel.

Duration4 days
Price480,000 Ar (≈ $112)
LocationMadagascar · in-person / online
Support6 months free
Day 1

XLSForm design

  • Basic structure, question types, choice lists
  • Groups, layout and naming best practices
  • Accessibility for enumerators: font size, contrast, simplified navigation
  • Multimedia questions: photo, audio, geolocation
Day 2

Advanced logic

  • Skip logic (relevant), constraints and validations
  • Automatic calculations, repeat groups, conditional notes
Day 3

Field deployment & data collection

  • KoboCollect mobile app, user management
  • Real-time submission tracking and quality control
  • Enketo (web collection) as an alternative to the mobile app
  • Encrypting sensitive data (GBV, health) on the form and in transit
Day 4

Data exploitation

  • Clean export, cleaning and structuring
  • REST API to automate data retrieval into an external pipeline
  • Workshop: connecting to Power BI / Excel for a collection monitoring dashboard

🎯 Skills you’ll gain

  • Design an XLSForm with conditional logic
  • Deploy mobile data collection with quality control
  • Choose between mobile and web collection (Enketo)
  • Export clean data ready for analysis
AssessmentWorking form + graded export
CertificateHelpazone KoboToolbox attestation

KoboToolbox is part of the MEAL Practitioner pathway.

Enrol in KoboToolbox →
Case management & field

CommCare : Case management and longitudinal mobile data collection

Unlike a one-off collection, CommCare tracks a beneficiary over time through its case management system. Design, deploy and use a longitudinal tracking application.

Duration4 days
Price600,000 Ar (≈ $140)
LocationMadagascar · in-person / online
Support6 months free
Day 1

Application design

  • Form structure, cases and modules
  • Question types and conditional logic
Day 2

Case management

  • Longitudinal beneficiary tracking, case lifecycle
  • Case relationships (parent/child), open/closed cases
Day 3

Field deployment & data collection

  • CommCare mobile app, user and role management
  • Sync, offline mode, quality control
Day 4

Data exploitation

  • Clean export, built-in reports (CommCare HQ)
  • Workshop: connecting to Power BI / Excel for a monitoring dashboard

🎯 Skills you’ll gain

  • Design an application with case management
  • Track beneficiaries over time (longitudinal)
  • Deploy and manage field users
  • Use exported data in a dashboard
AssessmentGraded working application
CertificateHelpazone CommCare attestation

CommCare complements the MEAL Practitioner pathway for field data collection.

Enrol in CommCare →
Qualitative analysis

NVivo : Coding, reliability and rigorous qualitative analysis

Structure, code and analyse qualitative data to academic and MEAL evaluation standards: thematic coding, inter-rater reliability, full traceability.

Duration5 days
Price750,000 Ar (≈ $174)
LocationMadagascar · in-person / online
Support6 months free
Day 1

Getting started & import

  • Project structuring, importing sources (text, audio, video, PDF)
  • Organising qualitative data
Day 2

Thematic coding

  • Creating nodes (codes), manual and assisted coding
  • Deductive vs inductive coding
Day 3

Reliability and rigour

  • Inter-rater reliability (Cohen’s Kappa coefficient)
  • Theoretical saturation, comparing coding across researchers
Day 4

Queries and analysis

  • Word queries, coding queries, matrix coding
  • Visualisations: word clouds, coding maps
Day 5

Reporting & traceability

  • Exporting coding reports, audit trail
  • Workshop: a complete qualitative analysis report

🎯 Skills you’ll gain

  • Structure a qualitative analysis project
  • Code thematically with rigour (deductive and inductive)
  • Assess inter-rater reliability
  • Produce analytical queries and visualisations
  • Write a traceable, defensible qualitative report
AssessmentGraded coding report
CertificateHelpazone NVivo attestation

NVivo is used in the "Mixed methods" module of the MEAL Specialist pathway.

Enrol in NVivo →
Applied AI

AI Tools for professionals : responsible and confidential use

Generative AI as a real productivity lever, not a black box. Prompt engineering, reporting, data analysis and organisational governance, with a responsible, confidential usage framework from day one.

Duration4 days
Price600,000 Ar (≈ $140)
LocationMadagascar · in-person / online
Support6 months free
Day 1

Understanding generative AI

  • How it works, real strengths and limitations
  • Hallucinations: recognising and checking fabricated information
  • Data confidentiality and responsible use
Day 2

Prompt engineering and advanced techniques

  • Structuring an effective prompt: context, role, expected format
  • Iterative refinement and breaking down complex tasks
  • Comparing ChatGPT, Claude and Gemini for different needs
Day 3

AI applied to reporting, analysis and data

  • AI-assisted donor report writing
  • Large-scale text synthesis and analysis
  • Generating Excel formulas and analysis scripts with AI assistance
Day 4

Automation and organisational governance

  • Automating repetitive tasks
  • Establishing an AI usage policy for your organisation
  • Workshop: an AI workflow applied to a participant’s real case

🎯 Skills you'll gain

  • Use generative AI responsibly and confidentially
  • Structure advanced prompts (prompt engineering)
  • Speed up report writing and data analysis without losing rigour
  • Establish an AI usage policy for your organisation
AssessmentPresented applied workflow
CertificateHelpazone AI Tools attestation

Applied AI complements every pathway at Systems level: MEAL, BI, SI.

Enrol in AI Tools →
Proof

They found the exact tool they needed, no detour

★★★★★

"We only needed DHIS2, nothing more. Four days, a trainer who already knew our sector, and a working health dashboard by the end. No lengthy pathway, just what we actually needed."

VR
Voahangy R.
Health monitoring officer, health NGO, Fianarantsoa
Contact

Ready to take action?

Leadership, HR, programme or business: we respond within 48 business hours.

Confidential information. Personalised response within 48 business hours.