ITM Final Flashcards
Cross-tab
Another name for a text table or a table of numbers.
Dashboard
A collection of views shown in a single location where you can compare and monitor a variety of data
simultaneously.
Data source
The underlying data that Tableau Reader is connected to. You can’t change the data source in Tableau
Reader.
Filter
A control on a view that limits the data shown in a view. For example, a filter on Region that only includes
the West.
Marks
A visual representation of one or more rows in a data source. Mark types can be bar, line, square, and so
on.
Packaged Workbook
A type of workbook created in either Tableau Desktop or Tableau Server. These files contain both the
workbook as well as copies of the referenced local file data sources and background images
Pane
The row and columns areas in a view
Repository
A folder located in your My Documents folder that stores workbooks
View
The visual representation of your data in a worksheet or dashboard
Workbook
A collection of one or more worksheets and dashboards
Worksheet
A single view of data. Each worksheet can be connected to a single data source.
Dimensions
-Qualitative values (names, dates, geographical data)
-Use to categorize, segment, and reveal details
-Affect level of detail
Measures
-Contains numeric, quantitative values (measurable)
-Can be aggregated
-When dragged into view it applies as an aggreration
Continuous
Treated as an infinite range
-Add axes to the view
Discrete
Treated as finite
-Headers to the view
What is the Max # of Data Dimensions on 2-D Graphs?
6 (We only use a max of 5)
What are the 6 dimensions possible in a 2-D graph?
- X-position
- Y-position
- Color
- Animation
- Size
- Shape
Continuous Values
Chronological progression of time
-Green fields
-Year of year
Discrete Date Parts
Distinct units of time contained in your data
-Month, Week Number, Weekday
-Blue Fields
Use continuous date values to:
Visualize how data changes over a range of time (year)
Use discrete date parts to:
Compare a specific unit of time for a date field (months) to each other
Extract Filters
Strip Data from the original data source and do not add it to the extract
-Will change the size of extract file
-Precondition filters before
Data Source Filters
Bring all the data over BUT filter out the data before ALL visualization operations occur
-Doesn’t change the size of file
-Post condition filters while displaying data, won’t apply during extract creation
If applying Extract filters and Data Source together what happens?
Data source filters overwrite the extract filters
Context Filters
Applied before all normal filters
What are the discrete dimension filters?
General, Wildcard, Condition, Top
General Filter
Select values to include or exclude
Wildcard Filter
Define a pattern to filter on
Condition Filter
Define the rules to filter by
Top Filter
Define a formula that computes the data that will be included in the view
Uses for Quick Table Calcs:
-Transforming values to show rankings
-Transforming values to show running totals
-Transforming values to show % of total
What is a quick table calc?
Allows you to apply a built-in calc to your visualization using pre-set configurations for the calculation type you choose
-Performed after the results have been pulled
-Filters can be used against it
-Can be manually created
-Can be saved for use in other views
What is a table calculation?
Select the calc type and then manually configure options for the calculation type chosen
In order to do operations on data, the data must all be of the same type? True or False?
True
Fields
-Come from your data source or are calculated by the analysts
-Users cannot change them
Parameters
-Created by the analyst
-Users can change them
-Users’ changes can modify the functionality of the visualization
-Very powerful tool
What is required when using fields and parameters?
-Must be enclosed in strait brackets
-Parameter name must EXACTLY match the name of the field
Trendlines
Highlight trends in your data
-Only works on both numeric values
What are the types of trendlines?
Linear, logarithmic, exponential, power, polynomial
Reference Lines
Add at a constant or computer value on the axis to see how it compares to average
When to use a table?
-Display will be used as a lookup for certain values
-Comparing individual values
How can data be represented graphically?
Points, lines, bars/columns/boxes
What is a time series?
Series of values of quantity obtained at successive points in time, equal interval durations between them
Ex: Line, column, heat graph
Define ranking
An arrangement according to rank
Define part to whole
The relationship of a proportion of a whole to itself
ex: stacked column chart
Define Correlation
The level of mutual relationship between two data elements
Ex: Scatter plot
When using a pie chart…
-Only 3 slices
-Clearly different sizes
-Continuous data
-Always show 100%
What are the rules for time series?
-plot horizontally
-maintain consistent scales
-don’t cross lines
Define Geographic Maps
Shaded map uses color to encode quantitative data or categorical data
-uses dots (size and color)
What is a scatter plot?
Uses position to show the relationship between 2 variables
-measures on a quantitative scale
-add trend lines
What is a tree map?
Encodes data using size and color and is useful for hierarchical data or when there is a very large number of categories to compare
What is a bubble share?
Encodes data using size of circle to show comparisons
What is a bar chart?
Encodes data using height/length of bar and shows categorical comparisons
What is a diverging bar chart?
Uses height or length from a baseline with the bars diverging from the center
What is a histogram?
Encodes data using height and shows a distribution
-when trying to find frequency of events
What are text tables?
Good for a list of precise values that can be looked up
What is a line chart?
Encodes data using position
-shows trends over time
What is a regression line?
Shows the formula for the line that best describes the data
What is a pie chart?
Encodes data using angle, area, and arc to show a part to whole comparison
What is sequential data visualization?
Color is ordered from low to high
What is diverging data visualization?
Two sequential colors w/ a neutral midpoint
What is categorical data visualization?
Contrasting colors for individual comparison
What is highlight data visualization?
Color used to highlight something
What is alert data visualization?
Color used to get reader’s attention
What are descriptive analytics?
Techniques that describe past performance and history
What are predictive analytics?
Used to extract info from data and use it to predict future patterns and trends
What are prescriptive analytics?
Create models indicating best course of action
Data Aggregation
Collecting info from many sources and storing them together in a single location
Data granularity
The level of detail considered in a model
What is the SQL function order?
- Select
- From
- Inner join
- Where
- Group by
- Having
- Order by
Text in a novel is an example of unstructured data
True
-Excel is structured
Which of the following describes Anscombe’s Quartet?
Four data sets with nearly identical descriptive statistics (slope, average, median, etc.) yet have very different distributions and appear very different when graphed.
To create a map in Tableau, you must drag latitude and longitude to “columns” and “rows.” T/F
False
What is the picture superiority effect?
The most important visualization in a dashboard should be the largest
Pictures (visualizations) are superior if they leverage color in the correct way
Superior visualizations follow the F pattern in a dashboard
Pictures (visualizations) are retained at much higher rates than words
Pictures (visualizations) are retained at much higher rates than words
Which feature can be used to animate a chart similar to the Hans Rosling charts we have viewed during the semester?
Pages
Dashboards
Parameters
Stories
Pages
Which kind of phenomenon outlines the Moire effect?
Lines resembling a barcode closely packed together creating an illusion
Which of the following displays when you place the pointer on the border of a selected cell or range?
Move Pointer
Which of the following use ranking to format cells either by number or percentage?
Top/Bottom Rules
Which function displays the contents of the cell at the intersection of a specified column and row?
INDEX
Which of the following does not occur after a dynamic consolidation is created?
Worksheets are automatically grouped.
Which of the following options copies formatting attributes and styles from one cell to another cell or range?
Format Painter
When you use the Solver Results dialog box, where are the statistical analysis reports placed?
on a new sheet
Which dialog box is used to update links in a workbook?
Edit Links
Forecast means knowing the results and determining the value needed to reach those results.
True or False
False
Which data consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels?
Consolidation by Category
Which of the following features displays mathematical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?
AutoCalc
Which of the following displays when Excel finds an error in a formula?
A small green error triangle in the top-left corner of the cell
Consider the function =INDEX(array, row_number, column_num). Which of the arguments is a cell range to be searched?
Array
Which of the following database functions displays the largest value in the field that meets the criteria?
DMAX
A scenario summary report is formatted as an Excel outline.
True OR False
True
A map chart is a one-dimensional chart that displays low-level geographic details.
True or False
Which of the following is NOT a data dimension that can be displayed on a 2D graph?
Value
