{"id":13838,"date":"2021-03-12T08:00:31","date_gmt":"2021-03-12T16:00:31","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/fortisalberta\/"},"modified":"2024-10-04T11:17:32","modified_gmt":"2024-10-04T18:17:32","slug":"fortisalberta","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/fortisalberta\/","title":{"rendered":"FortisAlberta wins Canadian Safety Technology Award for Microsoft Power Platform solution"},"content":{"rendered":"
FortisAlberta<\/a> delivers a safe and reliable electricity service to more than 60% of Alberta\u2019s total electricity distribution network, providing power to more than half a million residential, farm and business customers from across central and southern Alberta. Operating in 240 communities with more than 124,000km of power lines, FortisAlberta\u2019s team comprises more than 1,100 Albertans, including 350 first-line workers, all of whom need to be kept safe from preventable injuries.<\/p>\n In this blog post we will learn how employees have said goodbye to the piles of paper that have been traditionally used to document Injury Prevention Plans (IPPs) and transitioned to an electronic replacement built using Microsoft Power Platform. The solution \u2013 utilizing Power Apps, Power BI, Microsoft 365 Graph, and Azure services \u2013 recently won the 2021 Canada\u2019s Safest Employers award for Most Innovative Use of Safety Technology.<\/p>\n The following comment from an Occupational Health and Safety Officer who recently performed a site audit highlights the effectiveness of the solution\u00a0\u2013 \u201cI wish all sites were like this. You guys have everything in place<\/em>.\u201d<\/p>\n <\/p>\n Canada’s Safest Employer Awards | Winners and Finalists 2020<\/em><\/a><\/p>\n With 350 front-line workers working on power lines across the province, injury prevention is an enormous priority. Thus, before any work commences at a site, an Injury Prevention Plan (IPP) must be created to identify the risks and hazards staff need to be aware of and the actions they must take to stay safe on site. This plan must remain dynamic throughout the lifecycle of the site, as any change to the job may inherently carry with it new risks requiring new plans of action.<\/p>\n <\/p>\n Before\u00a0adopting a digital approach, FortisAlberta used a paper-based system to fill out and handle IPPs. Paper-based forms were filled out within 30 days and emailed to the Safety department. Recordings of meetings were taken on a hand-held audio recorder and cross-referenced with the paper forms during random periodic checks or if an incident were to occur. To share the IPPs, photographs or photocopies were taken of the filled-out forms and sent over for Site Auditing, which made it challenging to pull information together quickly for review during team safety meetings.<\/p>\n <\/p>\n The paper-based process caused several challenges:<\/p>\n It\u00a0was clear that there was an opportunity to transition away from paper forms to a digital replacement and that doing so would ease several pain points. Given that the IT leadership at FortisAlberta was already invested in the Microsoft stack, they saw Microsoft Power Platform as a meaningful extension to their existing investments to bring this paper process into the digital world.<\/p>\n To prove the technology could meet the requirements for this use case, FortisAlberta teamed up with their digital partner Fidelity Factory<\/a>, who used the rapid development capabilities of Power Apps to create a quick proof-of-concept. Its successful reception led to an end-to-end solution being built in just two months and, in the fall of 2018, was deployed to a pilot user base of 220 daily users.<\/p>\n The solution has withstood the test of time. During the following spring, medium and high-risk employees, as well as their managers and directors, completed training on the electronic IPP, with each area adopting the app immediately. It has now been in production for over three years and is deployed to over 500 field staff, including lineman, project coordinators and field supervisors, with an average of over 120 IPPs being processed every day.<\/p>\n The new process starts before work commences on a site. Site supervisors create an IPP identifying important information, as well as work hazards and mitigations, via a custom-built .NET application. At the work site, a Power Apps canvas app enables the supervisor to view and edit the relevant IPP for their site. The app, which runs on their personal mobile device, allows them to initiate an audio recording, so that their review of the IPP can be stored as an audio record. Additionally, audio recordings of safety meetings can be taken and associated with the relevant IPPs and are easily accessible to listen to directly from within the app when reviewing an existing IPP.<\/p>\n <\/p>\n The IPP mobile Power Apps canvas application. From left: (1) <\/strong>IPPs are available to select from a searchable list. (2) <\/strong>Once selected, IPPs can be reviewed in their full detail. The central microphone icon can be used to start a recording. (3)<\/strong> The app will save audio using the device\u2019s in-built microphone. (4) <\/strong>Previous recordings are linked to the IPP and available to listen to directly from within the application.<\/em><\/p>\n Some of the key features include:<\/p>\n <\/p>\n Data visualizations in Power BI allows FortisAlberta staff to track trends in their IPP processes. Left<\/strong>: Daily tracker;\u00a0Right<\/strong>: Word cloud picking out key words and phrases commonly mentioned in recordings and safety meetings.<\/em><\/p>\n FortisAlberta and Fidelity Factory utilized Power BI to add a layer of insight into the IPP solution. From their Power BI report, FortisAlberta staff can track how many IPPs are created on a day-to-day basis, providing the ability to instantly notice both short-term and long-term trends in usage. Utilizing the \u2018Word Cloud\u2019 visualization, staff can also identify what kind of actions are most frequently chosen to address hazards associated with workplace tasks.<\/p>\n A weekly tracker also provides quick figures of how many plans, tasks and recordings have been made over the past 7 days, showcasing adoption and engagement.<\/p>\n The IPP app is a mobile-friendly front end for users to connect to multiple services:<\/p>\n <\/p>\n High level solution architecture diagram<\/em><\/p>\n The data in the Azure SQL Database and audio files stored in Azure Blob Storage are then available for FortisAlberta\u2019s back-end teams to access via a .NET application built by FortisAlberta\u2019s pro developers. This completes the cycle of information: HQ\u2019s initial assessments of the hazards and risks entered via the .NET application are instantly available online in the Azure SQL database; the information is immediately accessible from the front line via the Power Apps mobile canvas application; and audio reviews of the IPP are reported back, in real time, to the back-end staff.<\/p>\n Finally, data is then presented back to staff in easy-to-understand visualizations using Power BI. The additional insights from this data can then be fed back into subsequent IPPs, allowing for continuous improvement.<\/p>\n The application has provided huge benefits to FortisAlberta by:<\/p>\n The deployment of the IPP has increased productivity in FortisAlberta by reducing the time spent on double entry, missing paperwork or audio recordings, and other inefficiencies common to paper-based processes. The fact that IPPs can now be completed with accuracy, correctness, and efficiency \u2013 all while being flexible and easy to use while employees are on site \u2013 has allowed FortisAlberta to continue to meet and exceed their Safe Work Planning and Occupational Health & Safety legislative requirements.<\/p>\n After the electronic IPP was implemented, a Wetaskiwin site crew was visited by an Occupational Health & Safety Officer, who was charged with completing an audit on their job site. The Officer focused on the Injury Prevention Plan, specifically inspecting whether the nearest medical facility had been identified, awareness of this site\u2019s location amongst the workers on site, and awareness of who was the person in charge of the site.<\/p>\n The Field Supervisor explained the IPP process to the Officer, detailing how the electronic plan starts life at the office, is revisited on site and then a recording is completed with all the workers. Impressed, the Officer took pictures of the application after his inspection, and commented, \u201cI wish all sites were like this. You guys have everything in place.”<\/em><\/p>\n <\/p>\n Founded in 2011 by Rem Saparco & Sean Panter, Fidelity Factory is an independent firm and Microsoft Gold Partner focused on providing customers simple solutions that address real business opportunities. By leveraging connectors and low code platforms, its team of dedicated and experienced consultants create innovative solutions using Power BI, Power Apps, Power Automate and Power Virtual Agents. Based in Calgary, Fidelity Factory is now expanding across Alberta and British Columbia, with a portfolio of clients spanning a broad spectrum of industries from Technology to Civic Government to Non-Profits and Utilities. Over the years the company has forged lasting relationships with its clients and prides itself in being a reliable and trusted partner.<\/p>\n FortisAlberta delivers safe and reliable electricity service in Canada to more than 60% of Alberta\u2019s total electricity distribution network. In this blog post we learn how they used Microsoft Power Platform to transition from a paper-based process to a digital solution for documenting Injury Prevention Plans (IPPs). The solution recently won the Canada\u2019s Safest Employers award for Most Innovative Use of Safety Technology.<\/p>\n","protected":false},"author":90,"featured_media":13840,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1580,1664],"power-apps-tag":[1581,1670],"coauthors":[2350],"class_list":["post-13838","power-apps","type-power-apps","status-publish","has-post-thumbnail","hentry","power-apps-category-case-studies","power-apps-category-uncategorized","power-apps-tag-customer-story","power-apps-tag-power-bi"],"yoast_head":"\nBusiness scenario<\/h2>\n
<\/h2>\n
Before Microsoft Power Platform<\/h2>\n
\n
<\/h2>\n
Microsoft Power Platform solution<\/h2>\n
Injury Prevention Plan (IPP) tool<\/h3>\n
\n
Power BI reports<\/h3>\n
<\/h2>\n
Solution architecture<\/h2>\n
\n
<\/h2>\n
Summary of impact and benefits<\/h2>\n
\n
Feedback from the field<\/h3>\n
<\/h2>\n
About the partner<\/h2>\n
Related links<\/h2>\n
\n