Capstone – Project
Building a KPI Dashboard to Track Progress with Key Initiatives
A Collaboration Between
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.
HOST VENUE ADDRESS
- 197 East Broadway, New York, NY, USA
REQUIRED PREREQUISITES
- Business planning, with preference for experience in and/or interest in non-profit organizations
- Financial modeling
- Data visualization and analysis
LEARNING OBJECTIVES
- 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
Project Topics
Data Management
Growth Strategy
Operations
Software Design & Development
Company Information
| Company | Educational Alliance |
| HQ | New York |
| Revenue | Unlisted |
| Employees | 100-500 |
| Stage | Medium Business |
| Hiring Potential | Follow-on Projects |
| Website | https://edalliance.org/ |
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.
Experiential Learning Program Details
| School | University of Notre Dame Mendoza College of Business |
| Engagement Format | Capstone - Small Team Consulting Project - Students work in consulting teams of 3-5 directly with faculty and client liaisons on developing real solutions to real-world challenges. |
| Course | |
| Level | N/A |
| Students Enrolled | N/A |
| Meeting Day & Time | N/A |
| Student Time Commitment | 1-3 Hours Per Week |
| Company Time Commitment | 3-5 Hours |
| Duration | 0.43 Weeks |
Program Timeline
| Touchpoints & Assignments | Due Date | Type |
|---|
Key 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 2, 2020 -
-
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 3, 2020 -
-
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.
-
March 5, 2020 -
Project Resources
There are no resources currently available
Industry Mentors
Academic Mentors
Assigned Students
There are currently no students assigned.