National Healthcare Workforce Training & Compliance Intelligence Platform

Centralized LMS 365, Oracle ERP, and departmental training data into an automated SSIS and SQL Server warehouse with a seven-page Power BI suite supporting workforce development, clinical learning, compliance, and executive decision-making.

9,500+ Employees Training Intelligence Healthcare Compliance Centralized SSIS Warehouse Sub-Second Reporting

Business Challenge

A major government hospital corporation needed to manage the complete training lifecycle for more than 9,500 clinical and non-clinical employees, but its existing reporting environment could not scale.

Data Volume Constraints

Direct LMS 365 OData payloads were too large for Power BI to process efficiently, limiting analysis to a single year at a time.

Severe Performance Latency

Simultaneous live connections to LMS, Oracle ERP, and flat files caused long load times, slow analysis, and frequent report crashes.

No Historical Trend Visibility

Year-over-year analysis required manual comparison of separate reports because current and historical data could not be loaded together.

Siloed Divisional Reporting

Academic Affairs, E-Learning, Clinical, and Non-Clinical teams maintained separate views, preventing corporate-wide compliance oversight.

Solution

A governed SSIS and SQL Server enterprise warehouse replaced brittle live-source dependencies with automated, incremental, and performance-optimized analytics.

Strategic Data Governance

Standardized metric definitions, assigned data ownership, and mapped security controls for Oracle ERP data containing PII.

Staging Layer

Extracted LMS OData, Oracle ERP, and shared-folder files into an isolated SQL Server landing schema.

Transformation & Mapping

SSIS cleansed, deduplicated, and mapped Oracle employee master data to LMS training transactions.

Incremental SSIS Loading

Delta logic fetched only new or modified records, bypassing source-volume limitations.

Performance-Optimized Star Schema

Built a central training fact table with conformed employee, date, course, organization, and location dimensions.

Seven-Page Power BI Suite

Advanced DAX supported corporate trends, compliance, clinical learning, non-clinical training, Academic Affairs, and E-Learning.

Centralized Error Handling

Failed source or warehouse tasks generated error files routed to a common troubleshooting destination.

Business Impact

30%

Increase in Actionable Corporate Insights

Millions of training enrollments were consolidated into a trusted enterprise view for leadership.

Sub-Second

Multi-Year Report Loading

Minutes-long loading and frequent crashes were replaced by fast historical reporting.

18%

August Engagement Drop Exposed

Leadership could redesign training deployment schedules around the seasonal decline.

7,782

Employees Tracked for Compliance

Mandatory certification monitoring became available across multiple hospital branches.

97%

Fire & Safety Completion

Fire and Safety Training 2025 achieved a 97% completion rate with a 4.87/5 rating.

56,046

Nursing Enrollments Quantified

Nursing was identified as the highest-volume clinical learning group.

80%

Dental & Allied Health Completion

Both directorates maintained an 80% course completion rate.

329

Internships Quantified

Academic Affairs reporting validated Dental and Nursing internship pipelines and institutional MoUs.

Solution Architecture

The documented five-stage architecture connects LMS 365, Oracle ERP, and departmental files to SSIS orchestration, a SQL Server star schema, KPI engineering, and role-based Power BI reporting.