On Saturday, Chas and Ken (Figure 1) got together to learn a little bit about Alteryx and Tableau. We decided to create a video blog of the experience. Included in this article are a series of videos that take you along for the journey of discovery. We decided to process global travel data to show how a complex situation can be turned into beautiful visualizations by using Alteryx and Tableau. We hope you enjoy the show!
Whiteboarding the Problem
Make Travel Data Anonymous
Build Alteryx Workflow
Visualize Results in Tableau
The data we used for this example was transformed in big ways by Alteryx. Figure 2 shows the initial data definition, including the travel itinerary field in column F. This field was parsed using regular expressions and transposed in one operation in Alteryx. This is simply stunning and very efficient.
The Alteryx workflow shown in Figure 3 is what we developed over the course of 2 hours. That fact that this amount of work can be done so easily still amazes me.
The final data set is shown in Figure 3. Notice that the two records shown in Figure 2 now occupy six records. Additional details have been added such as travel path, travel distance along the path and cumulative distance traveled. The 91,000 trips contained in the data expanded to over 300,000 records. It took Alteryx 14 seconds to process that data set, to write an Excel file and a Tableau TDE file. Wow. End of Story.
Part 2 – The Story Behind the Story
Click here to watch Part 2 of this series.