Tableau Dashboard Development for Programme Monitoring Training Course

Course overview

Programme teams in development and humanitarian organisations often hold monitoring data across Excel trackers, beneficiary databases, partner reports and assessment files, yet struggle to turn it into timely management insight. Static donor reports can obscure missed targets, geographic gaps, disaggregated results and data-quality issues. This course addresses the practical need to build Tableau dashboards that allow programme managers, MEAL teams and partners to interrogate performance against indicator targets, review trends and act on credible evidence.

Participants learn how to structure programme-monitoring data for Tableau, connect and clean common M&E data sources, define calculated fields, and build interactive dashboards for results frameworks, logframes, output tracking and beneficiary reach. The course covers indicator disaggregation by sex, age, disability, location and implementing partner; target-versus-actual analysis; date-based reporting periods; filters; parameters; table calculations; maps; and dashboard actions. Participants also learn how to design views that distinguish outputs, outcomes, coverage, quality and data completeness rather than presenting attractive but misleading charts.

Instruction combines guided Tableau demonstrations with hands-on work using a realistic multi-sector programme dataset. Each participant develops a publishable programme-monitoring dashboard pack, including an indicator performance dashboard, disaggregation view, geographic coverage view and data-quality exception page. The final workshop includes a dashboard review against user needs, donor reporting requirements and safeguarding-aware data presentation. Participants leave with a reusable Tableau workbook structure, calculation patterns and a documented plan for applying the approach to their own programme data.

The course is designed for practitioners who already understand basic M&E concepts and need to move from spreadsheet-based reporting to interactive, decision-ready visualisation. It is equally valuable for managers approving dashboard work who need staff to produce reliable reporting products that can be governed, refreshed and used across country offices or portfolios.

Course objectives

By the end of this course, participants will be able to:

• Connect Tableau Desktop to Excel, CSV and relational programme-monitoring data sources
• Structure indicator datasets using unique IDs, reporting periods, disaggregation fields and target values
• Create calculated fields for achievement rates, variance, cumulative results and data-completeness flags
• Build interactive target-versus-actual dashboards for logframe and indicator performance monitoring
• Apply filters, parameters, dashboard actions and table calculations to support management interrogation
• Design maps and disaggregated views for geographic coverage, beneficiary reach and equity analysis
• Validate dashboard figures against source data using reconciliation checks and exception reporting
• Publish a documented Tableau dashboard pack with refresh, access and governance requirements

Benefits of attending

Target competencies

Who should attend

• Monitoring, Evaluation, Accountability and Learning Officers — who need to turn indicator data into usable management dashboards
• Programme Managers — who need rapid visibility of delivery progress, gaps and underperforming locations
• M&E Managers — who oversee indicator systems, data quality and reporting across projects or portfolios
• Information Management Officers — who prepare operational datasets and visual products for programme teams
• Grants and Reporting Officers — who consolidate results evidence for donor reports and internal reviews
• Data Analysts in NGOs and humanitarian agencies — who need Tableau methods tailored to logframes and programme indicators

Requirements and prerequisites

Participants should have working knowledge of monitoring and evaluation terminology, including indicators, baselines, targets, disaggregation, reporting periods and logframes or results frameworks. They should be comfortable using Excel to inspect tables, sort and filter records, and recognise basic data-quality issues such as duplicates or missing values. Prior Tableau experience is helpful but not essential; the course starts with the Tableau workspace and core chart construction before moving to calculations and dashboards. No coding, SQL, GIS expertise or advanced statistical analysis is required. Participants should bring access to a laptop capable of running Tableau Desktop.

Training methodology

The course uses short instructor-led demonstrations followed by structured Tableau build exercises using a realistic humanitarian and development programme dataset. Participants work through indicator registers, beneficiary records, location data and partner submissions to create progressively more capable worksheets and dashboards. Case discussions examine common reporting failures, including inconsistent denominators, missing disaggregation and misleading cumulative charts. Peer dashboard critiques use a practical review checklist covering usability, indicator logic and data protection. On the final day, participants complete an application plan for their own reporting cycle, data sources and dashboard users.

Course outline

Day 1: Preparing programme data for Tableau

• Programme monitoring questions and dashboard user stories
• Translating logframes into dashboard-ready indicator tables
• Tableau Desktop workspace, data pane and worksheet workflow
• Connecting to Excel, CSV and relational data sources
• Data types, field roles and geographic roles
• Data grain, unique identifiers and reporting-period design
• Source-data checks for missing values, duplicates and inconsistent labels

Workshop: Participants audit a multi-partner indicator dataset and create a Tableau data source with standardised fields and documented data-quality issues.

Day 2: Calculating and visualising indicator performance

• Calculated fields for targets, actuals and achievement percentages
• Aggregate functions and avoiding double-counted indicator values
• Date calculations for monthly, quarterly and cumulative reporting
• Reference lines and bands for performance thresholds
• Bar charts, bullet charts and highlight tables for target tracking
• Table calculations for running totals and period-on-period change
• Conditional formatting for underperformance and overdue reporting

Workshop: Participants build an indicator performance worksheet set showing quarterly achievement, cumulative progress and exceptions against approved targets.

Day 3: Disaggregation, geography and interactive analysis

• Disaggregating results by sex, age, disability and population group
• Using filters and context filters for programme review questions
• Parameters for switching indicators, periods and comparison views
• Sets and groups for partner, sector and geographic analysis
• Symbol maps, filled maps and spatial data considerations
• Dashboard actions for drill-down and linked views
• Equity analysis using proportional reach and coverage comparisons

Workshop: Participants create an interactive beneficiary reach dashboard with disaggregation controls, location mapping and partner-level drill-down actions.

Day 4: Dashboard design, validation and governance

• Dashboard layout for country directors, programme managers and donor reporting teams
• Selecting charts that match output, outcome and coverage measures
• Accessibility, colour use and readable labels for decision-making
• Data-quality dashboards for completeness, timeliness and validity checks
• Reconciling Tableau totals with source reports and indicator trackers
• Safeguarding-aware presentation of sensitive beneficiary data
• Tableau Cloud publishing, permissions and extract refresh considerations

Workshop: Participants assemble a management dashboard and conduct a structured validation review against source totals, user questions and data-protection constraints.

Day 5: Publishing a programme-monitoring dashboard pack

• Building navigation, device layouts and dashboard story flow
• Using Tableau Prep Builder for repeatable data-cleaning steps
• Creating reusable calculated-field and dashboard templates
• Documenting indicator definitions, sources and refresh responsibilities
• Applying IATI-aligned results data concepts to dashboard fields
• Presenting findings and limitations to programme decision-makers
• Implementation planning for organisational dashboard adoption

Workshop: Participants complete and present a four-page programme-monitoring dashboard pack with an implementation plan, data dictionary and refresh workflow.

Tools & standards covered

Tableau Desktop, Tableau Prep Builder, Tableau Cloud, IATI Standard

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions