Data Preparation in Alteryx

Overview

Master data preparation, cleaning, and analysis in Alteryx Designer, whether you are a new or seasoned analyst.

Discover how to prepare, clean, and analyze data in Alteryx Designer! Whether you are new to data analytics in general or an experienced analyst in other platforms, this course will guide you to new levels of understanding the essentials of solid data preparation. You’ll learn why clean and prepared data is important for optimal analytics and how to recognize what aspects of your datasets need cleaning.

Using the Preparation Toolset, you’ll explore removing null data, filtering on specific criteria, applying various formulas, analyzing duplicate data, and many more features that will advance you to perform more intermediate-level analysis in the versatile Alteryx Designer platform. Achieve deeper knowledge of Alteryx Designer best practices and take your knowledge to the next level with hands-on experience. Now is the time to get started on your Alteryx journey!

Syllabus

Data Cleaning and Preparation

Accelerate your Alteryx knowledge by exploring data preparation techniques! You’ll learn why clean and prepared data is important for optimal analytics and how to utilize the main data types. You’ll also discover how to recognize “dirty data” and techniques for cleansing data, such as managing missing values and removing unnecessary data.

Filtering and Using Expressions

Expand your data preparation skills in Alteryx by uncovering ways to filter data and write expressions to create subsets of data. Basic and chained filters will be explored, along with custom filters, to get right to the data you need. You’ll learn best practices in writing expressions, including understanding the differences between AND and OR statements, along with helpful tips for correct syntax.

Applying Formulas

Go further into the layers of data preparation by diving deeper into various formulas and how they can be quickly applied in Alteryx. Discover the wealth of pre-structured formulas available and ready to use in the Formula tool, along with techniques for writing efficient expressions based on data types. You’ll learn the difference between length and position-based formulas and methods to update and create new fields.

Sampling and Summarizing

Explore the processes of sampling and summarizing your data, which are essential aspects of data preparation. You’ll learn many options for sampling data, such as finding the top 10 records or obtaining the first N percentage of data, and much more with the Sample tool. You’ll then expand your knowledge of summarizing data using numerical methods like sum, average, and median, as well as string functions like grouping by specific fields hierarchically in the Summarize tool.