Engine Works Blog

Under the hood of Alteryx: tips, tricks and how-tos.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
Alteryx Partner
Alteryx
Alteryx

Engine Works Blog MBA Project Social banner.png

 

For our final Decision Modeling project, my team and I set out to construct a model that would help one of my group member’s companies assign office attendance by employee number. The resulting analytic application, built in Alteryx, allowed for dynamic inputs to achieve dynamic results. In a real-world application, the creator of the Alteryx workflow and analytic app could then seamlessly share it across the enterprise or automate the output to notify employees of their office assignments. In this use case, we used the basic capabilities of Alteryx Designer to apply business logic to an analytical process.

Read more...

11 - Bolide
11 - Bolide
16 - Nebula
16 - Nebula
16 - Nebula
16 - Nebula
7 - Meteor

BEFORE_AFTER.PNGSome finance processes in the tax world require you to monitor the balance of various accounts over time. The problem is, just like your personal bank account there isn’t always a change in balance every day. Meaning if you were to plot this data on a graph there would be gaps in the information for which there was no change. The way to solve this in Alteryx comes in two steps, first we need to identify exactly what dates are missing data and create rows for them in our dataset. Then we need to run calculations on this data to determine what the balance should be on the days that had no change.

Read more...

Alteryx
Alteryx

JHU_Dashboard_Small.pngThe Johns Hopkins University Center for Systems Science and Engineering has released the data they use to power their 2019 Novel Coronavirus Visual Dashboard. Since I was curious in exploring that underlying data to better understand the spread of the COVID-19 virus and seeing how Alteryx might be used to analyze that data for predictive purposes, I made a workflow to do just that.

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

dude.PNGThis video is for all of you in the audience in Sydney that couldn't take notes fast enough to jot down every single tip. And it's for everyone else, too.

Read more...

Alteryx
Alteryx

FANTASY PREMIER LEAGUE MACROS (1).png

Read more...

Alteryx
Alteryx

CNwe41KWsAA6pE9.jpgIn this article, we’re going to explore how we can leverage Alteryx to run analytics on fishing reports in Southern California. You’ll learn how to use web scraping to pull in data from 976 Tuna, macros to automate the cleansing process, spatial analytics to better understand where the fish are biting, reporting tools to visualize our analysis, and the Alteryx Server to automate this on a weekly basis.

Read more...

Alteryx Community Team
Alteryx Community Team

Joseph Serpis (@JosephSerpis) has a great new post over on Intersections and Overlaps that shows how to use the Blob Input and Output tools to save you time with your Excel template files. Alteryx ACE @patrick_digan has already shown (here) that this novel use of the Blob tools is in fact a great way to move files around in general, perhaps more straightforward and faster to learn that the traditional method of using the Run Command tool.

11 - Bolide
Moderator
Moderator

evaluating.jpg

Is Designer the right tool for you?

Read more...

13 - Pulsar
13 - Pulsar
Alteryx Certified Partner
Alteryx Certified Partner
Alteryx
Alteryx

cake.png

Cakes are like macros - they're delicious and anyone can make them.

Read more...

16 - Nebula
16 - Nebula
Alteryx
Alteryx

ALGORITHMS.png

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

Tips & Tricks from an Alteryx ACE on how to develop Alteryx workflows as quickly as possible.

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

How do you deal with spatial data that is geocoded to one address/location?

Read more...

Moderator
Moderator

we all start somewhere.png

As an experienced Alteryx user, it can be easy to forget that there is a learning curve for many folks just starting out. This article takes a look at a new Designer Cheat Sheet which was created to help new users get started.

Read more...

16 - Nebula
16 - Nebula

A step by step guide to create a simple TOTAL function adding all numerical inputs.

Read more...

5 - Atom

You might want to (or need to) collect, store and process unstructured text items with associated metadata. Examples could be to set up a library for research purposes or to build a tool to watch the public discourse for relevant conversation pieces. This guide will showcase a just-the-basics approach to build one possible implementation of such a tool in Alteryx.

Read more...

Alteryx
Alteryx

The story of the community-driven initiative to create an app that documents the contents of an Alteryx workflow.

Read more...

11 - Bolide
11 - Bolide

PUB.png

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

map.png

Having in-depth demographic information is often seen as the holy grail in the eyes of data analysts and their business stakeholders, and there is a good reason why: the context that can be added to your analytics, as a result, is hugely advantageous.

Read more...

Alteryx Certified Partner
Alteryx Certified Partner

find_closest.png

I have recently been tinkering with spatial requirements from clients and have found myself inside of a rabbit's hole. The result was the creation of a new macro, Find Closest

Read more...

Labels