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

Using Alteryx to deliver standard reports

When building reports in Alteryx, you can create and configure the individual reporting components, like a table, chart, or text block, and then combine them into a single layout to render to output.

In this section, we will discuss the following topics:

  • Creating a formatted table
  • Adding visualizations to the report
  • Adding styling to the report
  • Outputting the report for consumption

These individual pieces will show how we can build the parts for our report. Then, of course, we can add additional reporting pieces, such as maps or screenshots, but the process will be the same. There will be some tool-to-tool variation, but the logic will remain.

Creating a formatted table

When producing static reports, tables are often a key component. They allow for a quick lookup of reference values and a simple review. When creating a table report, you will be using the Table tool from the reports tool pallet.

The configuration...