Senne’s success with incorporating Alteryx into the Talent Plus infrastructure is multifaceted and has reverberated across departments. “We now use Alteryx for all kinds of things. I’ve been using Alteryx as a data integration/data blending tool. We’ve also used Alteryx to help build out our Amazon Redshift data warehouse, which will allow us to more easily scale when we need to. Alteryx is also used to synchronize the data — pulling updated data from our application every hour.”
Senne also noted impressive build speed time during initial data warehouse construction, affirming how Alteryx enables fast, seamless Amazon Redshift performance. “When we found a column that was missing, or a calculation that was not correct, we used Alteryx in-database processing tools. I dropped the whole table and rebuilt 21 million records in 14 minutes. Amazon Redshift is easily 10 to 100 times faster than our MySQL database.”
Ultimately, creating a robust data warehouse has drastically cut down the time necessary for the basic data requests various Talent Plus associates require. Senne explains, “If I run a query for the research team, previously, it would take a couple days to extract all that data. Now that the data is in the data warehouse and they can access it in just an hour, versus a couple of days.”
Senne empowered Talent Plus’ research team to become more self-sufficient by running their own analytic queries, freeing him up for other projects. By creating and sharing an app on the Alteryx Server that’s customized for their specific query needs, the research team can run their own reports and send time-sensitive selection data back to their customers exponentially faster, allowing Talent Plus clients in turn to accelerate their HR processes and obtain the best talent possible. Where applicable, the research team is also now able to use Tableau to quickly extract data straight from Redshift as well for data reporting and visualizations — fluid cross-functionality that simply wasn’t possible before the introduction of Alteryx in the company infrastructure.
Senne and his colleagues also apply the analytic function to other common assessment and reporting tasks. He states, “One of our services, CultureView® (Talent Plus’ proprietary employee engagement tool), is now captured in our legacy transactional database, and we quickly process that data for a client using Alteryx to create a Tableau data extract file for reporting.”
“The engagement surveys vary so much and can contain so many errors that trying to do it before was taking weeks. Now we can conduct this with Alteryx in half a day or less. We’ll manipulate it with Alteryx and send the reports to the client, and then they may say Well, can you change this?, or We want this new report. Even with these additional requests, it can be completed in half a day using Alteryx where previously it would take days or weeks in Excel. Our customers are receiving better data, customized to what they need rather than a standard report. We can customize or tailor to how they want to see information.”
Finally, Senne attests that Alteryx is encouraging innovation throughout departments as he is able to empower other associates to experiment and perform more self-service data analytics with the leading platform’s intuitive user interface. With newfound data flexibility, he also now exports data quickly to multiple formats for both coworkers and clients to manipulate, from Tableau and SPSS to SAS and Excel.
Center for American Progress. “There Are Significant Business Costs to Replacing Employees.”