Engine Works

Saving Time With Advanced Excel Outputs

In this article, I want to share with you an Alteryx method to solve a common time suck when it comes to Excel reporting.

Reporting in Alteryx: Generating a PowerPoint With a Graph

Did you know you can output PowerPoints in Alteryx? Let's take a look at how to do this with the Reporting tools!

How to Create Merged Cells in Reports Part 3

So you have finally decided to create a report with both merged row cells and merged column cells! Brave.

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...

Will's Weekly Wonders - WhatsApp Analyser

Ever wanted to know how you can analyse your data from WhatsApp? Then read on, as I show you how you can use Alteryx to analyse your WhatsApp data and how you can apply some new le...

The Blob: Reporting That Isn’t From a Horror Film

Much like their Hollywood counterpart, the Blob tools are simply “Indescribable… Indestructible… Nothing can stop it!” Read on to see how they can be used to easily format output f...

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.

3 Tools to Start and End Every Workflow

I’d like to share three tools that start and end every Alteryx workflow I build to drive consistency and optimization.

Non-Regression Tests

Learn how to check equivalence between two tables across all rows and columns.

Update SharePoint Drop Down Lists Using Alteryx Tools

Over the last few months I've been working to automate a process that was slow and fraught with error. So, it's getting a makeover using Alteryx.

What Are Reference Shortcuts? (And Why You Should Be Using T...

Reference Shortcuts are a hidden gem in Alteryx.

Four Methods to Consolidate Files

Going far in the automation of loading often raises small problems. Here are the 4 methods to manage EVERYTHING. From the simplest to the most powerful.

How to Cancel Manual Jobs in Alteryx Server

Cancel manual jobs in Alteryx Server using a workflow.

Creating a Custom SQL Query Builder App

How to create a Custom SQL Query Builder App and some suggestions for customizing it for your own database querying uses!

Use Alteryx to Turn Video Captions Into Readable Text!

Transcription is now a great feature of Microsoft Stream. With Alteryx, you can convert the transcription into readable text in one click!

Alteryx Multi-Threaded Processing (AMP)

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

7 Alteryx Best Practices to Simplify Your Life

Use these strategies to reduce re-work, confusion, and speed up your development time.

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

Start with the data.

what3words in Alteryx

This post highlights how we can develop our own what3words database using Alteryx, not because we want to rip it off, but because it highlights a couple of analytical techniques wh...

How to Access Snowflake in Your Hosted Designer Trial

If you’re excited to try out an Alteryx Designer hosted trial with your existing Snowflake instance, follow the instructions in this article.

Sporting Predictions - How I Predicted the Results of Footba...

Read on to see if I successfully predicted all of Reading's final games in the season.

Applying Circular References and Speeding Up a Macro

Learn how to deal with circular references in a tax case, and using the Binary search approach to speed up your macro.

Building Bingo Tickets with Alteryx

Alteryx ACE Ben Moss highlights how to use the Optimization tool to build out bingo cards, which it seems is an advanced data challenge!

Starting the Conversation Around Workflow and Process Standa...

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

Pass Go, Faster: What’s the quickest way 'round the Monopoly...

In this blog, we look at how Gwilym could have used Alteryx to optimise his route planning to visit all the locations on the London Monopoly using a few different optimisation stra...

You're Creating Algorithms with Alteryx

Just take the Cache and Run! Caching in 2018.3

As we develop workflows, it is inevitable that we will need to make additional modifications downstream of our data. To see the updates, we need to run the workflow. Depending on t...

REST API In 5 Minutes-No Coding

Set your timer…

Have you tried the Alteryx Weekly Exercise?

The weekly exercises we are posting provide a great way for users to cross train and collaborate on different way to solve problems.