Kaiser Permanente Deploys Alteryx to Deliver Fast Reporting
Hours vs. Weeks
Hall supports three different teams, each with a different focus. One team works with ideas to help the company innovate, another analyzes social media to improve customer service, and the third handles medical record requests (amongst other operational requests). Hall built custom reports for each of these teams, but running these reports required a couple of weeks to get the data and put the information together using legacy tools. Then he spent another 5-12 hours entering the results into a final report.
Hall had accepted that he would manage this labor-intensive reporting work until he got a request for a massive report with details on every team member, their function, and how they performed against an array of metrics. That additional request added another full week of preparation. Hall decided that he needed a solution to streamline this reporting process.
When Hall needed a solution to help with reporting and social media, he tried Alteryx. He had already used Alteryx for other specific tasks, including doing some data parsing and filtering, so he decided to apply Alteryx to his full reporting function.
Hall applied Alteryx reporting tools to the complete process from input to output and set up self-service apps for his internal teams. He says, “A manager can go in and set the begin date and end date for whatever time they want to see, push the submit button, and out comes the report that they want. They can do it all by themselves.”
The team member report is a huge workflow. But with Alteryx it only takes 30 seconds to run. The workflow has seven different inputs including spreadsheets and other flat files, two database connections, a connection to a SharePoint list, and more. Alteryx puts the data together through one workflow and creates a PDF of the report complete with complex formatting.
Alteryx has given Hall hours back to his workday. He can empower the teams that rely on him for reports to use self-service analytics, and use his time instead to focus on higher-value social analytics.
An example Hall shares is the quality assurance process for disability requests. One staff member handles the whole quality assurance (QA) process for the team that processes disability requests. Hall built a workflow that cut the time in half to pull up the cases that she needs to QA. Now, the staffer can hit the start date and end date for whatever time period of cases she wants to QA, and then all the cases come up. The workflow saves her time to get to her QA process faster.
Hall used to spend weeks working on reports that had to be repeated and run on a regular basis. Those reports now run in seconds and with no risk of manual error. He says, “I cannot tell you how good it feels to hit that little green arrow. No errors and the report’s done.”
I Also Do Consulting On All Data Matters
Should you feel your in-house team needs some advice, guidance or someone to take control and manage the process for you feel free to schedule a free digital appointment to discuss the way forward.