We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Ted Cuzzillo's BI

Ted Cuzzillo

No wizard, just you and the data

Vote 0 Votes

What's the hardest part of training a new data analyst? Resetting the trainee's mindset.

"They start out with the idea that there's a right answer," says Joe Mako.

Joe's leaving his job — where about one year ago he began analyzing data — to go work for the producer of Lyza. Lyzasoft CEO Scott Davis sees Mako as a "prototype" of a kind of creative, resourceful analyst that Lyza's designed for. Joe will engage with other analysts to evangelize Lyza and to help new users ease into the flow.

Joe, 29 and a veteran of two Army tours in Iraq, started out on the help desk. He answered calls from within the company, an ISP. Many callers couldn't or wouldn't analyze their own data, so Joe did it for them. His boss also enlisted his help and now won't dare go without a backup.

Helping the two women who're replacing him ease into their new jobs is just what Joe's got to do before he starts at Lyzasoft on November 9. They're some of only a few in the his group who applied while most others were repulsed by the "boring" work with "ugly" data.

New users want to know, "Where's my wizard?" he says. "But that's why I enjoy these tools." He uses Lyza and Tableau primarily. "They stay out of my way. They enable me. It's just me and the data. ... That's what's neat, but [new users] don't know where to start."

"I'm handed crazy files without any structure," he says. The first thing they have to know is that, no matter how ugly the data may be, it can be cleaned up. He demonstrated to his new trainees, he says, and "they were blown away." Then he started taking them through the steps.

He explained basic steps and functions. Then he showed them how to combine tools, such as how to use two functions in sequence.

"It takes time playing to figure out where you need to get to," he says. "You have to just go and play. If one thing doesn't work, you try something else."

"I always thought that data was exact," he says. "If not, it was garbage and I'd throw it out." But he found that usually there's only a portion that's garbage — that somewhere within the crazy mess there's a story. "Even if every data point is wrong, there's still some trend you can see. If there's a bunch of ugly data, how do you figure what he story is?" It takes a willingness to figure it out, to untangle it, to find out what's in there.

That's a skill, not a talent, he says. "I've watched them get it closer and closer, learning to merge other data in, to reshape it and finally produce the output."

So business will trudge ahead, training a Joe here and a Joe there until people don't complain anymore about boring work with ugly data. Most people will welcome a chance to try it.

1 Comment

I'd love to get your comments on our product as well - PAW (Processing and Analytics Workbench at http://www.pawanalytics.com). I think that as more computing becomes end-user enabled, tools like Lyzasoft and PAW are likely to become more prevalent. I used to work with analysts and they all like their own desktop tools, rather than needing to wait for IT to get them something.

In this blog, freelance writer and analyst Ted Cuzzillo considers the far end of business intelligence, where technology meets the irregular human profile. With original reporting and analysis, he writes about data analysis and the analysts themselves, as well as a range of other concerns such as perceptions, terminology and personalities.

Recently Commented On

Monthly Archives