Hand Hygiene Tracking Starter Solution

Overview

This is the hand hygiene tracking starter solution referenced in the Microsoft Health & LIfe Sciences blog post The "Power" Platform in Healthcare: Monitoring Hand Hygiene Adherence. The solution consists of three (3) components:

• A SQL Server database, which can be downloaded here.
• A Microsoft PowerApps, package, which can be downloaded here.
• A Microsoft Power BI report, which can be downloaded here .

Deployment

Deployment of the Hand Hygiene app assumes that you have some experience with managing Microsoft SQL Server , PowerApps , and SQL connections. If you are not familiar with these procedures, please see the guided learning for PowerApps before attempting to deploy the Hand Hygiene starter solution.

Deploy the ClinicalOutcomes Database

The easiest way to get the SQL Server database up and running is to deploy to SQL Azure. You can deploy to on-premises, but you will need to install and configure a gateway. To install the ClinicalOutcomes database, perform the following steps.

1. Download ClinicalOutcomes.bacpac to your local machine from here.
2. Upload the ClinicalOutcomes.bacpac file to Azure Blob Storage.
3. Import the ClinicalOutcomes.bacpac blob into Azure SQL Server.

IMPORTANT! Database Security

A database login named COUser has already been created in the ClinialOutcomes database and has been granted db_datareader and db_datawriter roles. While this enables simple setup and documentation, it is not necessarily the most secure. It is recommended that you examine the database security and tune security and permissions to your organitions specific needs.

NOTE: The password is ClinicalOutcomes2018. It is recommended you change the password immediately after setup by logging into your SQL Server with an account that has appropriate permissions and executing the following command (You can perform this from Azure or SQL Management Studio.

use master
alter login [COUser] with password = "your_new_password"

Deploy the Hand Hygiene Tracking PowerApp

Create the SQL Server Connection

You will need to create a database connection to the ClinicalOutcomes database in order for the Hand Hygiene PowerApp to work properly. Follow the steps provided in the article Connect to SQL Server from PowerApps to create a new SQL database connection in PowerApps.

Import the PowerApp Package.

Once you have created the database connection to the ClinicalOutcomes database, you are ready to import the Hand Hygiene PowerApp into Microsoft PowerApps. Follow the steps in the article Importing an app package to import the Hand Hygiene PowerApps package into your Office 365 environment. You can download the PowerApp package here.

Deploy the Power BI Report

The final (optional, but recommended step) is to deploy the Power BI report. Simply open the report in Microsoft Power BI Desktop or upload the report to Power BI online. Power BI online is recommended, as you can then host the report in Microsoft Teams tabs, modern SharePoint pages, and more.

Misc.

Easter Egg

Pass a query string parameter named debug with a value of 1 to the PowerApp to enable a debug info screen. This screen can be used to clear/reload the cached reference data.

Debug Button

Debug Screen

---