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)
1
Part 1: Introduction
5
Part 2: Functional Steps in DataOps
11
Part 3: Governance of DataOps

Summary

In this chapter, we have investigated several ways in which to process a raw dataset to produce a functional output for our end users. We have also learned about some different methods for profiling our dataset and how we can use that information to ensure the quality of our data.

After learning these skills, we then applied those skills in a practical example, taking the Authenticated API from Chapter 4, Sourcing the Data, and turning that dataset into a useful data table for our application.

In Chapter 6, Destination Management, we will investigate the different ways in which we can output data and different methods to manage those connections.

We will also look at some methods for managing our data connections across different environments so we can be secure in the way we use our data for development and apply it to production.

Finally, we will publish our datasets in an analytical database and leverage the capabilities of Alteryx to upload our dataset for...