Engine Works

Alteryx Workflow Governance: What Are Your Best Practices?

As the population of Alteryx users grows, one topic becomes increasingly important: how are we ensuring that usage of Alteryx is well controlled and governed?

Alteryx + Snowflake = Mind-blown Speeds!

Are your UPSERTs into Snowflake using the Output tool taking too long? This blog shares with you all how you can utilise what Snowflake provides and what Alteryx provides to give y...

The Ins and Outs of In-Database, Starting with Snowflake

Sometimes it pays to be pushy. By “pushy” in this case I mean pushdown optimization, which is admittedly less catchy but still very cool.

The Secret Recipe to Organize a Server

After installing my server, I have to organize it so that it can host workflows and users. I also want it to be secure but adaptable to cross-functional projects without coming bac...

Embedding a Mission in Your Re-Occurring Process

Does easy and repeatable reporting feel like an impossible mission at your company? Before you say “Mission Impossible!” let me introduce you to the Missions feature of Auto Insigh...

10 Alteryx Tips and Best Practices

So, I have been an Alteryx user for more than three years now, and part of my job is helping others in their Alteryx journey (which I absolutely love). So here is my list of 10 tip...

Fixing Macros and Analytic Apps Using Debug Mode

Building Analytic Apps and Macros within Alteryx can be very exciting, but it can also present error messages that are hard to troubleshoot. Within this article, I would like to de...

Exploratory Data Analysis in Alteryx

The data is not always (almost never) perfect, so it is necessary to verify its quality. This article will cover the various tools and methods that can be used for EDA in Alteryx.

How to Reduce the Size of an Alteryx Data Set

This post will share two tips to reduce the size of your Alteryx output and increase the speed of data loading in BI applications.

How to Generate and Format Totals and Subtotals

Overview of the main techniques for creating the different types of vertical or horizontal, totals or subtotals, and how to format them.

Alteryx Architectures - Workload Management

Ensure Alteryx Server environments are able to process incoming workloads efficiently.

Alteryx Analytic Apps Introduction and Deep Dive Series: Par...

Time to create an analytical app!

DateTime Functions Cheat Sheet

In an effort to help those drowning in datetime waters, I did my best to make a concise overview of the datetime functions that Alteryx offers and try to get you going in the world...

Alteryx Multi-Threaded Processing (AMP)

Created with Pablo https://pablo.buffer.com/ Learn the basics of the Alteryx Multi-Threaded Processing (AMP) Engine.

Make Your Workflow Visually Impactful - Part 3: Visual Effec...

Part 3 focuses on adding visual effects that make your workflow look more attractive.

Make Your Workflow Visually Impactful - Part 2: Your Workflo...

Part 2 focuses on preparing your workflow to make it clean, clear and easily understandable.

Make Your Workflow Visually Impactful - Part 1: Your Prepara...

A messy workflow can negatively impact your purpose and your contribution, so focus on preparing your message, your priorities and identify the value for your audience.

Activate Your New Alteryx Licenses

To experience the thrill of solving, here's what to do after you install Designer.

Accepted Solution Deep Dive – to RegEx or Not to RegEx

Top Alteryx ACE Mark Frisch walks you through a text parsing problem that will teach you how to fish.

Starting the Conversation Around Workflow and Process Standa...

Not sure where to start with your Alteryx implementation? Here. You can start here.

How To Rapidly Retrieve Data From Large Data Sets Using Alte...

You've just been given a data set with billions of records; you need to quickly retrieve certain segments of that data; and you need to do this type of data retrieval many times in...

This Feature That You Didn't Know About Will Change Your Lif...

Working horizontally, is not the best way to travel in Alteryx. It’s like horizontal running in real life. It just isn’t as effective…

The Symbiotic Relationship between the CDO and CAO

Symbiosis means “interaction between two different organisms living in close physical association, typically to the advantage of both;” a mutually beneficial relationship between p...

5 MORE Useful Design Patterns in Alteryx You Need to Master

Holy Smokes!? What a nice surprise to have such a positive response to my previous blog post 5 Useful Design Patterns in Alteryx You Need to Master. I had so many positive response...

Beyond Single-Pass Analytics – What Changes With Scale

Hadoop Performance Considerations

Alteryx can work with data in Hadoop in multiple ways, including HDFS, Hive, Impala, and Spark. Many of these offer multiple configuration options. The goal of this article is to p...

5 Useful Design Patterns in Alteryx You Need to Master

In this post I will share with you five useful design patterns that will help you build out your tool box so that you can shorten the amount of time it takes to provide valuable so...

Alteryx as a Common Language Across the Enterprise

Many customers strive to create a culture of analytics at their organization. Part of this process is designing a system that allows different users to collaborate in one single pl...

A Cookout With Friends Leads to the Grocery Store

I don’t want to help you ‘establish’ a culture of analytics. I want to help ‘refine’ your culture. Together, let’s make it better.

Solutions, Delusions, and the Infinite Laser Quest