Ch. 11 SmartBook
In the relationships view in Power BI, inactive relationships are shown with a [blank] line.
dashed
Understanding the data also includes selection of appropriate [blank].
metrics
Which of the following is NOT true about data visualizations.
Data visualizations are the only way to present data
True or false: It is important to provide the decision maker more information than he or she can process.
False Reason: Avoid information overload
True or false: Excel is always the best visualization tool.
False Reason: Excel is good but far from the best.
True or false: Raw data must have blank rows or columns to be easily turned into an Excel table.
False Reason: Must not have blank rows or columns.
True or false: Unlike Microsoft Access, you can't create relationships among tables in Excel.
False Reason: You can create relationships among tables in Excel much like you set relationships in Access.
True or false: In Power BI, you can add a simple table to the report view page by clicking on the pie chart icon in the visualizations area and then selecting the fields to include.
False Reason: click on the table icon
Which of the following is NOT a well-known visualization tool?
Microsoft Access
You can use Value Field Settings to specify a Custom [blank] for a field.
Name
Treemaps are similar in purpose to which of the following charts?
Pie charts
Which of the following is NOT an important consideration for developing and presenting visualizations?
Selecting appropriate metrics Reason: Element of understanding the data that happens prior to developing the visualization
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 NOT true about line charts?
They show distribution of a single variable
True or false: Bar charts compare information among categories.
True
True or false: In data view in Power BI, you can set formatting for a field by selecting Modeling > Formatting and then selecting the appropriate format.
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
True or false: a data visualization is a graphical means of presenting information to decision makers.
True Reason: This is the purpose of a data visualization.
Treemaps show relationships among nested [blank].
categories
Vertical column charts typically show fewer [blank] than horizontal bar charts.
categories
For horizontal bar charts, the purpose is to [blank] information among categories.
compare
Scatter plots show correlations between two [blank] variables.
continuous
On the left, the Power BI report view screen shows icons representing the three different views: report, [blank], and relationships.
data
The [blank] view in Power BI lets you calculate new fields and set formatting for fields, such as currency fields.
data
In developing the visualization, it is important to keep the [blank] maker in mind.
decision
In the Power BI report view, the Visualizations area allows you to click on an [blank] to select specific types of charts or visualizations.
icon
To create relationships among Excel tables, you link foreign keys to [blank] keys.
primary
Scatter plot data is often accompanied by a [blank] line summarizing the relationship and showing outliers.
regression/trend
In Power BI, the [blank] view allows you to set connections among tables.
relationships
The second step in preparing the data and developing visualizations is to set [blank] among tables to exploit any database structure.
relationships
To create a table visualization in [blank] view in Power BI, click on the Table icon in the visualizations area and then select the appropriate fields.
report
Part of understanding the data is to find relevant [blank] for the data.
sources
Part of getting the Excel data is to convert the raw data into [blank].
tables
Line charts typically are used to show values over [blank].
time
Pie charts are typically used to show the composition of a [blank].
whole