Enhancing Financial Insights for a Leading Philanthropic Fund
A leading philanthropic fund dedicated to advancing human rights and promoting social and economic justice partnered with OnPoint Insights to transform how they analyze and present their funding data. With programs spanning multiple regions and focus areas, the organization sought deeper visibility into project-level funding allocations across geographies and initiatives. The goal was to create a clear, tabular, insight-rich view of their financial data—empowering the team to make more informed decisions and strengthen the impact of their funding strategy.
Lancaster Airport (LNS) is a public-use airport located four miles (6 km) north of the central business district of Lancaster, a city in Lancaster County, Pennsylvania. Lancaster Airport is a general aviation airport and offers various services, including fuel, maintenance, and aircraft rental. It also hosts several aviation-related businesses, such as flight schools, aircraft sales, and aviation consulting. The Lancaster Airport Authority manages the airport and is responsible for its operation and development. The Lancaster Airport Authority is a governmental entity created by Lancaster County in 1961 to develop and operate the airport.
The Challenge
The client required a solution that could turn complex financial datasets into meaningful insights. Key challenges included:
- Fragmented reporting across International, U.S., and Program-level funding
- Difficulty visualizing key metrics like grants, allocations, approval rates, and remaining budgets
- Lack of an intuitive, filterable interface for dynamic tabular reporting
- The need for a scalable and reusable solution built on open-source technology
Our Solution
OnPoint Insights designed and implemented an interactive, R-based analytics solution focused on clarity, accessibility, and scalability. Highlights of the implementation included:
- Data Engineering in R: Cleaned, transformed, and structured funding data using libraries like dplyr, tidyr, and lubridate to ensure readiness for analysis.
- Advanced Tabular Visualizations: Created three hierarchical tables (by Country, State, and Program) to display metrics such as: Approved and pending amounts, Remaining budgets, Approval percentages, Year-wise trends represented through sparklines
- Custom R UI Design: Incorporated intuitive filters (region, fiscal year, program type) and vibrant visual cues (bar graphs, conditional formatting) to enhance usability.
- Modular & Reusable Codebase: Delivered the full solution along with well-documented R scripts, allowing the client to extend and maintain the system internally.
- Export & Accessibility Options: Enabled multi-format exports (CSV, Excel, PDF) and print-ready views to support internal reporting and stakeholder presentations.
Results
- Improved Financial Visibility: The client gained the ability to explore funding dynamics across multiple dimensions in real time.
- Informed Decision-Making: Teams were empowered to identify trends, gaps, and funding bottlenecks, resulting in smarter allocation strategies.
- Scalable Reporting Framework: The modular R-based approach allowed easy replication for future funding datasets or different programs.
- Enhanced User Experience: The sleek tabular interface combined detailed insight with user-friendly navigation and export features.
Technologies Used
WordPress
Php
HTML
CSS
Javascript
Bootstrap
Python
Value Delivered To The Customer
- The seamless UI and interactive homepage facilitated smooth navigation for Lancaster’s customers, resulting in an increased customer conversion rate for the client.
- The updated design delivered real-time flight status updates, weather reports, and a fully compatible user interface for all devices.
- A user-friendly content management system that facilitates smooth updates to content.
Technologies Used
- WordPress
- HTML
- CSS
- PHP
- Python
- Javascript
R
R Shiny
The Results
- The seamless UI and interactive homepage facilitated smooth navigation for customers, resulting in an increased customer conversion rate for the client.
- A user-friendly content management system that facilitates smooth updates to content.
- The OnPoint Insights team developed an agenda and minutes section that is not only user-friendly on the front end but also backend-friendly for easy updates.
- The updated design will deliver real-time flight status updates, weather reports, and a fully compatible user interface for all devices.
Take Away
This case study showcases how OnPoint Insights Insight assisted a prominent local entity like Lancaster to develop a comprehensive website, aiming to bolster their engagement with the community and establish a compelling online presence.