Capstone – Project

Building a KPI Dashboard to Track Progress with Key Initiatives

A Collaboration Between

Engagement Synopsis

We seek to enhance the work of our over 30 programs by developing a dashboard of Key Performance Indicators that can integrate program output/outcomes information with budget information to provide a comprehensive picture of program performance to staff and agency leadership. Our goal is to use this partnership as a springboard for a fully-functioning KPI dashboard that can inform our agencyÔÇÖs efforts to better serve community members by identifying program strengths, challenges, and potential risks.


  • 197 East Broadway, New York, NY, USA


  • Business planning, with preference for experience in and/or interest in non-profit organizations
  • Financial modeling
  • Data visualization and analysis


  • Detailed understanding of non-profit data management strategies, challenges, and best practices
  • Insight into nonprofit data reporting (compliance, foundation, private donor audiences)
  • Insight into nonprofit financial planning and analysis
  • Insight into non-profit growth strategy

Company Information

CompanyEducational Alliance
HQNew York
Revenue10,000,000 - 50,000,000,
StageMedium Business
Hiring PotentialFollow-on Projects

Company Overview

Educational Alliance is a social services non-profit serving 50,000 New Yorkers annually across its network of community centers on the Lower East Side and East Village neighborhoods of Manhattan. We provide individuals and families high-quality, multi-generational programs and services that enhance their wellbeing and socioeconomic opportunities. As we have for 130 years, we offer best-in-class programmingÔÇônow across 15 sitesÔÇöfocusing on a mix of education, health and wellness, arts and culture, and civic engagement. We work across traditional boundaries and address the full hierarchy of needs ÔÇô from simple meals to educational, recreational, social, civic, and cultural supports.

Course Info & Engagement Details

SchoolMasters in Business Administration (MBA)
Engagement Format -
CourseMBA IMPACT Interterm (SPRING 2020)
  • All Graduate
Students Enrolled120 Enrolled, 2-5 per group per project
Meeting Day & Time3/2 - 3/5/2020
Student Time Commitment1-3 Hours Per Week
Company Time Commitment3-5 Hours
Duration0.43 Weeks

Project Topics

Program Timeline

Touchpoints & Assignments Due Date Type

Project Milestones

  • March 2, 2020 - Part 1: Analysis and Automization of Agency and Key Performance Indicators

    Identify key performance indicators that are unique to individual programs, as well as those that make sense to track across programs.  Work to identify opportunities to combine KPI outcomes within a single, unified data visualization and develop automated process for integrating disparate datasets.

    Suggested Deliverable:

    Document highlighting key performance indicators, ideal benchmarks, and opportunities to combine data that is similar but currently lives in different data sources within the agency.

  • March 3, 2020 - Part 2: Analysis of Agency Business Model to Connect KPI with Budget Priorities

    Utilize business model and target revenues to set priorities for KPI outcomes and identify outcomes that require refinement and/or benchmarking.

    Suggested Deliverable:

    Slide deck aligning current KPI with agency business model and budget.

  • March 5, 2020 - Part 3: Visual representation of uniform key outcome indicators across diverse agency programs.

    Using automated processes, draw data from disparate data sets within the agency into a single location for analysis and reporting purposes.

    Suggested Deliverable:

    Tableau (or similar visualization output) visualization of approximately 10 priority KPI across agency programs, including Early Childhood Education, Youth Programming, Adult Education, Advocacy, Membership, and Older Adult Services.

Project Resources

There are no resources currently available

Industry Mentors

Company Admin


[email protected]

Academic Mentors


Alice Obermiller

[email protected]


Jim Cunningham

[email protected]

Assigned Students

There are currently no students assigned.