Data Sourcing
Data Harmonization
Basic Functions
Analyzing Data
Random
100
The tool used to analyze department specific/BU data.
What is ACL Desktop
100
These are logical statements that are evaluated by ACL and are used to perform calculations.
What are Expressions
100
The function that converts a text to a number
What is VALUE
100
This is combining two sorted ACL tables into a new third table
What is a JOIN
100
The process of using data analysis to reach a conclusion
What is ANALYTICS
200
The analytics tool that is used for continuous monitoring purposes.
What is ACL AX
200
This is where you start to make some data changes
What is Edit>Table Layout
200
The function that creates a separate ACL table arranged in a particular order
What is SORT
200
These are the 2 table types when joining
What are the PRIMARY and SECONDARY tables
200
This is the most recent version of ACL Desktop/Analytics
What is ACL Version 10
300
Testing all of the records available rather than a sample of records
What is POPULATION TESTING
300
This is the most common button you will use to build an expression
What is the "fx" button
300
The function that counts the records for each distinct value of selected character or date fields and subtotals numeric fields.
What is SUMMARIZE
300
This is the name of the common field used to join two tables in ACL
What is the PRIMARY KEY
300
This is the type of ACL Version that we should install
What is NON UNICODE
400
A combined group of commands that is written in a way that all the commands will be performed in a certain order.
What is a SCRIPT
400
You choose this if ACL crashes and you want to continue where you left off
What is the WORKING PROJECT
400
The command that produces a summary of two or more character fields by arranging the fields into columns and rows
What is CROSSTAB
400
This will show the result of any records that do not appear in the Primary table
What is the UNMATCHED JOIN
400
This is what the highest level of organization that ACL uses
What is an ACL PROJECT
500
The two times you should confirm the accuracy of the data
What is PRE IMPORT AND POST IMPORT VALIDATION
500
The source of information that stores your ACL Project history
What is the LOG
500
This is used to detect possible anomalies in large data sets.
What is Benfords Law
500
This is the process of getting the data into a form that we can use to perform analysis
What is HARMONIZING
500
This is someone who is "NEVER LEFT IN A CORNER"
What is BABY!!!!!
M
e
n
u