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
- 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
Software Design & Development
Experiential Learning Program Details
|School||University of Notre Dame Mendoza College of Business|
|Engagement Format||Capstone - Small Team Consulting Project - Students work in small groups of 2-6 directly with faculty and host company project champions on developing real solutions to real-world challenges.|
|Students Enrolled||120 Enrolled, 2-5 per group per project|
|Meeting Day & Time||3/2 - 3/5/2019 on-site at host company|
|Student Time Commitment||1-3 Hours Per Week|
|Company Time Commitment||3-5 Hours|
|Touchpoints & Assignments||Due Date||Submission|
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.
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.
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.
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 -
There are no resources currently available