Manual Spreadsheet Processing
Evaluation data required repetitive extraction, cleaning, formula management, and static chart updates.
Student Experience & NPS Performance Intelligence Platform
Developed an automated Power BI analytics solution for EF Saudi Arabia that centralizes weekly student feedback, calculates dynamic Net Promoter Score metrics, compares evaluation periods, and gives operational leaders timely visibility into student satisfaction across Walk-In, Scholarship, and H-Scholarship programs.
Student Experience Analytics
NPS Performance Tracking
6,000+ Participants
Weekly Trend Analysis
Program-Level Comparison
1.
Business Challenge
Student feedback from more than 6,000 active participants was processed through manual spreadsheet models, creating delays, errors, and limited visibility into satisfaction trends across multiple program types.
Severe Insight Lag
Weekly NPS calculations took days, reducing the opportunity to address student grievances while they were still actionable.
Reactive Service Improvement
Operations teams responded after satisfaction issues had already developed instead of detecting negative movement early.
Fragmented Weekly Evaluation Data
Testing and survey weeks were not automatically consolidated, preventing reliable trend analysis.
Limited Program Comparison
Stakeholders could not easily compare Walk-In, Scholarship, and H-Scholarship student satisfaction.
2.
Solution
A centralized Power BI reporting platform automated data preparation, NPS calculation, week-to-week comparison, and program-level evaluation analysis.
Automated Power Query Integration
Extracted, normalized, cleaned, and combined disparate weekly evaluation sheets into a standardized dataset.
Structured Star Schema
Organized evaluation weeks, student program types, submission volumes, and satisfaction measures for scalable analysis.
Dynamic NPS Measures
DAX calculated overall NPS, Promoter %, Detractor %, Passive %, and week-on-week performance changes.
Directional Performance Indicators
Conditional colours and arrows automatically highlighted satisfaction improvement or decline.
Any-Two-Week Comparison
A cross-filtered benchmarking matrix allowed administrators to select and compare any two evaluation periods side by side.
Submission & NPS Correlation
Participation volumes were analyzed alongside satisfaction movement to test whether response volatility influenced results.
Interactive Program Analysis
Filters enabled instant exploration of Walk-In, Scholarship, and H-Scholarship performance without changing formulas.
Standardized Multi-Page Reporting
A clean management interface supported weekly monitoring, operational review, and academic-service assessment.
3.
Business Impact
Active Participants Covered
The platform supported student experience monitoring across a large, diverse program population.
Program Types Unified
Walk-In, Scholarship, and H-Scholarship feedback became available in one reporting environment.
Evaluation Windows Compared Dynamically
Administrators could select any two weeks for direct side-by-side benchmarking.
Core Satisfaction Metrics Automated
NPS, Promoter %, Detractor %, and Passive % were calculated consistently through DAX.
Insight Lag Eliminated
Automated refresh replaced multi-day manual NPS calculation, enabling staff to respond to grievances while issues remained actionable.
Granular Academic Delivery Audits
Leaders gained direct comparison of satisfaction across standard and high-stakes scholarship programs.
Participation Context Added to NPS
Submission volumes and satisfaction scores were evaluated together, producing a more defensible interpretation of brand perception.
Reporting Maintenance Reduced
Automated data preparation, calculations, filters, and visuals replaced repeated formula and pivot-table updates.
Quantification note: The supplied documents did not provide measured percentage, financial, or time-saving outcomes. Quantification is therefore limited to documented participant scale, program coverage, comparison capability, and automated KPI scope.
4.
Solution Architecture
Student Experience & NPS Analytics Architecture
Microsoft Forms / ERPEvaluation Responses
Excel FilesWeekly Feedback Data
Program FoldersWalk-In, Scholarship, H-Scholarship
↓↓↓
Power QueryClean, Normalize, Consolidate
→
Star SchemaEvaluation Data Model
→
DAX MeasuresNPS, Segments, Week Deltas
↓
Power BI Student Experience & NPS Intelligence Suite
Weekly evaluation data is automated from source folders through Power Query and a structured model into interactive NPS reporting.
5.
Data Flow
Microsoft Forms or ERP data flows through Excel evaluation folders, Power Query transformation, and the Power BI semantic and visual layer.
6.
Technology Stack
Power BI DesktopPower BI ServicePower QueryDAXMicrosoft ExcelStar SchemaNet Promoter ScoreWeek-on-Week AnalysisConditional FormattingDynamic SlicersCross-FilteringEvaluation Analytics
7.
Dashboard Gallery
8.
Project Showcase
Live Power BI Dashboard
Replace this placeholder with the public Power BI embed URL after publishing the report.
Video Walkthrough
Replace this generic YouTube URL after publishing the walkthrough.
9.
GitHub Repository
Explore the Student Experience Analytics Project
The repository contains project documentation, dashboard screenshots, Power BI implementation details, and supporting analytical assets.
Explore More Case Studies
Discover more industry transformation and enterprise analytics projects.