Today was my first day with Alteryx and honestly, I understand the excitement. Over the past few weeks I have been developing my data preparation skills in Tableau Prep and Power Query, and I genuinely enjoy both. But each has its friction. With Tableau Prep, the biggest pain point is not the tool itself but the fact that it lives separately from Tableau Desktop, meaning you are constantly moving between two environments just to prep and then visualize your data. Power Query has its own version of this with its habit of breaking when you try to undo steps, which can disrupt your flow at the worst moments. Alteryx feels different. Everything lives in one canvas and testing different workflow paths feels natural rather than risky, which is exactly what you want when you are trying to figure out the most efficient way to get from raw data to the output you need.
We worked through three challenges today which I was able to post on the Alteryx Community, linked in the comments on my profile, and I would encourage anyone just getting into Alteryx to try them. I also completed two shorter challenges, #16 and #46, both focused on working with dates. Challenge #46 involved converting an integer field into a proper date format using business logic, specifically determining whether a year should begin with 19 or 20 based on the first character of the string. Challenge #16 focused on parsing out embedded line-feed characters from text data and converting a datetime string into a properly formatted date field. Neither was as complex as the first three but both were worth doing. They helped me get more comfortable with the tools inside Alteryx, which function similarly to steps in Tableau Prep, and reinforced that while Alteryx’s date handling is not as extensive as other prep tools out of the box, the workarounds using formula tools and reporting dates are straightforward once you know them. Overall a great first day. Looking forward to seeing how far this tool can take me.
