This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Holy Smokes!? What a nice surprise to have such a positive response to my previous blog post 5 Useful Design Patterns in Alteryx You Need to Master. I had so many positive responses, both online and offline, around how users either had never really thought about Alteryx in this way or the fact that these design patterns are so simple and effective. The overwhelming request that came out from those conversations was that they wanted to see more and since I am not one to want to disturb the Alteryx Force, I will comply.
Working in finance, I’m somewhat bummed that I don’t often get to explore the possibilities within location-based data. That’s why I was thrilled when a project fell into my lap to visually analyze taxes paid across German villages.