Preface

Alteryx allows you to create repetitive data manipulation and analytic workflows with a simple, easy-to-use, code-free/code-friendly UI and performs very fast executing those workflows, offering multiple ways to achieve the same results.

This book is the result of compiling Alteryx users’ frequent day-to-day use cases/situations they deal with and a comprehensive guide for leveraging your skills in Alteryx and finding the best way to perform these operations.

Through the chapters, this book’s recipes will take you through an analyst’s complete journey, covering all aspects of the data life cycle, from reading it, no matter what source you do it from, to obtaining reports/reports, and passing through the adjustment operations necessary for analysis. You’ll learn how to read numerous and disparate files and databases and handle huge amounts of data. You’ll then perform operations and transformations to your data to suit your needs. Also, you’ll learn how to group data in different ways and criteria and blend different types of data sources. You’ll understand how to pivot and un-pivot your data for easy manipulation and perform aggregations and calculations on your data. You will also learn how to encapsulate reusable logic into components (Macros), connect and download data from APIs and save your data or create reports in various formats.

By the end of this book, you will notice how your use of Alteryx Designer has improved and how you have discovered how to best perform tasks within it.