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.

Leave a reply

Other recent posts

End of one-size-fits-all data stories

This appeared originally on the TDWI site in September behind a paywall. It’s still there, but today they’ve had the 90 days of exclusive use that I agreed to. Survey after survey reveals that about 80 percent of business users don’t use data analysis—despite all the marketing and “easy to use” tools. As if in… Continue Reading

Qlik finally set to leapfrog Tableau?

Who’s your rival? I carelessly asked a Qlik person at the company’s annual analyst reception Monday night in Miami if she hadn’t once worked for Tableau. Her revulsion was immediate. “No! Never!,” she said. We smiled. There was so much more to talk about. For one thing, how will private equity change things? Qlik wasn’t… Continue Reading

Five Tips for Better Data Stories

Originally published on September 22, 2015 in BI This Week, a TDWI publication. A “data story” sounds like such a great idea. You just mix data with storytelling and you’re done — except that most data storytellers get one thing wrong: they drown out the story with data. Such storytellers, I believe, assume that audiences… Continue Reading

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