Leveraging Alteryx Designer Against VA Health Connect Data
Last updated
Share PrintFor VA, the Veterans Experience is at the heart of our mission. Finding innovative ways to improve upon their experience is key in providing high quality care, increasing the Veterans accessibility to services, and continuity of care. How can we provide higher quality care? How do we increase accessibility to care? These are often questions asked. Their answers become new solutions. For contact centers, it often involves increasing efficiency and improving effectiveness. This practice started off as spreadsheet-based, however, that can be problematic and time-consuming depending on the collected data. Alteryx Designer and Alteryx Intelligence Suite leverages the data from multiple sources to quickly develop tools that can be uploaded into Alteryx Auto Insights, that produces an easy to interpret dashboard. While this practice looks at call center data, the applications for this practice can be applied at any level within VA.
Origin:
May 2022, VISN 10 VA Health Connect Clinical Contact Center
Adoptions:
1 unsuccessful
Recent Updates
Overview
The problem
The VA Health Connect Clinical Contact Center (VA Health Connect) was a VA initiative in 2021 designed to provide greater access to care for Veterans. This practice resulted from a question asked by my supervisor, while working for the VISN 10 VA Health Connect. His intent was to identify new metrics capable of improving the efficiency, effectiveness, and qu
...
The VA Health Connect Clinical Contact Center (VA Health Connect) was a VA initiative in 2021 designed to provide greater access to care for Veterans. This practice resulted from a question asked by my supervisor, while working for the VISN 10 VA Health Connect. His intent was to identify new metrics capable of improving the efficiency, effectiveness, and quality of service provided to Veterans that called the VISN 10 VA Health Connect. To accomplish this, he wanted to identify new metrics based on correlations between the Agents dataset and the Telephone Ques dataset. The end goal was to improve the Veterans Experience by decreasing hold times and reducing calls abandoned. His question was, how could I effectively accomplish this end goal? Using data to build tools becomes part of the solution. Yet in this case, the time it takes to build a tool was also part of the problem.
See
more
The solution
Initially, this process took 4 months from identifying the necessary data to having it ready to be imported into a data visualization tool, like Microsoft Power BI. In October 2022, this practice started being built out in Alteryx Designer, a drag-n-drop, no code data analytics solution designed to build workflows quickly and easily. What had originally take
...
Initially, this process took 4 months from identifying the necessary data to having it ready to be imported into a data visualization tool, like Microsoft Power BI. In October 2022, this practice started being built out in Alteryx Designer, a drag-n-drop, no code data analytics solution designed to build workflows quickly and easily. What had originally taken 4 months to get ready for a data visualizations solution had only taken 40 hours with assistance from the Alteryx Support Team in Alteryx Designer. In this practice’s case, Alteryx Designer was being used to leverage call center data. Alteryx Designer is only one half of the solution. The other half of the solution is Alteryx Auto Insights. The Alteryx Designer workflow is uploaded into Alteryx Auto Insights generating an easy-to-understand dashboard allowing stakeholders, decision-makers, leadership, and end-users to quickly interpret the story the data is telling.
See
more
Images
Above:
Screenshot of VISN 10 VA Health Connect Workflow in Alteryx Designer
Files
- This document provides a brief introduction to Alteryx Designer and Alteryx Auto Insights. What is Alteryx Designer and Alteryx Auto Insights?
- A copy of the implementation timeline that ca be saved Practice Implementation Timeline
The results
In-progress
Diffusion tracker
Does not include Clinical Resource Hubs (CRH)
Multimedia
Images
Above:
VA Health Connect Clinical Contact Center Core Services
Videos
Above:
Brief Introduction to Alteryx Designer
Above:
This video is a brief introduction to Alteryx Auto Insights. I will be demonstrating some of the features of Alteryx Auto Insights.
Implementation
Timeline
-
Step 1: Pre-Implementation (Note: Time it takes to complete this step may vary.)
1. Hire/Assign (1 FTE, 40 hours per week) Program Analyst/Data Analyst.2. Assign laptop/desktop and all necessary accesses (i.e., specific CDW dataset,shared drives, etc.). -
Step 2: First 30 Days of Practice Implementation (Roughly 90% of Implementation)
1. Purchase applications and licenses (approx. 14 days):Alteryx Designer license (approx. $5,000 per license for 1 year)Alteryx Intelligence Suite license (approx. $2,500 per license for 1 year)Alteryx Auto Insights (approx. $150,000 includes: setup support and 300licenses)2. Training on Alteryx Designer through Alteryx Academy, Alteryx Support Team, andPractice Team3. Start setting up Alteryx Auto Insights once purchased. Requires support from OITand the Alteryx Auto Insights Support Team. -
Step 3: After first 30 days of Practice Implementation
1. Alteryx Auto Insights test environment setup and testing begins.2. Alteryx Auto Insights goes into production.3. Alteryx Auto Insights licenses assigned (Licenses include both Creator and End-user).Notes:1) Longest part of implementation is getting Alteryx Auto Insights setup and put intoproduction.2) Time may vary from setup to production. -
Step 4: Post-Implementation
1. Continue training on Alteryx Designer/Alteryx Intelligence Suite (AIS) using variousresources (i.e., Alteryx Academy, Alteryx Community, building workflows in AlteryxDesigner, etc.)2. Train supervisors/end-users of practice on the Auto Insights dashboard.3. Provide support for Auto Insights as needed.4. Develop new workflows as needed
Departments
- Information technology
Core Resources
| Resource type | Resource description |
|---|---|
PEOPLE |
|
TOOLS |
|
Files
- The Core Resources are the minimum requirements for successful implementation of this practice. Core Resources
Optional Resources
| Resource type | Resource description |
|---|---|
PEOPLE |
|
TOOLS |
|
Files
- The Optional Resources are addition to the Core Resources that will make the organization more successful with implementation. Optional Resources
Support Resources
| Resource type | Resource description |
|---|---|
PEOPLE |
|
About
Origin story
This practice started out, like many others, with a question. In May 2022, my supervisor, Matt Root, at VISN 10 VA Health Connect mentioned how he would like to be able to compare different metrics between the Agents data and the Ques data. After finding two reports that potentially could work, the tedious process of collecting, preparing, and formatting the
...
This practice started out, like many others, with a question. In May 2022, my supervisor, Matt Root, at VISN 10 VA Health Connect mentioned how he would like to be able to compare different metrics between the Agents data and the Ques data. After finding two reports that potentially could work, the tedious process of collecting, preparing, and formatting the data began using Microsoft (MS) Excel. Fast forward four months, the data was ready to be analyzed and turned into visualizations. Late September 2022, I had a meeting with David Martin and Roger Shiltz from Alteryx. They demonstrated Alteryx Designer, a drag-n-drop, no code, analytics application with a lot of possibilities and potential. Two weeks later, I started building a workflow using the data I had collected. By the end of October 2022, with a lot of assistance from Roger Shiltz from Alteryx, what took 4 months in MS Excel we had completed in 40+ hours. The first time we ran the workflow it took 1 minute and 30 seconds to run. The second it finished running in 45 seconds. The next step for this practice is to connect several workflows to Alteryx Auto Insights, which will go through the workflow data and display a user-friendly dashboard identifying various metrics.
Original team
Joseph R Johnson IV, (Joseph.Johnson31@va.gov)
Program Analyst (Informatics), Practice Lead
Spencer Schaefer, (richard.schaefer@va.gov)
Kansas City VAMC Chief Health Informatics Officer (CHIO)
Matthew D. Root, (matthew.root@va.gov)
VISN 10 VA Health Connect Clinical Contact Center Management & Program Analyst Supervisor
Matthew Collins (matthew.collins5@va.gov)
Contractor, Liberty IT Solutions, LLC
Angela Gant-Curtis, (Angela.Gant-Curtis@va.gov)
Innovation/Emerging Technologies Director
David Martin, (David.Martin@alteryx.com)
Alteryx, Federal Account Executive
Roger Shiltz, (rshiltz@alteryx.com)
Alteryx, Professional Sales Engineer
Klebson Silva, (Klebson.silva@alteryx.com)
Alteryx, Engineering Manager
Comment
Comments and replies are disabled for retired innovations and non-VA users.