Alteryx 2021.1 – What’s New?

In this post, we’ll examine some of our favorite features that in the newest release of Alteryx – let’s get into it! Power to the Process in 2021.1 We have our first NEW release of Alteryx in 2021, and everyone at phData (ok, mostly us in Data Processing capability) have been waiting for this. So what […]

Mastering the Network Analysis Tool in Alteryx

Alteryx comes packaged with lots of tools. Although there are over 200 tools to choose from, most users will never need to wander far from the standards: Select, Formula, Join, Summarize, and friends. The great thing about those 200+ tools that Alteryx gives us is that when we do need a specialized tool, it is likely that we have it. Case-in-point: the Network […]

How to Determine the Best Regression Model: 4 Tools in Alteryx

As a data and analytics consultant, I interact with clients from a wide array of backgrounds. Some are highly technical while others wouldn’t know a normal distribution if it bit them on the nose. This is often a good thing in practice, as diverse teams can return more creative ideas than a team that consists […]

The Top 5 Best Alteryx Predictive Tools

Whether you’re combining data sets, cleaning a nasty spreadsheet, or constructing a sophisticated predictive model, Alteryx has great tools to help you out. But with so many options, new or inexperienced users can feel easily overwhelmed. Luckily, this article will outline the top five most helpful predictive analytics tools in Alteryx. It is one thing […]

Alteryx Server Governance: How to Flag and Access Ready to Migrate Workflows

Alteryx Server is a fantastic way to automate Alteryx workflows and collaborate with others. Many organizations choose to do production and pre-production environments of the server, which means a question we often get is how to manage migrating content from one server to another. While manually republishing a workflow between a pre-prod and prod environment […]

Alteryx Server 101: Organizing Content in the Alteryx Gallery

Just got Alteryx Server at your organization? Get ready for some serious time saving when you automate your work! Server is a fantastic product, but the Gallery has a whole language of its own when it comes to ways to publish and organize your flows. In this post, we’ll break down all of those components […]

Making Custom Shapefiles in Alteryx

I recently received a message from my colleague here at phData that contained a screenshot from a tweet that displayed an interesting map of the United States. Disregarding the fact that it looks like the outline of the US is in something like the Albers Equal Area Conic projection but the lines are still “straight,” I wondered: […]

How to Restructure Data in Alteryx: Files With Two Column Headers

As analysts and developers, we don’t always have control over the data we receive and how it is formatted. We still need to do our best to deliver what we can with what we get. Recently I was given the task of creating a Tableau dashboard off of a file that contained column headers split […]

Alteryx Gallery Workflow Credentials

Picture this: your company just got Alteryx Server. You are dazzled by the idea of scheduling your workflows and sharing your analytic apps. You publish your perfectly-working workflow, which utilizes an excel file hosted on a shared drive, to the server and – oh no! If this has happened, it is likely for one of […]

Using the Optimization Tool in Alteryx

As any user can attest, Alteryx is a fantastic and powerful tool. With well over 100 pre-built tools you can quickly and easily clean messy data, perform calculations, or analyze spatial information. Because Alteryx offers so many tools, it is reasonable that some of them will serve a specific niche and are little-known and little-understood. […]