Optimizing Snowflake Costs For Alteryx Users: 5 Essential Tips
Combining Alteryx and the Snowflake Data Cloud is a match made in data heaven. Alteryx provides an intuitive, low-code platform for data integration and transformation, while Snowflake delivers a powerful processing engine and storage layer for your consumer applications. However, while Alteryx has a fixed cost, Snowflake operates on a pay-as-you-go model. To maximize the […]
What is phData’s Alteryx Server Reporting & Monitoring Tool?
Alteryx Server has always been a powerful and key aspect of any company’s investment in the Alteryx platform. It capitalizes on functionality around sharing, scheduling, and governance capabilities. However, leveraging Alteryx Server to its fullest potential is a daunting task, even for those with years of experience. The challenges of managing and monitoring the usage […]
How Interface Tools Helped Me Be a One-Stop Alteryx Shop
Before I started at phData, I was a one-stop Alteryx shop: product owner, training and enablement, licensing, and server administration. It was a blast having Alteryx as such a key component of my day-to-day, but it wasn’t my only responsibility. The rest of my team and I were also doing all of that for a massive Tableau […]
Tableau Prep vs. Alteryx Designer: Basic Data Preparation – Part 2: Data Cleansing
If you missed Part 1, start here! Though Tableau Prep and Alteryx have some differences in breadth and depth of product functionality, many look to the two products for their data prep needs. For that reason, for the next few weeks, let’s compare and contrast the products from the perspective of data prep alone. In my […]
Tableau Prep vs. Alteryx Designer: Basic Data Preparation – Part 1: Input and Data Investigation
Tableau Prep and Alteryx Designer are key players on the data prep market. Tableau Prep is a more recent release that is now packaged with the Tableau Creator license. It is used for basic data prep and cleanse. Alteryx Designer is Alteryx’s flagship product that can be used for basic-to-advanced data prep and more advance […]
Tableau Prep vs. Alteryx Designer: Basic Data Preparation – Part 3: Joining, Transformation, and Output
This is Part 3, consider starting at Part 1! Though Tableau Prep and Alteryx have some differences in breadth and depth of product functionality, many look to the two products for their data prep needs. For that reason, for the next few weeks, let’s compare and contrast the products from the perspective of data prep alone. […]
So You Want to Build Alteryx Macros (Part 4)
This is Part 4 of a four-part series covering macros in Alteryx. In this post, I will walk you through how to build an iterative macro in Alteryx. An iterative macro runs through every record passed into it and then loops those records back through the workflow. This process continues until either a set number of iterations or […]
So You Want to Build Alteryx Macros (Part 3)
This is Part 3 of a four-part series covering macros in Alteryx. In this post, I will walk you through how to build a batch macro in Alteryx. A batch macro runs once for each record or group of records that are fed into the macro. If you’re familiar with programming, batch macros are similar to for […]
Building a Drop Down Select Tool in Alteryx: Analytical Applications for Dynamic Data Input
Often when building an analytical application in Alteryx, I have to consider that my users will be uploading information that includes different header (i.e. field names). Some of the information in their data may be applicable to my tools, and some information may not be. Therefore, I needed a way for the users to specify […]
Changing Spatial Projections in Alteryx & Tableau
I think it is safe to say that most people are familiar with maps. Today, with a smart phone in nearly everybody’s pocket, the use of GPS tools like Google Maps or Apple Maps is ubiquitous. We use these tools for navigation, finding a new restaurant, searching for a new home, and so much more. […]