VA Session 8 & 9 Alteryx ^

Question 1

Data Transformation

Answer 1

• adding or modifying variables
• e.g. computing variable C from A & B or applying log-transformation on single variable

Question 2

Data Manipulation

Answer 2

• modification of information to make it easier to read or more structured
• Data transformation (adding or modifying values) & filtering, sorting, aggregating
• e.g. data values sorted in alphabetical order, making it easier to find individual entries

Question 3

Data Modelling

Answer 3

Applying statistical models or
Way of identifying & mapping data used in business processes & relationship (data engineers)

Question 4

Dataset

Answer 4

collection of values (numbers or strings)

Question 5

Values

Answer 5

belongs to a variable or observation

Question 6

Variable

Answer 6

contains all values that measure same underlying attribute (e.g. height) across units -> columns

Question 7

Observation

Answer 7

contains all values measured on same unit (e.g. person, day) -> rows

Question 8

Alteryx Definition

Answer 8

• low-code no-code data blending & transformation tool (making data accessible to anyone)
• Goal: clean data where variables being columns & observations rows (Alteryx & Tableau prefer this data structure)

Question 9

Workflow design

Answer 9

Should be designed in structured & well-documented manner (you later & colleagues should understand)

Question 10

Workflow Design - Methods

Answer 10

o Colors
o Containers
o Use of space (unlimited)
o Input on left hand side, outputs to right
o Documentations incl. comments
o Workflow tests (message = I and tests = + / - sign)

Question 11

Difference input data & input text

Answer 11

• Input Data: reads data into workflow (select a file or connect to a database)
• Input Text: manually enter text to create small data files for input (useful in testing while building workflow) -> data saved within the workflow -> share the workflow without having to provide an input data filter

Question 12

Browse Tool

Answer 12

• to view data from a connected tool & data Profile information
• for multiple columns in single holistic view, or for 1 column
• information on data type, number of records, data quality, and a variety of statistics.

Question 13

Cross Tab vs Transpose

Answer 13

• Cross Tab: from long into wide format
• Transpose: from wide into long format