Alteryx and Tableau, yin and yang

Many of those who watch the amazing acrobatics in Tableau or other visualization tool find there’s one more spectacle to come: setting up the data — cleaning it, fixing incomplete sets, combining sources, and so on. Only when that’s over can real analysis commence.

Many advanced users still prefer to use a specialized tool for prep. Strong contenders have appeared for graduates of Excel, including Paxata and Trifacta. But it’s Alteryx I finally got a look at not so long ago.

I was curious about Alteryx. It seems to have become the go-to among advanced users of Tableau, which at first seemed odd. To my novice eye, Paxata and Trifacta seem more like Tableau, so why wouldn’t users flock there instead? Based on what I’ve heard from one Tableau super-user I know, Joe Mako, the answer must be in the contrast. Alteryx and Tableau just approach work differently.

Before I talked to Joe, I followed Alteryx chief scientist Dan Putler as he walked through a data analysis challenge. The question: Which of many alumni who have never donated any money are most likely to give some if asked in a new donation drive? A certain public university’s development office would solicit the most likely ones by phone. As if that weren’t enough work, the development staff could make no more than about 10,000 calls per year. Who should they call first? Data on each alumnus included age, area of study, social or familial associations with the university, and a handful of other facts. The answer: the alumnus’s area of study. Putler showed it in a line chart, the results of three of his competing models compared with past experience.

It was an interesting problem, but getting to that answer was most of the fun.

Putler describes Alteryx as a “visual programming framework,” he says, that’s often compared to Visio, the Microsoft diagramming application. Just like in Tableau, its drag and drop interface is friendly to beginners. Unlike Tableau, coding is there for the advanced. A wide range of ready-made possibilities line an upper row of the workspace. Handy documentation has explanations and samples, effective even for those whose ghost-like memory of a statistics class years ago lingers on the edge of awareness.

Also unlike in Tableau, all the details are right out in the open. You see exactly what happens to the data as you do what you will with it.

Putler’s models grow into a diagram that shows exactly what will happen to the data at every step. This is the part of data analysis that resembles detective story, where you sift facts to find the most cogent narrative.

That transparency and control is why Joe Mako prefers Alteryx. Joe is the almost legendary Tableau super-user and volunteer guide. For more than five years, he’s spent hours every week helping even some of the most advanced users figure out how to make Tableau do what they want it to do.

“It’s like having a kitchen,” he says, “and Tableau and Alteryx are your appliances. You can cook without them, but your life in the kitchen is so much better if you have them.” Even better if you use them the way they work best.

“Tableau and Alteryx are wonderful together,” he says. “To me, they’re like yin and yang. They’re both wonderful, but they’re both challenging.”

Tableau’s goal is to make its complexity invisible, which is both good and bad. It powerfully enables the cycle of visual analysis, the uninterrupted flow of questions, insights, and more questions. He says, “No one else comes close.”

But the magic has a flip side. Though the unseen magician almost always guesses correctly what you want to do, it can be fooled by unusually complex work — such as the kind Joe often does. That’s when the magic fails. The computation logic could change without the user’s knowledge or control. A feature known as data densification seems to be one of Joe’s main culprits. (See his video on data densification.)

If Tableau employs an unseen magician, you might say that Alteryx employs a fully visible carpenter. What it does, it does in full view, consistently. Joe says, “It’s the tool you turn to once you need to work with a millions of records and do hard computing and make it a repeatable, self-documenting process instead of a manual, brute-force, hand jammed thing. It lets me codify a thought process.”

Though complex computations can be done without writing code, you can write code if you want to. The user with a sketchy knowledge of some complex predictive logic can open a module with a use case and a description of what it does at input and what comes out on the other end.

Even the icons signify with consistent colors and shapes what each one does. In a series, they reveal at a glance a chain of functions. Joe says, referring to a process he’s constructed, “I see here that I’m pulling the data in, joining it, and I split it out into some groups, and then I put it all back together one piece at a time, precisely how I want it to be pulled back together, and then output it. I get exact control.”

The main downside, he says, is weak interactive visualization. He believes Alteryx simply wasn’t designed for it.

You pick the tool for the job: Tableau to do the visual analysis, and Alteryx to do the tech-side stuff. Joe says, “Together, they’re nirvana.”

One Response to Alteryx and Tableau, yin and yang

  1. Hi Ted,
    I enjoyed reading your article, you seem to have a very strong opinion about Tableau’s “magic” of keeping complexity hidden! I quite like that, and think it plays an important role in Tableau’s beauty! Also, coding is available for the advanced in Tableau, you can write customSQL queries and do XML editing. Finally, I went on to read about data densification, I haven’t run into this problem yet so thanks for sharing.
    Cheers,
    Alexandra

The data industry thrives on conversation. Please submit a comment.

Other recent posts

Bohemian Grove a la BI

The Bohemian Grove of the BI industry convenes for the fifteenth time in just three weeks. Naturally, you ask the obvious question: Are you serious? The Grove? A summit? The answer begins with a fond recollection of the Grove. If you’ve never attended the Bohemian Grove yourself — I haven’t, though I live in the… Continue Reading

Favorite Star Trek, a data story

This story shows how elemental data stories really are. Humans come ready to tell and hear them, requiring no plug-ins at all. This young person can do a good job of it. There was a question, followed by data, then questions and answers, and and finally a conclusion. It’s all there. It’s elementary. Sure, this… Continue Reading

Bad stories stop good data at the water cooler

We agree by now that data’s a good compass. One neglected question is tougher: Which map? Everyone’s known the kind of “grouchy guy” TDWI instructor Kellee M. Franklin, Ph.D tells about. This guy knew better than most of his co-workers about how their Washington, D.C. defense agency worked. And he was frustrated. Over the years,… Continue Reading