The ideal way to structure your data depends on how the result is defined. You may notice within a workflow that data needs to be transformed in a certain way, and the two ways this can be done are by using the Transpose tool to unpivot data, changing data from a wide dataset to a narrow dataset, and by using the Crosstab tool to pivot data, changing data from a narrow dataset to wider dataset. In this chapter, we reviewed many aggregation types available within the Summarize tool. The granularity of data can be defined within the Group By actions and the aggregation types are an action selection away to achieve the desired result. The Running Total is a great option for obtaining a cumulative sum of your data up to a certain point, defined by the Group By options, and the Weighted Average is used for applying a contribution amount for more records than others. This tool also contains the Group By option, specifying how data needs to be grouped together. These tools, available within...
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)
About the Author
About the Reviewer
Getting Started with Alteryx
Data Preparation and Blending
Writing Fast and Accurate Expressions
Data Parsing Techniques
Creating Data-Driven Custom Reports