The ETL Process
ETL stands for this.
What is extract, transform, load?
Well-organized info that is often stored in spreadsheets
What is structured data?
Type of data that includes words.
What is string data?
What is the results window?
Used to describe trends over time
What is a line chart?
This is the unique identifier in a data set.
What is the primary key?
Data stored in relational database tables such as Sales Orders would be considered this.
What is structured data (or numeric data)?
Categorical data that has a natural order, such as gold, silver, and bronze.
What is ordinal data?
The tool most often used to bring data into a workflow.
What is the Input tool?
Similar to a bar chart with no margin between bars
What is a histogram?
To connect two data sources, you would need a primary key and this.
What is a foreign key?
Large amounts of information that defy conventional methods of processing
What is big data?
Tableau data type indicated by a globe.
What is geographical data?
This is where changes are made to how a tool works, such as where you would type a formula.
What is the configuration window?
Used to show relationships between variables
What is a scatterplot?
This is the delimiter recommended for use by the AICPA.
What is a pipe?
In 70 transactions, there are 20 returns, and 50 sales. The returns are this proportion of the total.
What is 20/70?
One of the numeric data types in Alteryx
What is double, or Int, Decimal, Float?
Use this tool to change the data type
What is the Select tool?
This is not recommended by many visualization experts due to the difficulty people have interpreting its meaning
What is a pie chart?
Collecting info from the web using automation
What is web scraping?
Data about data.
What is metadata or a data dictionary?
Binary data type that produces one of two set outcomes
What is Boolean?
The three types of Joins the Join tool allows.
What are left, right, and inner joins?
The area in Tableau where you can add and edit color, text, or tooltips to a visualization.
What is the Marks card?