Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

ITM > ITM Final > Flashcards

ITM Final Flashcards

(92 cards)

Start Studying
1
Q

Cross-tab

A

Another name for a text table or a table of numbers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Dashboard

A

A collection of views shown in a single location where you can compare and monitor a variety of data
simultaneously.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data source

A

The underlying data that Tableau Reader is connected to. You can’t change the data source in Tableau
Reader.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Filter

A

A control on a view that limits the data shown in a view. For example, a filter on Region that only includes
the West.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Marks

A

A visual representation of one or more rows in a data source. Mark types can be bar, line, square, and so
on.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Packaged Workbook

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Pane

A

The row and columns areas in a view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Repository

A

A folder located in your My Documents folder that stores workbooks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

View

A

The visual representation of your data in a worksheet or dashboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Workbook

A

A collection of one or more worksheets and dashboards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Worksheet

A

A single view of data. Each worksheet can be connected to a single data source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Dimensions

A

-Qualitative values (names, dates, geographical data)
-Use to categorize, segment, and reveal details
-Affect level of detail

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Measures

A

-Contains numeric, quantitative values (measurable)
-Can be aggregated
-When dragged into view it applies as an aggreration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Continuous

A

Treated as an infinite range
-Add axes to the view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Discrete

A

Treated as finite
-Headers to the view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the Max # of Data Dimensions on 2-D Graphs?

A

6 (We only use a max of 5)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are the 6 dimensions possible in a 2-D graph?

A
  1. X-position
  2. Y-position
  3. Color
  4. Animation
  5. Size
  6. Shape
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Continuous Values

A

Chronological progression of time
-Green fields
-Year of year

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Discrete Date Parts

A

Distinct units of time contained in your data
-Month, Week Number, Weekday
-Blue Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Use continuous date values to:

A

Visualize how data changes over a range of time (year)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Use discrete date parts to:

A

Compare a specific unit of time for a date field (months) to each other

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Extract Filters

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Data Source Filters

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

If applying Extract filters and Data Source together what happens?

A

Data source filters overwrite the extract filters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Context Filters
Applied before all normal filters
26
What are the discrete dimension filters?
General, Wildcard, Condition, Top
27
General Filter
Select values to include or exclude
28
Wildcard Filter
Define a pattern to filter on
29
Condition Filter
Define the rules to filter by
30
Top Filter
Define a formula that computes the data that will be included in the view
31
Uses for Quick Table Calcs:
-Transforming values to show rankings -Transforming values to show running totals -Transforming values to show % of total
32
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
33
What is a table calculation?
Select the calc type and then manually configure options for the calculation type chosen
34
In order to do operations on data, the data must all be of the same type? True or False?
True
35
Fields
-Come from your data source or are calculated by the analysts -Users cannot change them
36
Parameters
-Created by the analyst -Users can change them -Users' changes can modify the functionality of the visualization -Very powerful tool
37
What is required when using fields and parameters?
-Must be enclosed in strait brackets -Parameter name must EXACTLY match the name of the field
38
Trendlines
Highlight trends in your data -Only works on both numeric values
39
What are the types of trendlines?
Linear, logarithmic, exponential, power, polynomial
40
Reference Lines
Add at a constant or computer value on the axis to see how it compares to average
41
When to use a table?
-Display will be used as a lookup for certain values -Comparing individual values
42
How can data be represented graphically?
Points, lines, bars/columns/boxes
43
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
44
Define ranking
An arrangement according to rank
45
Define part to whole
The relationship of a proportion of a whole to itself ex: stacked column chart
46
Define Correlation
The level of mutual relationship between two data elements Ex: Scatter plot
47
When using a pie chart...
-Only 3 slices -Clearly different sizes -Continuous data -Always show 100%
48
What are the rules for time series?
-plot horizontally -maintain consistent scales -don't cross lines
49
Define Geographic Maps
Shaded map uses color to encode quantitative data or categorical data -uses dots (size and color)
50
What is a scatter plot?
Uses position to show the relationship between 2 variables -measures on a quantitative scale -add trend lines
51
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
52
What is a bubble share?
Encodes data using size of circle to show comparisons
53
What is a bar chart?
Encodes data using height/length of bar and shows categorical comparisons
54
What is a diverging bar chart?
Uses height or length from a baseline with the bars diverging from the center
55
What is a histogram?
Encodes data using height and shows a distribution -when trying to find frequency of events
56
What are text tables?
Good for a list of precise values that can be looked up
57
What is a line chart?
Encodes data using position -shows trends over time
58
What is a regression line?
Shows the formula for the line that best describes the data
59
What is a pie chart?
Encodes data using angle, area, and arc to show a part to whole comparison
60
What is sequential data visualization?
Color is ordered from low to high
61
What is diverging data visualization?
Two sequential colors w/ a neutral midpoint
62
What is categorical data visualization?
Contrasting colors for individual comparison
63
What is highlight data visualization?
Color used to highlight something
64
What is alert data visualization?
Color used to get reader's attention
65
What are descriptive analytics?
Techniques that describe past performance and history
66
What are predictive analytics?
Used to extract info from data and use it to predict future patterns and trends
67
What are prescriptive analytics?
Create models indicating best course of action
68
Data Aggregation
Collecting info from many sources and storing them together in a single location
69
Data granularity
The level of detail considered in a model
70
What is the SQL function order?
1. Select 2. From 3. Inner join 4. Where 5. Group by 6. Having 7. Order by
71
Text in a novel is an example of unstructured data
True -Excel is structured
72
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.
73
To create a map in Tableau, you must drag latitude and longitude to "columns" and "rows." T/F
False
74
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
75
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
76
Which kind of phenomenon outlines the Moire effect?
Lines resembling a barcode closely packed together creating an illusion
77
Which of the following displays when you place the pointer on the border of a selected cell or range?
Move Pointer
78
Which of the following use ranking to format cells either by number or percentage?
Top/Bottom Rules
79
Which function displays the contents of the cell at the intersection of a specified column and row?
INDEX
80
Which of the following does not occur after a dynamic consolidation is created?
Worksheets are automatically grouped.
81
Which of the following options copies formatting attributes and styles from one cell to another cell or range?
Format Painter
82
When you use the Solver Results dialog box, where are the statistical analysis reports placed?
on a new sheet
83
Which dialog box is used to update links in a workbook?
Edit Links
84
Forecast means knowing the results and determining the value needed to reach those results. True or False
False
85
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
86
Which of the following features displays mathematical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?
AutoCalc
87
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
88
Consider the function =INDEX(array, row_number, column_num). Which of the arguments is a cell range to be searched?
Array
89
Which of the following database functions displays the largest value in the field that meets the criteria?
DMAX
90
A scenario summary report is formatted as an Excel outline. True OR False
True
91
A map chart is a one-dimensional chart that displays low-level geographic details. True or False
92
Which of the following is NOT a data dimension that can be displayed on a 2D graph?
Value

ITM (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions