Business Intelligence

The entire EHS system that you implement from Pro-Sapien is underpinned by its own data warehouse. This will be on either your SharePoint or Office 365 servers, depending on what you are currently using for other processes.

The data warehouse is where calculations can take place in order to populate your configured dashboards and reports with data from every single module of ours that you have implemented; in other words, you can analyze every piece of information handled by the system – as high level or as granular as you would like.

There can be various dashboards within your EHS system. These can of course be delivered out-of-the-box, but in our experience, clients will always get more value from dashboards that have been configured to deliver your unique KPIs and metrics.

We work with key stakeholders from your company during implementation to map out exactly what you want to get from your BI dashboards. What’s more, the system will use security groups to determine which dashboard should be delivered to which user, so that the Site Manager in Houston will see something different to the VP of EHS in Toronto.

Our dashboards are interactive, meaning you can easily drill down into your data to find the information you’re looking for. For example, if the KPI for Overdue Actions is Red, you can click the chart to see a list of the overdue actions behind the metric.

We strive to make our clients as self-sufficient as they would like to be. Part of this is giving you and your users the ability to create your own reports on an ad-hoc basis.

Leverage the investment your company (and staff) have made in Microsoft by utilizing reporting tools you already have, such as Excel or Power BI. We establish a live link between our system and Excel, so that reports can be created in real-time. The same goes for Power BI, which is an Office 365 tool with an incredibly user-friendly drag and drop interface.

What’s more, you can publish your self-service, real-time reports to colleagues throughout the business with a click of a button. No more clunky attachments to emails getting lost in translation.

You won’t just want to see your KPIs whenever you log into the system – if a certain count or calculation goes over a certain amount (set by you), automated notifications mean you’ll be in the know straight away. For example, if there are more outstanding hazard observations than your goal, the relevant people will get an email requesting action.

We understand that sometimes, nothing beats a hard copy. Our clients can export dashboards and reports into numerous formats such as PDF, Word and PowerPoint – and these can be automatically shared with users weekly, monthly or quarterly.

You may also have the requirement to export information into mandated formats by regulators such as OSHA, which is something that our system supports.

Do you use something other than Microsoft programs to analyze your data? No problem – during implementation we can set up integration with third party systems, such as Tableau, to maintain the status quo.