For companies subject to environmental, health, and safety regulations, compliance reporting is no small task, and solutions to help manage those tasks are limited. The low-end option—using Excel spreadsheets to track compliance tasks—is cumbersome and presents control problems. The high-end solution—third-party environmental management information system (EMIS) software—can come with unnecessary complexity and high annual-licensing costs.
When a midwestern refinery needed help with compliance tracking, Barr provided a solution that hit the sweet spot: a customized task management system using Microsoft Power Automate (Flow), Power BI, and SharePoint. The all-encompassing, cost-effective program tracks all types of federal, state, and local compliance data (e.g., Coast Guard, OSHA, EPA, DOT pipeline,) for several terminals in two states. Because the refinery was already using Microsoft Power Suite, the integration solution had the benefit of being both economical and familiar to users.
Key features to make work easier include dashboards, exportable reports, and email notifications and reminders for completing tasks. The easy-to-use system provides:
- Live insights into task compliance and performance via a comprehensive Power BI dashboard
- Compatibility with existing Microsoft systems and infrastructure
- Varying notification schedules, by individual task or task frequency, with escalation The ability to categorize tasks
- The ability to manage tens of thousands of current and future tasks
- Easy data-export options, including for Excel and PowerPoint
- Accountability and traceability: the ability to see that tasks are completed on time
- Data archiving to assist with audits
To build the system, Barr first reviewed the refinery's existing process and documentation for task management and then developed an inventory of tasks tracked with Excel workbooks. The next steps were data conversion, building and testing the system, and providing support during implementation. For the refinery, moving from spreadsheets to dashboards was a huge step forward in making compliance tracking simpler, more efficient, and more accurate. The timeline for taking that big step? A mere eight weeks.