Alteryx Inspire 2015: What to Do While You’re in Boston

Data

Alteryx Inspire 2015: What to Do While You’re in Boston

Next week, Alteryx is kicking off their annual Inspire event. We’re excited to be in Boston to talk to people about the amazing things you can do when combining the power of both Alteryx and Tableau.   But, while we’re there, we will definitely be checking out Boston.

So, why not do both? We’ve created a dashboard in Tableau to help us decide where we should go while at the conference. Check it out below or download the attached workbook at the end of this post. There is a map of locations either in the Boston area or near the Alteryx Inspire location. You can click on a location to see what other people have said about it, and you can even see other locations that people are likely to visit after the location you’ve selected.

Click on the image below to view the visualization:

Alteryx Boston Viz

How I Made It …

My favorite thing about using Alteryx and Tableau together is the way they complement each other so seamlessly. I was able to pull data from a web-based API and form it exactly how I wanted it using Alteryx. Then, I was able to explore the data and make it into a sleek interactive dashboard using Tableau.

Getting the Data

First, I had to get the raw data. In this case, I used the FourSquare API, because they’re a bit more open-minded than other location data platforms. And, it just so happens that Alteryx has a pre-made module to download FourSquare data. All I had to do was request a private key and input it into Alteryx. In this case, I had to tweak the macros to perform multiple types of searches, but all it required was right-clicking on the module and making small changes to the macro.

The Word Cloud

The tips from other users comes in as free-form text. To build the word-cloud in Tableau, we had to do a couple of things:

  1. Strip out any punctuation
  2. Make everything lower-case
  3. Convert multiple words in a row to a new row for every word
  4. Remove out any common, useless words (the, they, and, etc.)

The first three steps were accomplished using Alteryx. I used the Regex tool to remove the punctuation.  I used a simple formula to make everything lower-case. I used Alteryx’s Text to Columns tool to accomplish the third step. In this case, I changed the configuration to split to rows instead of columns.

 Text to Columns

Once I had my data set the way that I wanted it, I still needed to remove out any of the common (but useless to me) words. In this type of activity, those are known as “stop words.” I could have removed those in Alteryx, but there’s also an extremely easy way to remove them in Tableau. I googled around until I found a decent list of stop words. Then, I copied them to my clipboard and pasted them directly into Tableau’s Custom Value List filter. This is an under-used method of filtering, but it’s extremely handy. In this case, I checked the Exclude box in Tableau to exclude any of the stop words.

Last step in Tableau

After that, all I had to do was build the dashboard in Tableau, and we all know how easy that is. I won’t personally be at Alteryx Inspire this year, but InterWorks definitely will be. Come by our booth, check out this module in person and talk to some experts. Have fun!

More About the Author

Mat Hughes

Solutions Architecture Director, Americas
Supercharge Your Tableau Dashboard Actions Using IFTTT It’s “Action Month” at Tableau Public. Actions are one of my favorite Tableau features. They allow you to easily create interactive ...
Alteryx Inspire 2015: What to Do While You’re in Boston Next week, Alteryx is kicking off their annual Inspire event. We’re excited to be in Boston to talk to people about the amazing things ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!