Engine Works

So, you are new to Alteryx and you find an administrator version, non-administrator, licenses, predictive tools ...

The Alteryx engine was fast. Why does it need to be faster?

For our final Decision Modeling project, my team and I set out to construct a model that would help one of my group member’s companies assign office attendance by employee number. The resulting analytic application, built in Alteryx, allowed for dynamic inputs to achieve dynamic results. In a real-world application, the creator of the Alteryx workflow and analytic app could then seamlessly share it across the enterprise or automate the output to notify employees of their office assignments. In this use case, we used the basic capabilities of Alteryx Designer to apply business logic to an analytical process.

Some finance processes in the tax world require you to monitor the balance of various accounts over time. The problem is, just like your personal bank account there isn’t always a change in balance every day. Meaning if you were to plot this data on a graph there would be gaps in the information for which there was no change. The way to solve this in Alteryx comes in two steps, first we need to identify exactly what dates are missing data and create rows for them in our dataset. Then we need to run calculations on this data to determine what the balance should be on the days that had no change.

The Johns Hopkins University Center for Systems Science and Engineering has released the data they use to power their 2019 Novel Coronavirus Visual Dashboard. Since I was curious in exploring that underlying data to better understand the spread of the COVID-19 virus and seeing how Alteryx might be used to analyze that data for predictive purposes, I made a workflow to do just that.

This video is for all of you in the audience in Sydney that couldn't take notes fast enough to jot down every single tip. And it's for everyone else, too.