Book Image

Data Engineering with Alteryx

By : Paul Houghton
Book Image

Data Engineering with Alteryx

By: Paul Houghton

Overview of this book

Alteryx is a GUI-based development platform for data analytic applications. Data Engineering with Alteryx will help you leverage Alteryx’s code-free aspects which increase development speed while still enabling you to make the most of the code-based skills you have. This book will teach you the principles of DataOps and how they can be used with the Alteryx software stack. You’ll build data pipelines with Alteryx Designer and incorporate the error handling and data validation needed for reliable datasets. Next, you’ll take the data pipeline from raw data, transform it into a robust dataset, and publish it to Alteryx Server following a continuous integration process. By the end of this Alteryx book, you’ll be able to build systems for validating datasets, monitoring workflow performance, managing access, and promoting the use of your data sources.
Table of Contents (18 chapters)
Part 1: Introduction
Part 2: Functional Steps in DataOps
Part 3: Governance of DataOps

Implementing spatial analytics with Alteryx

Spatial analysis is about taking the geographic location of something and finding patterns related to its geographic location. In Alteryx, you can perform a spatial analysis by leveraging the Spatial Tool Pallet and creating a spatial object. To achieve spatial analysis using spatial tools, you need to create a spatial object. The essential spatial object type is a spatial point.

Creating a spatial point

The primary way of creating a spatial point is by using the Create Points tool. This tool will take two coordinate fields to assign one to the X coordinate point and the other to the Y coordinate point. For example, the following screenshot shows the configuration:

Figure 8.2 – Configuration of the Create Points tool

We will be using the HousingPricesTestData.yxdb dataset, which contains long and lat fields. The long field contains longitude information (step 1 in the screenshot), while the lat field...