Real-Life Exercises
  • Average Ignoring Zeros
  • Dynamic Concatenation
  • Date Parsing
  • Time Conversion
  • Sample Size Summarized
  • Repeating Unique
  • First Day Month
  • Time Difference
  • Dynamic Variables
  • String Identifiers
  • Character Count
  • Transforming Data
  • Summarize Time Segments
  • Log Transformation
  • Percentage Format
  • Rearranging Columns
  • Filtering Price Differences
  • Merged Strings
  • Parse Numbers & Strings
  • Fuzzy Matching
  • Previous Value Check
  • Grouped Regular Expressions
  • Missing Values
  • Section 1: Real-Life Exercises
Real-Life Use Cases
  • Join to Area
  • Count Key Words
  • Data Parse Method
  • Delimiter Cleansing
  • Running Averages
  • Standardize Dates
  • Spatial Distance
  • Section 2: Real-Life Use Cases
Excel to Alteryx Series
  • Combining Files from Single Input
  • Data Cleansing & Multi-Row Formulas
  • Date Calculations
  • Calculating Rates
  • Section 3: Excel to Alteryx Series
Batch Macros
  • Batch Macro Multiplier
  • Section 4: Batch Macros
In-Database
  • In-Database Connection
  • In-Database Joining & Aggregation
  • Section 5: In-Database
Bonus! Tips & Tricks
  • Inspire 2017 Tips & Tricks