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

Technical requirements

In this chapter, you will need access to Alteryx Designer for creating workflows. We will also see how to output to other BI tools, such as Tableau and PowerBI. This output is not core to the Alteryx experience, but can extend the capabilities into an interactive visual analysis platform. You can find the example workflows in the book's GitHub repository here:

Finally, the datasets we will be using for this section are all part of the Alteryx install. You can find them in the Alteryx sample data folder. By default, it is located at C:\Program Files\Alteryx\Samples\data.

The other way to find the folder location is by navigating to the Help option in the menu bar of Alteryx and clicking on Sample Datasets, which you can see in the following screenshot:

Figure 7.1 – Location of the sample data from the help menu

Let's get started...