None
1. Advanced Preparation
a. Tools: Multi-Field Formula, Multi-Row Formula, Random % Sample
b. Correctly format string expressions to produce a given output
c. Identify the specifiers and separators that transform a given date
d. Create Multi-Row Formula expressions using Row variables
e. Determine how to correctly configure the Multi-Row Formula tool for “values
for rows that don’t exist”
f. Identify the results of a compound condition in the Filter tool (condition joined
by and/or operators)
g. Identify how the Random % Sample tool selects and processes records to
output
h. Identify the output of complex expressions
2. Advanced Join & Parse
a. Tools: Join Multiple, RegEx
b. Determine the number of records that result from a multidimensional join
c. Identify the regular expression that would transform a given input to a given
output
d. Differentiate Match and Parse output methods of the RegEx tool
e. Identify how the Join Multiple tool processes records that don’t match
3. Reporting
a. Tools: Interactive Chart, Layout, Overlay, Render, Report Map, Report Text,
Table
b. Identify the tool that can place reporting snippets on top of one another
c. Identify the tools used to produce a given report
d. Identify the default outputs of the Report Map tool
e. Determine ways the Report Text tool can accept incoming data
f. Identify configuration options in the Interactive Chart tool
g. Identify configuration options of the Table tool
h. Identify the ways the Render tool can write out reporting snippets
i. Determine how to achieve batch reporting with the Reporting tools
j. Determine how the Layout tool arranges snippets
4. Macros
a. Tools: Control Parameter, Macro Input, Macro Output
b. Determine which kind of macro (standard, iterative, batch) is the best solution
for a given scenario
c. Identify the number of outputs an iterative macro can produce
d. Identify common reasons macros error
e. Determine how to debug a macro interface
f. Differentiate the functionality of macros versus apps
g. Determine how to use an engine iteration number
h. Configure a batch macro and an iterative macro
5. Analytic Applications
a. Tools: Action, Check Box, Drop Down, Error Message, File Browse, Folder
Browse, List Box, Map, Numeric
b. Up Down, Radio Button, Text Box, Tree
c. Configure chained applications
d. Identify the Interface tools used to create a given App interface
e. Determine when an Action tool is required between Interface and workflow
tools
f. Identify which Interface tools can be used to input or output data in an App
g. Correctly format list values for the Drop Down tool
h. Identify ways app users can interact with interface elements from the Map tool
i. Identify common reasons why apps error
6. Data Investigation
a. Tools: Association Analysis, Field Summary, Frequency Table, Pearson
Correlation, Scatterplot, Spearman
b. Correlation
c. Identify the tool that provides remarks and suggestions on data quality
d. Interpret the output of the Pearson Correlation tool and identify the variables
that have the strongest
e. correlation
f. Differentiate the Spearman Correlation and Pearson Correlation tools
g. Interpret the output of the Spearman Correlation tool
h. Identify the configuration of the Scatterplot tool that produces a given graph
i. Determine how to find p-values for correlations
7. Predictive Analysis
a. Investigate and prepare data for analysis
b. Identify suitable variables for predicting a target
c. variable
d. Select predictor variables that fit given criteria
e. Create training and validation datasets
f. Select appropriate algorithms to model datasets
g. Train models
h. Compare models
i. Interpret model reports
j. Score new data with trained models
k. Classification
l. Regression
m. Time series
n. Optimization