Word clouds with Alteryx and R

In a previous post, I explained how to build word clouds easily with a combination of Alteryx and Tableau. But what happens without Tableau? It turns out that Alteryx can leverage the power of existing R libraries to easily generate pretty nice word clouds too. I realized that potential after completing my previous post, thanks to the great work of Dan Magnus, who posted an Alteryx app you can use for free here, even without Alteryx.

Nevertheless, if you want more control, you should learn how to build your own workflow, and benefit of extensive controls on your output. Continue reading

Posted in Alteryx, Automation | Tagged , , | Leave a comment

Navigating Alteryx Maze of Tools

Alteryx is objectively an amazing tool to manipulate data and models, without coding (much). As I mentioned in earlier posts, that simplicity involves trade offs. One of those is the initial difficulty to apprehend the potential and capabilities of the solution. One can feel lost when facing the sheer number of tools available, 170 and counting, without even mentioning the 3rd party tools. Of course, a new user will start with a set of 10-20 tools, and will expand gradually, as she discovers new tools to address new use cases.

Well the great news is that there is a way to accelerate that process, and therefore the overall ramp up to proficiency. During Inspire 2017, Alteryx annual customer event, a map was released which comes really handy:

It is designed as a periodic table and helps discover tools, based on their popularity (the wisdom of crowds…), their use case or type.

Without further ado, here is the link where to download the full size PDF, at the bottom of the post:
https://community.alteryx.com/t5/Engine-Works-Blog/The-Periodic-Table-of-Alteryx-tools/ba-p/64120

The whole post is well worth a read; the talented creator gives the full story behind the inception and the execution…

 

Posted in Alteryx | Leave a comment

Turn text column reviews into a Tableau word cloud

After getting my hands on a data set containing a large number of user reviews in a column, I was trying to get an overall sense of those reviews with a quick glance. Visually, there are several options to get that perspective. We can start by words used ranked by use count:

But it takes way too much of the screen real estate. We could also use a nice tree map, which I am found of:

Nice and thorough, with each box sized in proportion of the use count of the word. Unfortunately, the average consumer of such analysis is struggling to interpret it, as this style of viz is probably not mainstream enough yet. It’s still way better than the dreaded pie chart, which is impossible to consume with more than 3 slices.
I figured this analysis could also be a great opportunity to use a Word Cloud, a fairly recent functionality which came with Tableau 8, which I find more accessible to users:

With one quick glance, one can clearly visualize that those reviews cover a German restaurant in Charlotte, NC, with a fairly positive tone.

Soon after I got started putting together the Word Cloud, I realized that Tableau offered little guidance on that topic. Word Cloud is not found in the Show Me tab for instance. I searched what fellow bloggers had to offer, and easily found some guidance, like here or there. These are all fine posts, with nice visual steps to follow, but they overlook a crucial point: they assume that the data set has already 1 word per column, which is highly unlikely to happen. It turns out that using a data source with sentences instead of single word, is a major road block to the use of Word Clouds in Tableau, as reflected in some help requests in the community. In order to feed Tableau with something workable, it requires to split the words of the reviews column. This operation implies breaking the granularity of the data source, which will expand the number of rows by the number of words found in each review.

There must be ways to code that conversion in Python, R, SQL or even PowerBI DAX. But as often for me, for a clean repeatable solution without dreaded copy + paste, whipped together in 10 minutes, I will use Alteryx!

Continue reading

Posted in Alteryx, Tableau | Tagged , , | 1 Comment

YoY YTD dashboard made easy in Tableau

When using a set of dated transactions which gets updated, how do you provide a report which will track visually a monthly  YoY (Year over Year) YTD (Year to Date) comparison? This needs to work at the day level, to avoid comparing June 1 attainment this year to all of June the year before…

It would be easy to build a table in Excel, massage it until you get a side by side. But then, so much for automation! And it is actually faster to obtain in Tableau, as long as you have the underlying transactions with dates. Yet, in Tableau, it is not as easy as it seems, and there are quite a few people who have been looking into this issue. Since I struggled with table calcs which behave quite finicky for that task, I came up with a solution that will work for any calendar dimension (Day, Week, Month, Quarter). Don’t expect anything revolutionary here, but a nice handy trick, much easier imho to understand and deploy than Tableau’s official guidance.

Continue reading

Posted in Performance, Quick & Dirty, Sales, Tableau | Tagged , , | 1 Comment

Alteryx v11 after 100 days

As far as Alteryx major releases go, V11 was appealing with many feature enhancements, in no particular order:

  • A modern web based job scheduler
  • A modern formula editor, which makes Excel blemish with its autocomplete and data preview window
  • Addition of SAP Hana, Microsoft Azure SQL Database, Microsoft Analytics Platform System, and Netezza as IN-DB connectors. Welcome to the IN-DB club, you will love it!
  • Global Search, which helps finding all relevant information from within Alteryx
  • Data Profiling, which is an odd way to describe the new Browse Tool. Browse has learned new tricks! That page is supposed to describe those, but I suggest you watch the video, the text won’t tell you much.

Using that version of Alteryx for over 100 days now, my experience turns out to be very different than what I was expecting after going over the description of those enhancements. I feel that one of them is a sleeper hit for data analysts.
Continue reading

Posted in Alteryx, User Experience | Tagged | Leave a comment