Using Power Platform, customised Power BI reporting dashboards enhance visibility across safety and compliance operations in the rail industry. While Power Automate development delivers weekly summaries to management for continuous monitoring and improvement.
Context
A safety compliance rail app, developed by Objective, transforms how frontline teams access, track, and report on critical safety information.
The mobile-first platform enables rail organisations to broadcast safety videos, operational briefings, and compliance documents directly to their workforce via iOS and Android devices. Designed to improve engagement and accountability, the rail app helps train operators ensure all team members receive, acknowledge, and understand vital safety compliance updates.
The Challenge
The rail safety compliance app already offered built-in tracking, allowing administrators to see how many employees had watched or read specific briefings. However, reporting was initially limited to static summaries, making it difficult to identify trends, drill down into user behaviour, or easily demonstrate safety compliance during audits.
The organisation needed a more interactive, data-driven reporting solution to give management teams full visibility over safety communication effectiveness — from overall engagement rates down to individual acknowledgements.
The Solution
Objective implemented Business Intelligence (BI) reporting module using Microsoft Power BI, giving rail operators the tools to analyse and visualise safety data at every level, providing real-time insights into compliance performance and workforce engagement across multiple sites and teams.
The consultancy focused on optimising Azure Data Factory and refining SQL queries to ensure data was seamlessly extracted and transformed for accurate reporting.
The result is a dynamic BI dashboard that allows clients to:
- View briefings issued and completed across any date range, filtered by priority level (high, medium, low).
- Analyse engagement by department or user group, with drill-down capabilities to assess individual compliance.
- Explore content engagement by subject area, helping identify which safety topics require more attention.
- Create customised reports and automated summaries, sent to managers weekly through Power Automate, part of the Power Platform.
For one leading UK rail operator, Objective developed a tailored dashboard that automatically emails compliance summaries each week, highlighting unacknowledged safety briefings, user comments, and key engagement metrics.
The Results & Benefits
- Real-Time Reporting: Power BI dashboards provide instant access to up-to-date safety and compliance data.
- Custom Automation: Weekly Power Automate emails keep management informed without manual effort.
- Granular Insights: Drill-down capability enables detailed analysis of workforce compliance and engagement.
- Expert Development: Objective’s Power Platform and data specialists ensure seamless integration and ongoing optimisation.