Data, Dashboards & Custom Tools
Integrated data systems and purpose-built tools that connect what you do to the outcomes you achieve, and put the answer in front of the people who need it.
Connecting Tutoring Activity to Student Outcomes and Transforming Funder Reporting
The Challenge
On Your Mark Education is a national virtual tutoring organization providing individualized, science-of-reading-aligned foundational skills instruction to early elementary students. Like many growing direct-service organizations, On Your Mark had accumulated data across multiple platforms, including tutor session logs, student assessment results, and school partner reporting in numerous Google Sheets, but had no integrated way to look across those sources to answer the strategic questions leadership and funders were asking.
The organization could see how many tutoring sessions they delivered. They could see student assessment scores. But they wanted to more easily answer the fundamental question every funder asks: Is your tutoring activity actually connected to improvements in student outcomes?
This made funder reporting difficult and time-consuming. The team could describe their work and share student scores, but could not easily draw the line between the two.
The Solution
TRAIL mapped the data landscape by inventorying all data sources, formats, owners, and update cadences, and then identified redundancies and gaps relative to the questions leadership wanted to answer. The team worked with program leadership to validate and refine the KPI set, aligning on the small number of indicators that matter most for funder and board reporting rather than trying to include every metric the team could produce.
TRAIL then designed and built Google Looker dashboards that enabled the team to see student performance relative to a variety of implementation features, such as school, grade level, student demographics, tutoring model type (1:1 vs. 1:2), session attendance, and instructor, as well as the relationship between tutoring activity and student outcomes. The dashboard integrates assessment data, master tracker information, student attendance records, and tutor attendance into a single interactive platform with filterable views. A comprehensive FAQ document and maintenance handbook were embedded directly in the dashboard so the internal team can maintain and extend the system independently.
The Results
On Your Mark now has a coherent set of dashboards that the team uses to monitor implementation and track early indicators of their program's impact. The work transformed how the organization uses data: On Your Mark can not only describe their reach and impact; they can demonstrate it with data that is easy to access in their dashboards.
Funder reporting became less of a time-consuming exercise by connecting outcome data to tutoring activity. The organization can now identify which schools and which student populations are responding most strongly to the tutoring model, enabling more strategic deployment of their resources. And the dashboard's ability to disaggregate data by race/ethnicity, tutoring model, and instructor means On Your Mark can identify patterns and catch issues in weeks rather than discovering them at year's end.
The work is structured so the internal team can maintain and extend it as the organization grows.
Why This Matters
This case is especially timely as funders across the education sector make significant investments in high-dosage tutoring. Foundation staff will recognize a common challenge among their grantees: organizations that collect program data and outcome data but cannot connect the two in a way that demonstrates impact. On Your Mark's transformation illustrates how making these connections results in better reporting, better programs, and the kind of credible, data-backed impact narrative that sustains and grows funder relationships over time.
Designing a Custom 360 Assessment Tool When Nothing Off-the-Shelf Fit
The Challenge
Springpoint's Transformative Leaders of Massachusetts (TLM) is a two-year professional learning fellowship designed to develop aspiring and novice secondary school leaders prepared to reimagine high schools for equity and justice. The fellowship brings together approximately 12 fellows per cohort who are committed to leading school transformation.
Rather than focusing solely on traditional leadership competencies like vision-setting or instructional skill, Springpoint's framework centers on something deeper: transformative leadership grounded in dismantling systems of inequity, advancing models of excellence, and building new solutions to educational challenges.
Springpoint had reviewed multiple off-the-shelf 360 assessment tools, but none captured what they really cared about. Traditional competency checklists focus on what leaders can do. Springpoint needed something that could help fellows understand not just what they do, but how they show up and how they are experienced by others, especially in moments requiring vulnerability, authenticity, and emotional attunement.
Without clear data grounded in their framework, coaches and advisors were coaching without the data to guide their practice. They had valuable relationships with fellows, but without shared clarity about growth areas rooted in transformative leadership principles, the feedback loop was incomplete.
The Solution
Rather than force-fit an existing tool, Springpoint partnered with TRAIL to design a comprehensive 360 assessment built from the ground up around their framework. The tool had three integrated components:
A Custom 360 Survey Tool that moved beyond traditional competency ratings to reflect the core teachings of the fellowship. Qualitative prompts let fellows dig into stories and behaviors rather than rushing through ratings. Optional reflection spaces captured the feelings and thinking that shaped their choices.
Fellow Self-Reports providing each fellow with a personalized report presenting their self-assessment alongside feedback from school staff, peers, coaches, and supervisors, creating a rich, multidimensional picture of each fellow's leadership practice.
An Interactive Dashboard giving both individual fellows and the Springpoint team a way to visualize and explore the data, with a second dashboard aggregating data across the full fellowship cohort to reveal program-level trends and patterns.
The Results
Fellows engaged authentically with the tool and the coaching that accompanied it: many returned to the survey multiple times, productively wrestling with questions about their values and behaviors. The process fostered genuine introspection rather than quick checkbox behavior, and fellows began to reflect on their practice in ways they had not been asked to before.
Coaches gained clarity and direction by using the tool's questions as anchors for ongoing coaching conversations, grounded in specific data about each fellow's strengths and growth areas.
Psychological safety was created between fellows, and between fellows and their coaches. The emphasis on values, how fellows are experienced by others, and responses versus reactions signaled this was not about checking boxes on a competency rubric. It was about becoming a more self-aware leader.
A marketing and fundraising asset was built: Springpoint now has concrete, quantitative data about leadership growth that they previously could only describe anecdotally, transforming funder conversations.
Springpoint is now building the tool into their fellowship as an ongoing cycle, administering it again at the end of the school year to facilitate reflection conversations with fellows, positioning it as a deliberate learning cycle.
Why This Matters
Many nonprofit programs operate with leadership models, theories of change, or program frameworks that are genuinely unique. When no off-the-shelf evaluation tool captures what matters most, organizations face a difficult choice: use a misaligned instrument and get data that does not quite fit, or go without measurement entirely. Springpoint's transformation demonstrates that a custom-designed tool, built in close partnership with the program, can deliver assessment data that is both rigorous and directly aligned to how the program defines success.
The Tool That Became the Team's Common Language
The Challenge
This client's initiative brings together multiple partner organizations working toward shared goals in schools. Before engaging TRAIL, the initiative's data lived in Google Sheets, Google Forms, Qualtrics surveys, and Salesforce records scattered across partner organizations, with no unified architecture or governance.
Implementation coaches could not easily track their schools' progress or share information with colleagues without building a new report each time. Initiative leadership lacked a coherent view of progress across organizations and struggled to answer how well they were meeting their OKRs each quarter. The result was a disjointed team operating with fragmented information: everyone was doing important work, but no one could see the full picture or understand how the pieces fit together. Meetings became exercises in sharing updates from separate spreadsheets rather than opportunities for strategic collaboration.
The Solution
TRAIL conducted a full data landscape audit, documenting existing sources, owners, quality, and accessibility across all four partner organizations. The team held separate discovery sessions with implementation coaches (primary end users) and initiative leadership (secondary users) so the system would meet the distinct decision-making needs of each audience.
Rather than prescribing a one-size-fits-all view, TRAIL designed and built an interactive dashboard integrating OKR progress tracking, coaching visit data, implementation quality ratings, and school context information into one accessible platform. Each stakeholder group could access the information most relevant to their role while still working from a single source of truth. Initiative leadership can monitor progress across the entire partnership. Coaches can track their school-level work and see where support is needed. Partner organizations can access the context they need without requesting it from others or waiting for a quarterly report.
To ensure sustainability, TRAIL delivered facilitation guides, role-specific training, and a data maintenance handbook so the system persists after the engagement.
The Results
The dashboard became what the team describes as a "common language" for collaboration. Team meetings shifted from the mechanics of information sharing, where each partner presented its own data in its own format, to conversations that start from a common understanding and move directly into problem-solving and strategic decision-making.
From scattered to shared: Multiple disconnected spreadsheets replaced by a single integrated platform accessible to all partners, creating one source of truth for the entire initiative.
From reporting to collaboration: The dashboard functions not just as a reporting tool but as infrastructure that enables partners to work together more effectively and make decisions together.
From fragmented to holistic: Initiative leadership can now track OKR progress, coaching activity, and implementation quality in one view, connecting the dots that were previously invisible.
From reactive to proactive: Coaches gained real-time visibility into implementation progress, allowing them to adjust support before small issues became systemic problems.
Why This Matters
Multi-partner initiatives are among the hardest programs to evaluate and manage because data is distributed across organizations with different systems and practices. This case demonstrates that with the right design approach, a dashboard can become more than a reporting tool. It can become the foundation and structure that holds a complex initiative together.
Standardizing Outcome Tracking Across a Multi-Portfolio Education Investment Strategy
The Challenge
This foundation's education program manages a portfolio of significant scale across eight strategic investment areas and dozens of grantee organizations. Each portfolio has its own theory of change, its own grantees, its own definitions of success, and its own reporting cadences. Without a standardized way to capture grantee outcomes across portfolios, leadership conversations about progress had to happen one grant at a time. Year-over-year comparisons were difficult. Program officers had no shared language for what progress looked like across portfolios. The work of tracking which grantees had reported, which were missing documentation, and which had hit their performance targets had become a bottleneck concentrated in a single staff member's institutional knowledge.
Foundation leadership had identified four areas of impact that mattered across every grant but had not yet operationalized those four areas into a consistent measurement and reporting system.
The Solution
TRAIL began with a comprehensive audit of every active grant across the eight portfolios: what was being funded, what each grantee had committed to deliver, how outcomes were being reported, and where documentation was missing. This produced a three-way reconciliation across tracking systems, outstanding documentation, and grant files, giving the foundation a complete, audited picture of what it actually had in hand and what was outstanding.
With the inventory baselined, TRAIL helped build a standardized framework that allows outcomes to be compared across portfolios without losing what is unique to each. The framework rests on three connected components:
Portfolio-specific common metrics one-pagers: one for each of the eight investment areas, all built to the same template. Each one-pager defines the metrics used to assess progress across the four areas of impact, specifies dashboard benchmarks with green/yellow/red cutpoints for each metric, and includes a comprehensive set of FAQs and annual reporting guidance for program officers.
A consolidated dataset: bringing 70+ grants across eight portfolios into a single structured database, with grantee-level performance data tagged to portfolio, metric, and year. Year-over-year comparison logic was built in so that changes across reporting periods can be surfaced automatically.
A dashboard system: designed around a structured data architecture focused on the foundation's four outcome areas.
Beyond the dashboards, TRAIL helped the team produce a comprehensive set of program officer guidance documents, including a metric writing guide, benchmarking guidance, portfolio-specific one-pagers, and consolidated FAQs, that turned what was a single staff member's institutional knowledge into a shared organizational capability.
The Results
The foundation now has a single, unified system for tracking grantee outcomes across its entire education portfolio. Leadership can compare performance across investment areas using a common framework while still seeing what is unique to each. Program officers have clear guidance on how to set goals with grantees, track performance throughout the year, and prepare for leadership reviews. The dashboards roll up into the foundation's annual leadership slides.
The framework is not a one-time deliverable; it is the operational system the foundation uses to manage its portfolio on an ongoing basis. As the foundation transitions from one strategic plan to the next, the framework is being adapted to reflect new priorities without losing the data continuity built to date.
Why This Matters
This engagement represents a different kind of work than program-level evaluation. Here, the unit of analysis is the foundation itself, and the question is how to standardize outcome tracking across a complex portfolio without flattening what is genuinely different about each investment area. The four-area framework is what makes that possible. It gives the foundation a comparable view across portfolios while still allowing each portfolio to define what those four areas mean in its specific context. For any foundation struggling to see the collective impact of its investment strategy, this case illustrates what becomes possible when measurement standardization is designed thoughtfully.