Alteryx Exam- Tools
Random Sample % - Generates a random number or percentage of records
passing through the data stream
Formula - Create new data fields based on expression or by assigning a data
relationship, or to update an existing field, can also reorder fields and change field types
Text to Columns - Able to split field by delimiter into a set of columns and then
can rename using the select node
Multi-Field Formula - Applies the same expression to all selected columns
Parse - Extracts any group specified and places each in a separate column
Record ID - Assigns a unique numeric value to each row of data
Replace - Replaces a string that matches the specified regular expression with
another string specified in the Replace option
Filter - Allows you to filter out data you want by choosing specific criteria to filter
the whole data set
Match - Test if a string matches the specified regular expression
Sort - Allows sorting of data in ascending or descending order (sorts based on
first field)
Sample - Limit the data to a certain number, percentage, or random set of records
out of the whole data set
Unique - Separate data into two streams based on the fields of the user's
choosing
Inner Join - Both sides have to match, only those records are returned
Left Unjoin - Show records (and their attributes) that only exist in the left table
, Right Unjoin - Show records (and attributes) that only exists in the right table
Left Outer Join - Inner join + left unjoin
Right Outer Join - Inner join + right union
Full Outer Join - Everything in both tables; inner join + left unjoin + right unjoin
Step 1- Define project objectives - Define project objectives
(specify business problem, acquire subject matter expertise, define unit of analysis and
prediction target, prioritize modeling criteria, consider risks and success criteria, decide
whether to continue)
Step 2- Acquire and explore data - Acquire and explore data
find appropriate data, merge data into single table, conduct exploratory data analysis,
find and remove any target leakage, feature engineering)
Step 3- Model Data - ✔️✔️Model Data
Variable selection, build candidate models, model validation and selection
Step 4- Interpret and communicate - ✔️✔️Interpret and communicate
Interpret model, communicate model insights
Step 5- Implement, document, maintain - ✔️✔️Implement, document, maintain
set up batch or API prediction, document modeling process, create model monitoring/
maintenance
Summarize - ✔️✔️Allows you to create subgroups and extract statistical information on
each group
Cross Tab - ✔️✔️Similar to summarize, but moves results into columns rather than
rows
Transpose - ✔️✔️Similar to summarize, but moves results into rows rather than
columns
Directory - ✔️✔️- Input names of files from a directory
- Can analyze how often files have been opened
Random Sample % - Generates a random number or percentage of records
passing through the data stream
Formula - Create new data fields based on expression or by assigning a data
relationship, or to update an existing field, can also reorder fields and change field types
Text to Columns - Able to split field by delimiter into a set of columns and then
can rename using the select node
Multi-Field Formula - Applies the same expression to all selected columns
Parse - Extracts any group specified and places each in a separate column
Record ID - Assigns a unique numeric value to each row of data
Replace - Replaces a string that matches the specified regular expression with
another string specified in the Replace option
Filter - Allows you to filter out data you want by choosing specific criteria to filter
the whole data set
Match - Test if a string matches the specified regular expression
Sort - Allows sorting of data in ascending or descending order (sorts based on
first field)
Sample - Limit the data to a certain number, percentage, or random set of records
out of the whole data set
Unique - Separate data into two streams based on the fields of the user's
choosing
Inner Join - Both sides have to match, only those records are returned
Left Unjoin - Show records (and their attributes) that only exist in the left table
, Right Unjoin - Show records (and attributes) that only exists in the right table
Left Outer Join - Inner join + left unjoin
Right Outer Join - Inner join + right union
Full Outer Join - Everything in both tables; inner join + left unjoin + right unjoin
Step 1- Define project objectives - Define project objectives
(specify business problem, acquire subject matter expertise, define unit of analysis and
prediction target, prioritize modeling criteria, consider risks and success criteria, decide
whether to continue)
Step 2- Acquire and explore data - Acquire and explore data
find appropriate data, merge data into single table, conduct exploratory data analysis,
find and remove any target leakage, feature engineering)
Step 3- Model Data - ✔️✔️Model Data
Variable selection, build candidate models, model validation and selection
Step 4- Interpret and communicate - ✔️✔️Interpret and communicate
Interpret model, communicate model insights
Step 5- Implement, document, maintain - ✔️✔️Implement, document, maintain
set up batch or API prediction, document modeling process, create model monitoring/
maintenance
Summarize - ✔️✔️Allows you to create subgroups and extract statistical information on
each group
Cross Tab - ✔️✔️Similar to summarize, but moves results into columns rather than
rows
Transpose - ✔️✔️Similar to summarize, but moves results into rows rather than
columns
Directory - ✔️✔️- Input names of files from a directory
- Can analyze how often files have been opened
