Reports and Insights for Workforce and Talent Solutions Platform
Our client, a global leader in talent solutions and innovation, connects top-tier businesses with skilled professionals through agile teams and specialized delivery centers. Their internal Learning Management System (LMS) plays a critical role in preparing talent through structured learning paths. The client aimed to enhance visibility into student progress and optimize learning interventions using advanced analytics.
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 faced key hurdles in tracking and personalizing the learning experience:
- Limited data access via GraphQL API, restricting overall visibility
- No automated categorization of students (red/yellow/green) based on performance
- Lack of detailed student metrics, hindering targeted interventions
- Integration and performance challenges with existing LMS infrastructure
Our Solution
OnPoint Insights delivered a customized Power BI solution that enabled real-time insights, flexible reporting, and actionable intelligence for learning path optimization. Key elements included:
- Power M Code Customization: Extended the data pull capability of GraphQL API to access a broader, more useful dataset.
- Categorization Logic: Developed a smart classification algorithm to group students by performance thresholds.
- Interactive Power BI Dashboards: Created clean, visual overviews of progress along with drill-down capability for student-level metrics.
- Iterative Optimization: Fine-tuned logic and dashboard performance based on user feedback and evolving LMS needs.
Results
- Holistic Progress Monitoring: Provided an at-a-glance summary of student progress across categories.
- Student-Level Insights: Drill-down functionality enabled early intervention for struggling learners.
- Personalized Learning Paths: Educators could now assign custom paths based on real-time analytics.
- Efficient Resource Allocation: Resources were redirected strategically based on identified gaps.
- Enhanced Accountability: Transparent progress categorization encouraged student ownership.
- Scalable & Secure: Architecture scaled with user growth while addressing data privacy needs.
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.
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.