Making the best expression

The Formula tool provides a large selection of formulas that can be quickly applied as part of the data preparation and analysis process. However, expression syntax still needs to be correct in order to obtain results. Leveraging your new knowledge of this important and versatile tool, select the correct answers in this multiple choice question:

แบบฝึกหัดนี้เป็นส่วนหนึ่งของหลักสูตร

Data Preparation in Alteryx

ดูคอร์ส

แบบฝึกหัดเชิงโต้ตอบแบบลงมือทำจริง

เปลี่ยนทฤษฎีให้เป็นการลงมือทำด้วยแบบฝึกหัดเชิงโต้ตอบหนึ่งในของเรา

เริ่มแบบฝึกหัด

แบบฝึกหัดนี้เป็นส่วนหนึ่งของหลักสูตร

Data Preparation in Alteryx

SkillTag.level.beginnerSkillTag.label

4.9+

1125 reviews

เริ่มคอร์สฟรี

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.

Exercise 1: What is data cleaning and preparation?Exercise 2: Why is clean data important?Exercise 3: Preparing and cleansing fields Exercise 4: Importing data and modifying fields Exercise 5: Cleansing data fields Exercise 6: Removing rows and sorting

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!