BACKGROUND
Can you please provide a brief description of your company and the role that you play there?
My company is called Marquee Crew. I founded it this year to provide professional services in data blending and advanced analytics, primarily through the use of Alteryx. I am the founder of the company.
OPPORTUNITY/CHALLENGE
What was a business challenge your company was facing that incited the need for this platform?
I have a major manufacturer here in Michigan that I met with to discuss some of their logistic planning needs. They're an SAP shop, and they were drawing their data out from their data warehouse and into Access databases, where they were massaging that data and performing their analytics against that data in Excel.
SOLUTION
How does your company implement this platform or software?
In the use case that I worked on with them as a prospect, they had spent more than a month in development of a process that required a senior-level person to execute procedures, and it took roughly three-to-five business days to be able to create their data for analysis. It was highly time-consuming to the person that was actually doing the work, it's vulnerable to errors, and it's not easily transferrable from one person to another. This is the question they wanted to answer with Alteryx: is there something that could make this a repeatable process and, hopefully, make it go faster?
The source of the data was SAP, and they were previously using Microsoft Access and Microsoft Excel. The data needed a lot of touching – copy from one place, create a pivot table, and move the data through the pipe manually.
Was your company considering other platforms? Why this platform?
Another platform they thought about using was SAS Enterprise Miner, but they didn't have the skill set to be able to do that. The infrastructure around the company had suggested that as a potential solution, but the group that was part of this use study saw how intuitive Alteryx was and how it could easily adapt to the problem at hand.
On an annual or monthly basis, how much does your company spend to utilize the platform?
A desktop license is $3,995. If a company were to deploy modules across departments, and have many users feeding off the data and consuming analytics that were created in Alteryx, then they might decide to go for a server version. That version is $45,000, plus there would be some additional licenses for designers, for the people who are creating the modules for others to consume from. To be able to use Alteryx for these solutions, it's very affordable to get one or two people up and running and then to build out the business case to justify the growth of Alteryx.
RESULTS
Can you share any success, metrics, or overall results of your implementation of this platform?
For the use case development, I sat down with the person who constructed the original jobs and, in one day, we went further than he had been able to go in one month. In that one day, we created something that solved the problem, ran for a runtime of seven minutes instead of three to five days, and actually produced more data and higher quality input for the analysis process. Before using Alteryx, if he ran into a record that had a reference for integrity issue, or had any type of an error, he didn't just sum the total quantities up together, he put those into a queue for research later.
He was only able to analyze approximately 80 percent of the available data. In our process together, we put together rules to be able to fix units of measure and other issues in the data, so that almost 100 percent of the data was available for transportation into the analytics.
In the 10 years that I've been using Alteryx, these are the types of stories that come out. This is not an unusual case. Generally, with Alteryx, you're taking processes that were taking hours or days to run, and you're processing them in minutes. At a major marketing service provider not using Alteryx, it would take hours to days to be able to create geographic files that explain to a customer what the three closest stores are, for example. With Alteryx, you can answer those questions in seconds to minutes, depending on how many people you're using.
A marketing service provider had between 100 million and 200 million consumers in their database, and they are able to not only run faster but, now, instead of limiting the stores to three or five, the database could handle up to a dozen store choices. You could take route differences in time, to ask about the drive time distance, instead of geographic distance.
The manufacturer that I spoke to in the first use case gave me another problem, which was being able to audit records that are going through foreign trade, and their current goal is to be able to audit 15 percent of the data. We demonstrated in another use case how that could be 100 percent of the data being virtually audited as opposed to needing to have eyes on each of the audits.
This hasn't been implemented yet, but it can be an automated read of the records that are going to customs. This would enable them to verify those records, and be able to check prices on them for accuracy. If something was being shipped at the wrong rate, it would find errors and reconcile them, and correct the problem before customs and duties were paid.
FEATURES
Were there any software features or tools that really impressed you?
I think the first one is data blending. Some tools have the ability to do things like match on a hard key. If the shipping IDs between two records are identical, they can match these easily. Alteryx provides the ability to be able to match with multiple keys, it has the ability to have fuzzy matches. If you have John Smith at 123 Main Street, and John Smythe at 231 Main Road or Main Street, you wouldn't necessarily be able to use other tools to be able to match those records. Alteryx does have that capability.
Alteryx can access data from a variety of sources. It can work with flat-files like CSV or Excel as well as Databases or even cloud data. Users can also take in data through APIs [application programming interfaces] and off the web. Alteryx can provide flexibility in the data blending, and it can be used not only by IT [information technology] professionals, but by business analysts as well. Alteryx has the same capabilities of some very advanced IT tools.
The second feature is the advanced analytics tool. Alteryx has the native ability to consume analytics that are built in the language of R. R is the language that statistics are being taught with. You can hire interns and first-time job seekers that have a background in R, and they can be put to use in a business practical problem-solving mode with Alteryx.
Also, within Alteryx, you don't need to know how to code in R to use many of these functions like linear regression models, logistic regression models, and market basket analysis. Those have all been packaged into modules within Alteryx that you can call and be able to run those analyses. These tools within the R Toolbox are all there from beginning blending through advanced analytics. It's all there, one single tool to solve all the problems.
Looking back, are there any areas of the software upon which you feel could be added or improved?
They've just recently started connecting into in-database processing. In-database processing allows Alteryx users to be able to run queries, whether it's in Hadoop, Teradata, or Oracle, you can run those processes in the database. This is something that Alteryx has just begun doing. That's where I'd like to see more support built out. You can connect with Spark, but it's not quite fully matured. The tools can be made simpler. I'm hoping that does happen.
They've just recently started connecting into in-database processing. In-database processing allows Alteryx users to be able to run queries, whether it's in Hadoop, Teradata, or Oracle, you can run those processes in the database. This is something that Alteryx has just begun doing. That's where I'd like to see more support built out. You can connect with Spark, but it's not quite fully matured. The tools can be made simpler. I'm hoping that does happen.
Have you had to interact with the platform's support team or reference their support resources?
I've used Alteryx support many times myself. When I come into an area that I haven't used recently or that I struggle with, I either go to the Alteryx community website, ask questions there, and the users and the user community are very quick to answer, or I call up the toll-free number to get Alteryx support and get a ticket opened. Generally, I'm helped in minutes to hours. They're very responsive. If I have a development question, I have a little bit more patience. If I have a production issue, I let them know it's a production emergency, and they're giving me status updates or getting me fixes very quickly.
OVERVIEW
We have a few quick questions and, for each question, we ask you to rate the software on a scale of one to five, with five being the best. What would you give the software for functionality of the features available?
Five.
What would you give the software for ease of use or ease of implementation into your business?
Four and a half.
For support, as in responsiveness of the team or helpfulness of the resources available?
Five.
For overall satisfaction with the platform?
Five.
How likely are you to recommend the software to a colleague or similar business?
Five. Very likely.