It would be interesting to see all the permutations but here's my entry. I'm just getting back into alteryx after maybe 8 years working with pentaho (not bad but lacking features). The challenge was the data source - https://github.com/CSSEGISandData/COVID-19 - which was cumulative and the daily numbers are much more interesting. After refreshing my alteryx knowledge I found Multi-row formula which replaced 3-4 steps.
Step 1 - get the data from github.
Step 2 - combine all 5 files, columns to rows, sort and create daily counts
I've done this now in Power Query, Pentaho and Alteryx. For me, the latter is the most elegant with Power Query (m-code) a very close second place.
Now on to the fun part - visuals. Maybe tableau this time.
