Book Image

Learning Alteryx

Book Image

Learning Alteryx

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.
Table of Contents (17 chapters)
Title Page
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Transforming data


The way we see data and visualize trends begins with the data structure. The data structure is key when creating data visualizations. Knowing how it's structured and why it's structured in a specific orientation leads to a smoother workflow build and design that turns into a successful output table to create brilliant data visualizations. We'll cover two tools that transform data in this section: the Transpose tool and the Crosstab tool. 

The Transpose tool will pivot a wide dataset to a narrow dataset. This is the tall and skinny dataset that will put the fields in rows, and the values in rows as well. More rows will be created when data is transposed to a narrower dataset. This is great for trying to get one field that contains all the field names and the values associated with those field names alongside each other in rows. A calculation can be referenced on one field, rather than an individual calculation referencing each field if they were in their own columns. Transposing...