Analytics anyone can use.
Data prep anyone can use.
Analytics for organizations.
Cloud analytics for organizations
Editor’s note: Today’s post comes from Joshua Milligan, Tableau Zen Master, Principal Consultant at Teknion Data Solutions, and author of the VizPainter blog. Joshua participated in the pre-release program for Tableau Prep (previously known as Project Maestro).
I started my career at Teknion Data Solutions as a software developer. After a few years, I transitioned to Business Intelligence doing data modeling and ETL work. I liked working with data, but I found much of the process of building out ETL packages to be fairly tedious and time-consuming. And testing could be a nightmare! After hours of development and more hours running a process, I might find that half the values were missing or wrong. Then, I’d have to track down the point of failure, hopefully fix it, and test again. Please don’t misunderstand; I loved helping my clients and it wasn’t a bad way to make a living. But then I discovered something that changed my world.
That something was Tableau.
Tableau was magical! Here was an application that was seamless, transparent, and intuitive. I could drag and drop fields of data and instantly see visual results. I could ask questions, get immediate answers that would raise new and deeper questions and then quickly find answers to those. And it didn’t just change my world—it allowed me to serve my clients better and drive deeper insights much more quickly.
But it didn’t entirely eliminate the need for structuring the data. Certain types of analysis require certain types of data structures. “From now on, let other team-members build those structures!” I thought. I was hooked on Tableau and visual analytics and wouldn’t do much structuring of data outside the Tableau data connection screen again. Or so I thought.
Here’s a secret: the magic of Tableau isn’t features. I get as excited as anyone about the newest version of Tableau and the latest features. But in itself, that’s not the magic. The magic is that all the features work together in a seamless paradigm. The magic, in one word, is flow!
Flow means that I can focus on a task or question and work towards a solution or answer without breaking my train of thought. I don’t have to leave the application to complete a certain step. I don’t have to wait so long between actions that I’ve forgotten what I was doing. Instead, I get instant feedback and iterating through various options is quick and easy.
Here’s another secret: Tableau Prep has the same magic!
I started using Tableau Prep (previously Project Maestro) in the first alpha release. At that point, the fundamental engine was in place but the interface was not very fleshed out. My experience would be different today, but with that first iteration UI, it took me a while to really grasp the paradigm of Tableau Prep. Then, after a bit of little trial and error, everything suddenly clicked!
And at that point, I fell in love with Tableau Prep as much as I had with Tableau. Just like other Tableau products, Tableau Prep is hands-on with the data. It has flow:
After discovering Tableau Prep’s paradigm, I was excited to take some recent real-world data challenges I’d faced and tackle them with Tableau Prep.
In one such case a client had some data in SQL Server for employee airline travel. But one particular airline used a different booking system, so periodic files were dumped in a directory. Additionally, the client wanted to see one of those amazing flight path maps in Tableau—which is great! Except that I knew it would require an additional source of geocoded data and a restructuring of the data to separate origins and destinations into separate records to visualize them using the Path shelf in Tableau.
Creating the flow was, just like using Tableau, incredibly fun! In fact, I had so much fun, I thought I’d share my experience building a similar flow here:
I could bring in the data and then focus on one step at a time:
At the end I had a very useable data set in Tableau where I could analyze employee airline travel and help the client make decisions about cost savings, travel patterns, airlines, when to purchase, and even create the flight path map:
I’m excited to start using Tableau Prep in production. And while I can’t wait to see what new features come with each new release, the magic is already there!