Mighty QuinnConsultingMighty Quinn Consulting — home
Insights

Construction · Health & Safety

EHS Reporting

Global environment, health and safety reporting on Azure and Fabric, sliced by global, regional, country and project level.

Duration
< 5 months
Budget
< 50.000 €
Project team
MQC 2 · Client 2

End-of-project survey

This client did not answer our end-of-project survey — so there are no scores to show.

The point

Environment, health and safety is reported upwards — project to country to region to group — and each level had its own numbers, which meant board reporting was an exercise in reconciliation rather than in reading. One set of definitions and one database now serve every level, and safety leads can see a trend before it becomes an incident.

Processes covered

  • EHS incident and metric reporting
  • Global KPI definition and standardisation
  • Project, country, regional and group-level reporting
  • Role-based access to safety data

The brief

  • Visualization of global environment, health and safety data on global, regional, country and project levels
  • Establishment of global EHS standards and KPIs
  • Provisioning of information for future EHS measures based on lagging and leading indicators

The build

  • Setup of a central, global database and dashboards based on Microsoft Azure and Fabric
  • Integration of a sophisticated permissions concept based on Entra groups, to ensure correct visibility of reports and data by user role
  • Automatic synchronization of all data from the global EHS application
Tech stack
  • Power BI
  • Microsoft Fabric
  • Azure SQL
Our part
  • Project Management
  • Business Consulting
  • Requirements Management
  • Conception
  • Development

The good

  • Tight cooperation with the customer's internal IT and communication teams across multiple business units
  • Cross-platform capable, out of authentication
  • High user and management acceptance

The bad

  • Breaking reporting down into multiple levels creates a complex report and permissions structure
  • Organizational changes led to a wide range of changes and additional effort