AIS CH 11
Which of the following best describes a data visualization?
A graphical representation that presents information to decision makers
Which of the following is an important consideration in designing a data visualization?
All of the choices are correct.
Which of the following is NOT true about data visualizations.
Data visualizations are the only way to present data
Which of the following is not part of common steps in using a data analysis tool?
Deliver the visualization to the decision maker
Which of the following is not a basic activity for data visualization?
Documenting the business processes that generate data
Which of the following best describes the purpose of the Show Me feature in Tableau?
Helps the user select the best chart to display the selected measures and dimensions.
Which of the following is not a characteristic of an Excel table?
Includes charts
Which of the following is NOT a well-known visualization tool?
Microsoft Access
Tableau can connect to all these file types except which of the following?
Microsoft Power BI
You can use Value Field Settings to specify a Custom __________ for a field.
Name
Treemaps are similar in purpose to which of the following charts?
Pie charts
Which of the following is least likely to be a Measure field in Tableau?
Segment
Which of the following is NOT an important consideration for developing and presenting visualizations?
Selecting appropriate metrics
Which of the following is NOT part of selecting and modifying the visualization?
Set relationships among tables
Which of the following is NOT true of pie charts?
They compare values across time
Which of the following is least likely to be a Dimension field in Tableau?
Total cost
True or false: Bar charts compare information among categories.
True
True or false: a data visualization is a graphical means of presenting information to decision makers.
True
True or false: both vertical column and horizontal bar charts can be used to compare information among categories.
True
True or false: in Excel, a slicer can be used to filter pivot table and pivot chart output.
True
The first step in preparing the data and developing visualizations is to __________ data.
get
Measures are __________ fields.
numeric
In developing the visualization, it is important to keep the __________ maker in mind.
decision
To use the Tableau Show Me tool, select one or more of the __________ of interest while holding down the control (CTRL) key.
fields
Which of these least describes the features of a Tableau dashboard?
presents multiple sheets in one display (not sure about this. I chose none and it was wrong, i also chose lists available sheets for use on the dashboard and that was also wrong.)
To create relationships among Excel tables, you link foreign keys to __________ keys.
primary
Scatter plot data is often accompanied by __________ a line summarizing the relationship and showing outliers.
regression
After connect to data sources in Tableau, the next step is to create _________ among the tables.
relationships
Line charts typically are used to show values over _________ .
time
Which of the following is not true about a pivot table?
Users must sum the values in the pivot table.
Understanding the data also includes selection of appropriate __________ .
metrics
Part of getting the Excel data is to convert the raw data into __________ .
tables
Which of the following is an important consideration in designing a data visualization? - Choosing the right chart - Using explanatory titles - Using color or size to draw attention to key insights - Defining chart elements clearly - All of the choices are correct
All of the choices are correct.
Which of the following is a characteristic of a pivot table? - it summarizes data in a range, table, or external data source - it can include multidimensional summaries by designating row and column categories - users can format the numbers in the value fields - users can choose sub totals and grand totals - all of the choices are characteristics of pivot tables
All of the choices are true.
Which of the following is true about Excel tables? - they are created from rectangular data ranges - the user can add a totals row - the header includes filter buttons - the table is automatically formatted - all of the choices are true
All of the choices are true.
True or false: Excel is always the best visualization tool.
False
True or false: It is important to provide the decision maker more information than he or she can process.
False
True or false: Raw data must have blank rows or columns to be easily turned into an Excel table.
False
True or false: Unlike Microsoft Access, you can't create relationships among tables in Excel.
False
True or false: In Tableau, there is one best type of visualization for each combination of dimensions and measures.
False Reason: The Show Me tool will show the various best visualizations but there are often more than one type that can be used.
Which of the following charts is used to show trend over time?
Line charts
Which of the following is NOT true about line charts?
They show distribution of a single variable
Which of these is not a Power BI view?
Visualization view
Dimensions in Tableau are __________ fields.
categorical
Treemaps show relationships among nested __________.
categories
Vertical column charts typically show fewer __________ than horizontal bar charts.
categories
When joining two tables in Tableau, the overlapping __________ indicate the type of join.
circles
For horizontal bar charts, the purpose is to __________ information among categories.
compare
Scatter plots show correlations between __________ two variables.
continuous
An important part of understanding the data involves questioning how the data supports the overall __________ of the visualizations.
goal
Pie charts are typically used to show the composition of a _________ .
whole