Problem: SHR was challenged with ever increasing Patient expectations related to hygiene and quality. Regulators were intervening often to ensure compliance with standards of care. SHR has an Environment Hygiene Quality Audit program that gathers cleanliness data by Fluorescent Marking, Visual Assessment, ATP Monitoring, Patient Survey and Process Observation. All of this data is collected for every healthcare unit, room, piece of equipment and washroom across the region of Saskatoon. When we were engaged, their process was manual. Data was collected and stored in a massive spreadsheet on a daily basis. Since the volume of data is so large, and there were no diagnostic analytics tools available to convert the spreadsheet into useful reports. Hospital Management was not able to analyze their hygienic and quality standards effectively. The inefficient system was producing a high amount of pressure from Regulators, and stress on the team at SHR who were responsible for the data collection and reporting.

Solution: Step one was to analyze the business process that was currently taking place and observe the process first hand. This ranged from observing cleaners recording data to staff inputting data into Excel. We put heavy emphasis on understanding their reporting objectives/ requirements and their expected outcomes. Our team had recurring discussions to understand their complex spreadsheets and internal algorithms and calculations that have been built over the years by various people. Our solution was to build a Diagnostic Data Analytics Tool that utilized a smarter algorithm to convert the data into to a much more versatile and comprehensive analytical reporting system. Business leaders are now able to provide any search criteria to generate a quality real time audit report, and even look at specific items in more detail. The reports have been effectively used by hospital management to help them to achieve the standard they have set out for the Quality and Hygiene Audit for 5 hospitals in Saskatoon.

Technology Stack: Microsoft .Net, MVC, SQL Server, Spreadsheet data reader.

Predictive Analysis: In building this solution, the application had to utilize data to anticipate future behavior and figure out unknown outcomes. The SHR solution used predictive analysis to find out the latest trends and predict behaviors.

Prescriptive Analytics: Prescriptive Analytics were used to ensure that data was able to specify a preferred course of action. This type of analytics provides what would be the next action item to achieve a goal or a vision of the organization. It’s mainly used in Employee Performance Management and evaluation systems.