Donor Compliance and Program Impact Dashboard Matrix

Role: Senior Nonprofit Evaluation Specialist with 12 years of experience in multi-funder grant governance and analytics.

Context

• Portfolio: {{grant_portfolio_name}}
• Target Population: {{target_beneficiary_group}}
• Compliance Frameworks: {{reporting_standards}}
• Source Systems: {{primary_data_sources}}
• Reporting Cadence: {{cadence_requirements}}
• Target Stakeholders: {{stakeholder_audience}}

Task

Synthesize the compliance and operational performance indicators for {{grant_portfolio_name}} into a comprehensive dashboard design matrix that bridges field-level output metrics with executive donor milestones for {{stakeholder_audience}}.

Method

1. Analyze {{reporting_standards}} to extract all mandatory output and outcome indicator requirements.
2. Map extracted indicators against available feeds in {{primary_data_sources}} to identify telemetry coverage and data pipeline gaps.
3. Segment metrics into strategic, operational, and fiduciary tiers tailored to {{stakeholder_audience}}.
4. Define aggregation logic and privacy masking thresholds for data concerning {{target_beneficiary_group}}.
5. Establish visual encoding recommendations (e.g., sparklines, progress gauges, variance heatmaps) for each metric type.
6. Assign data refresh frequencies aligned with {{cadence_requirements}} and source capability constraints.
7. Define variance thresholds and operational trigger alerts for underperforming program components.
8. Construct the indicator matrix incorporating governance ownership, field definitions, and validation rules.

Constraints

• MUST format the core deliverable as a structured markdown matrix comparing indicator attributes.
• MUST include explicit data governance owners and calculation formulas for every metric row.
• MUST NOT recommend visualization types that require proprietary third-party extensions.
• Keep narrative explanations concise and focused on public sector audit defensibility.

Output format

1. Executive Summary & Dashboard Architecture

(Max 150 words summarizing the hierarchy and cadence considerations).

2. Indicator Specification Matrix

(Markdown table containing: Metric Name | Strategic Dimension | Calculation Formula | Source System | Target & Baseline | Refresh Cadence | Visual Component | Audit Owner).

3. Implementation Risk & Data Quality Notes

(3-5 bullet points covering validation risks and mitigation strategies).

Self-review

• Confirm all 6 context variables are explicitly addressed in the matrix.
• Verify calculation formulas are unambiguous and field-verifiable.
• Ensure privacy considerations for {{target_beneficiary_group}} are represented in the specification.