Alteryx has a lot of built in functionality, but the ability to leverage custom R code opens up even more possibilities. After reading an answer on the Alteryx Community many months back, I was inspired to try and integrate Google Charts into an Alteryx workflow by using the R tool.
Most real-world data-science design patterns combine several models to solve a single business problem. This post surveys the most common and effective techniques for combining models. Once you make it through this post (and its predecessors), you'll be ready to take on the design patterns we'll begin learning in 2017.
Cross validation (CV) is a difficult topic. There are many ways to do CV, and articles on the subject can be very technical. This blog post is a gentle introduction to CV. Read it and you'll find it much easier to understand later posts describing data-science design patterns that use CV.
If you’ve arrived on this blog post, odds are you have aided Santa a third time in his trip around the globe in Week 3 of the Santalytics challenge - an inclusive, non-denominational, festive excuse for some friendly competition using Alteryx. You’ve also tackled yet another logistical nightmare for Santa with sheer Alteryx might, and identified opportunities in his data to help make the spirit of giving go even further this year. No doubt an impressive feat, and one that will be rewarded with a timeless Community Cold Weather Kit that will have you prepared to brave the coming winter season in peak fashion. Be warned in advance, you will make a lot of folks jealous this holiday season.
That’s right, we are officially one week closer to Santa’s arrival. If you’re reading this blog post, then you have participated in the second of four exercises that will constitute the Santalytics challenge - an inclusive, non-denominational, festive excuse for some friendly competition using Alteryx. You’ve also solidified your claim as Alteryx pro in your quest to help Santa and acquire timeless Alteryx swag by knocking the dust off of your Spatial Toolset to solve one of the more difficult optimization problems of the year.
If you’re reading this blog post, then you probably participated in the first of four exercises that will constitute the Santalytics challenge - an inclusive, non-denominational, festive excuse for some friendly competition using Alteryx. It also means your spot on Santa’s nice list is secured AND you’re going to be both warm and stylin’ this winter season in your Alteryx swag. That is, if you’ve successfully been able to use Alteryx to improve the elves’ situation from last year...
A customer recently asked how they could read in multiple files all at once from their HDFS server. The answer? Make a Macro! See how it's done and get a few nifty utilities to add to your bag of tricks.
The nature of working in Customer Support is that you’re always talking to people. But whether we're chatting with team members, fulfillment techs, product managers, quality engineers, software developers, solutions consultants, solutions engineers or account managers, the customer is always the center of what we do.
Alteryx isn't just a tool, it's a platform. We'll explore this, Halloween style, using Python in a Jupyter notebook to connect to an Alteryx application that performs demographic clustering for candy sales data.
How does governance work in Alteryx? From data access and data management, to data security, we've got the answers to your most pressing questions on how to best govern your analytic applications in Alteryx.
In the blog, “Top 10 Alteryx Server FAQs”, one of the top frequently asked questions on managing an Alteryx Server, is how to monitor the deployment. Whether it’s to adhere to a data governance program, to track your usage and ROI or how to best optimize your Alteryx Server, administrators need and want monitoring and reporting capabilities. To help with this, we are pleased to announce the availability of a new Alteryx Server Usage Reporting app. This workflow provides valuable data and insights to user access content, scheduled jobs and job analysis information about your server and can be visualized in either a Tableau Workbook or to a set of PDF and Excel files. You can begin your download by going to downloads.alteryx.com
If you haven't had a chance, please checkout the Decision 2016 Presidential Election application. The app predicts who the winning candidate will be within a given U.S. neighborhood, as well as breaks down the outcome by demographics such as age, education, income, and race. Data from SurveyMonkey and the blending, spatial, predictive and Gallery API functions in Alteryx are used to create predictions that are beautifully displayed with help from Carto and Tableau. This post will walk through the architecture that was used to accomplish this.
I share how my knowledge of Excel's VLOOKUP function helped me transition into a user of Alteryx. I provide a quick refresher of VLOOKUP and show how configuring the Find Replace and Join tools perform the same actions as VLOOKUP.
Did you want to enchance your already awesome workflow with a cool interactive visualization that you encountered? In this two part series, I am going to show you how, with a little bit of effort, you can achieve your goal.
Recently we celebrated the launch of our long anticipated Tool Mastery Series, a collective of Knowledge Base articles tasked with communicating the most inspired uses of each Alteryx tool. Check out how we automated all the hard parts and brought the series to life!
Do people regularly send you email attachments that are needed in your analytic workflows? If so, this blog post is for you. The Gmail Attachment Input tool automatically downloads email attachments into your Alteryx workflows. This is done through the use of the Google OAuth Macro and Google Gmail API.
This is an introductory explaination to the Detour tool, the handling of empty fields in Interface tools, and how these two concepts can work together. I show how this is used in a ranking macro I created. Then I provide an overview of rankings and how to use the macro.