Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITM > ITM Final > Flashcards

ITM Final Flashcards

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
Q

Context Filters

A

Applied before all normal filters

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

What are the discrete dimension filters?

A

General, Wildcard, Condition, Top

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

General Filter

A

Select values to include or exclude

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

Wildcard Filter

A

Define a pattern to filter on

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

Condition Filter

A

Define the rules to filter by

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

Top Filter

A

Define a formula that computes the data that will be included in the view

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

Uses for Quick Table Calcs:

A

-Transforming values to show rankings
-Transforming values to show running totals
-Transforming values to show % of total

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

What is a quick table calc?

A

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

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

What is a table calculation?

A

Select the calc type and then manually configure options for the calculation type chosen

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

In order to do operations on data, the data must all be of the same type? True or False?

A

True

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

Fields

A

-Come from your data source or are calculated by the analysts
-Users cannot change them

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

Parameters

A

-Created by the analyst
-Users can change them
-Users’ changes can modify the functionality of the visualization
-Very powerful tool

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

What is required when using fields and parameters?

A

-Must be enclosed in strait brackets
-Parameter name must EXACTLY match the name of the field

38
Q

Trendlines

A

Highlight trends in your data
-Only works on both numeric values

39
Q

What are the types of trendlines?

A

Linear, logarithmic, exponential, power, polynomial

40
Q

Reference Lines

A

Add at a constant or computer value on the axis to see how it compares to average

41
Q

When to use a table?

A

-Display will be used as a lookup for certain values
-Comparing individual values

42
Q

How can data be represented graphically?

A

Points, lines, bars/columns/boxes

43
Q

What is a time series?

A

Series of values of quantity obtained at successive points in time, equal interval durations between them

Ex: Line, column, heat graph

44
Q

Define ranking

A

An arrangement according to rank

45
Q

Define part to whole

A

The relationship of a proportion of a whole to itself

ex: stacked column chart

46
Q

Define Correlation

A

The level of mutual relationship between two data elements

Ex: Scatter plot

47
Q

When using a pie chart…

A

-Only 3 slices
-Clearly different sizes
-Continuous data
-Always show 100%

48
Q

What are the rules for time series?

A

-plot horizontally
-maintain consistent scales
-don’t cross lines

49
Q

Define Geographic Maps

A

Shaded map uses color to encode quantitative data or categorical data

-uses dots (size and color)

50
Q

What is a scatter plot?

A

Uses position to show the relationship between 2 variables
-measures on a quantitative scale
-add trend lines

51
Q

What is a tree map?

A

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
Q

What is a bubble share?

A

Encodes data using size of circle to show comparisons

53
Q

What is a bar chart?

A

Encodes data using height/length of bar and shows categorical comparisons

54
Q

What is a diverging bar chart?

A

Uses height or length from a baseline with the bars diverging from the center

55
Q

What is a histogram?

A

Encodes data using height and shows a distribution
-when trying to find frequency of events

56
Q

What are text tables?

A

Good for a list of precise values that can be looked up

57
Q

What is a line chart?

A

Encodes data using position
-shows trends over time

58
Q

What is a regression line?

A

Shows the formula for the line that best describes the data

59
Q

What is a pie chart?

A

Encodes data using angle, area, and arc to show a part to whole comparison

60
Q

What is sequential data visualization?

A

Color is ordered from low to high

61
Q

What is diverging data visualization?

A

Two sequential colors w/ a neutral midpoint

62
Q

What is categorical data visualization?

A

Contrasting colors for individual comparison

63
Q

What is highlight data visualization?

A

Color used to highlight something

64
Q

What is alert data visualization?

A

Color used to get reader’s attention

65
Q

What are descriptive analytics?

A

Techniques that describe past performance and history

66
Q

What are predictive analytics?

A

Used to extract info from data and use it to predict future patterns and trends

67
Q

What are prescriptive analytics?

A

Create models indicating best course of action

68
Q

Data Aggregation

A

Collecting info from many sources and storing them together in a single location

69
Q

Data granularity

A

The level of detail considered in a model

70
Q

What is the SQL function order?

A
  1. Select
  2. From
  3. Inner join
  4. Where
  5. Group by
  6. Having
  7. Order by
71
Q

Text in a novel is an example of unstructured data

A

True
-Excel is structured

72
Q

Which of the following describes Anscombe’s Quartet?

A

Four data sets with nearly identical descriptive statistics (slope, average, median, etc.) yet have very different distributions and appear very different when graphed.

73
Q

To create a map in Tableau, you must drag latitude and longitude to “columns” and “rows.” T/F

A

False

74
Q

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

A

Pictures (visualizations) are retained at much higher rates than words

75
Q

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

A

Pages

76
Q

Which kind of phenomenon outlines the Moire effect?

A

Lines resembling a barcode closely packed together creating an illusion

77
Q

Which of the following displays when you place the pointer on the border of a selected cell or range?

A

Move Pointer

78
Q

Which of the following use ranking to format cells either by number or percentage?

A

Top/Bottom Rules

79
Q

Which function displays the contents of the cell at the intersection of a specified column and row?

A

INDEX

80
Q

Which of the following does not occur after a dynamic consolidation is created?

A

Worksheets are automatically grouped.

81
Q

Which of the following options copies formatting attributes and styles from one cell to another cell or range?

A

Format Painter

82
Q

When you use the Solver Results dialog box, where are the statistical analysis reports placed?

A

on a new sheet

83
Q

Which dialog box is used to update links in a workbook?

A

Edit Links

84
Q

Forecast means knowing the results and determining the value needed to reach those results.

True or False

A

False

85
Q

Which data consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels?

A

Consolidation by Category

86
Q

Which of the following features displays mathematical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?

A

AutoCalc

87
Q

Which of the following displays when Excel finds an error in a formula?

A

A small green error triangle in the top-left corner of the cell

88
Q

Consider the function =INDEX(array, row_number, column_num). Which of the arguments is a cell range to be searched?

A

Array

89
Q

Which of the following database functions displays the largest value in the field that meets the criteria?

A

DMAX

90
Q

A scenario summary report is formatted as an Excel outline.
True OR False

A

True

91
Q

A map chart is a one-dimensional chart that displays low-level geographic details.
True or False

A
92
Q

Which of the following is NOT a data dimension that can be displayed on a 2D graph?

A

Value

ITM (2 decks)

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