Congratulations!

Data Preparation in Alteryx

Deanna Sanchez

Alteryx ACE and Owner, Nova Geographica LLC

Chapter 1 Review

• Why clean data is important
• Basic data preparation techniques
• The many data types in Alteryx

 

Chapter 1 Review

• Tools covered:
  • Select
  • Data Cleanse
  • Select Records
  • Record ID
  • Sort

Chapter 2 Review

• Basic and Custom filters
• Using the true and false outputs
• AND and OR statements
• Writing expressions

Chapter 2 Review

• Tools covered:
  • Filter
  • Sort
  • Unique

Chapter 3 Review

• Writing expressions and syntax based on data types
• Length and position-based counts
• Updating existing fields and creating new fields

Chapter 3 Review

• Tools covered:
  • Select
  • Formula
  • Sort
  • Filter

Chapter 4 Review

• Sample tool options such as Top N and grouping
• Summarize tool Group By and other functions
• Output Data tool

Chapter 4 Review

• Tools covered:
  • Sort
  • Sample
  • Summarize
  • Output Data

Great work!

Data Preparation in Alteryx