Book Overview & Buying
Table Of Contents
Feedback & Rating

Learning Alteryx

3.3 (8)

Buy this Book

Learning Alteryx

3.3 (8)

Buy this Book

Overview of this book

Alteryx, as a leading data blending and advanced data analytics platform, has taken self-service data analytics to the next level. Companies worldwide often find themselves struggling to prepare and blend massive datasets that are time-consuming for analysts. Alteryx solves these problems with a repeatable workflow designed to quickly clean, prepare, blend, and join your data in a seamless manner. This book will set you on a self-service data analytics journey that will help you create efficient workflows using Alteryx, without any coding involved. It will empower you and your organization to take well-informed decisions with the help of deeper business insights from the data.Starting with the fundamentals of using Alteryx such as data preparation and blending, you will delve into the more advanced concepts such as performing predictive analytics. You will also learn how to use Alteryx’s features to share the insights gained with the relevant decision makers. To ensure consistency, we will be using data from the Healthcare domain throughout this book. The knowledge you gain from this book will guide you to solve real-life problems related to Business Intelligence confidently. Whether you are a novice with Alteryx or an experienced data analyst keen to explore Alteryx’s self-service analytics features, this book will be the perfect companion for you.

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

Getting Started with Alteryx

Installation and setup

The Alteryx Designer architecture

Introduction to Alteryx Designer

An overview of the workflow configurations

Exploring the Tool Palettes

The Favorites tools

Summary

Workflow Optimization

Resource optimization and speed processing

Performance Profiling

Connecting to data

Alteryx file types

Summary

Data Preparation and Blending

Data preparation

Data cleansing

Filtering

Join and union

Summary

Writing Fast and Accurate Expressions

Formula

Multi-Row Formula

Multi-Field Formula

Summary

Transforming Data

Transforming data

Summarizing and aggregating data

Running total

Weighted average

Summary

Data Parsing Techniques

Text to columns

Converting strings to dates and dates to strings

Regular expressions

Summary

Creating Data-Driven Custom Reports

Data Table

Charting

Reporting layout

Sharing the report

Summary

Using Macros in Workflows

Standard Macro

Batch Macro

Summary

Sharing Your Insights

Alteryx Server

Alteryx Analytics Gallery

Summary

Best Practices

The ultimate guide to workflow design

Tips and tricks

Summary

Customer Reviews

3.3 (8)

5 star

25%

4 star

37.5%

3 star

2 star

12.5%

1 star

25%

Workflow Optimization

Alteryx processes hundreds of billions of rows. The workflow design is vital to ensuring that the workflow runs efficiently, allowing for optimum processing. This chapter focuses on the foundational workflow optimization concepts and applying runtime selections to speed execution. A multitude of essential selections can be made to enhance your workflow. You will learn how to apply resource optimization to process data faster. Furthermore, you'll discover how your workflow is performing by using performance profiling.

The topics we'll examine include:

Resource optimization and speed processing
Performance profiling
Connecting to data
Alteryx file types

The ability to optimize workflow will set the platform for a powerful data preparation and data blending venture that we will cover in the next chapter.

...