Congratulations!

1. Congratulations!

Congratulations on completing the Data Preparation in Alteryx course!

2. Chapter 1 Review

You've accomplished a lot throughout this course, and gained extensive knowledge of over 10 new Alteryx tools, with many of them from the Preparation toolset. Starting with Chapter 1, you learned why clean data is important, basics of data preparation and techniques, and data types in Alteryx.

3. Chapter 1 Review

You explored five tools right away, from the Select tool through Data Cleanse, Select Records, Record ID, and the Sort tool!

4. Chapter 2 Review

In Chapter 2, you ramped up your skills by exploring the Filter tool in depth, learning basic and custom filters, using true and false outputs, applying AND and OR statements, and writing expressions, keeping in mind data types and syntax.

5. Chapter 2 Review

Various expressions in the Filter tool were applied, along with combining the Sort and Unique tools.

6. Chapter 3 Review

Chapter 3 provided a deep dive into the Formula tool, where you expanded your skills in writing expressions and understanding length and position-based counts, as well as precision and scale. Furthering your knowledge, you discovered how to update existing fields and create new ones.

7. Chapter 3 Review

Enhancing the Formula tool, you added the Select, Sort and Filter tools to find new insights!

8. Chapter 4 Review

In Chapter 4, you achieved higher levels by utilizing the Sample tool, discovering techniques for sampling data, such as Top N rows while grouping by fields. Next, you accomplished summarizing data with various methods, including Group By, ensuring the actions match the data types. Lastly, you wrapped up the workflow with an Output Data tool, saving the results as an Alteryx .yxdb file.

9. Chapter 4 Review

The Sort tool combined with the Sample tool delivered quick results, and the Summarize tool gave insights that were efficiently exported with the Output Data tool.

10. Great work!

You successfully attained a thorough knowledge of data preparation, and built an extensive workflow! This is still the beginning, and keep going on your Alteryx journey!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Data Preparation in Alteryx

BeginnerSkill Level

4.9+

415 reviews

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.

Exercise 1: Filtering and Using Expressions Exercise 2: Understanding filter expressions Exercise 3: AND, OR and more!Exercise 4: Basic and chained filters Exercise 5: Custom filters and expressions Exercise 6: Combining sort and unique tools

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.

Exercise 1: Applying Formulas in Alteryx Exercise 2: Making the best expression Exercise 3: Formulas and best practices Exercise 4: Existing fields and new fields Exercise 5: Length and position-based formulas Exercise 6: Contains formula and flags

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.

Exercise 1: Sampling and Summarizing Exercise 2: Applying the right concepts Exercise 3: Grouping insights and creating output Exercise 4: Top 10 and average sale prices Exercise 5: Summary and data output Exercise 6: Input data and sampling top 25%Exercise 7: Congratulations!

Current Exercise