Ch. 11 SmartBook

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

Chapter 8- Vascular Access and Medication Administration

View Set

chapter 13 15 16 che 4 homework falshcards continued

View Set

Exam 5 Women and Children Chapters: 12, 13, 14, 15, 19, 20, 21 PrepU

View Set

chapter 2 EMT, chapter 3 EMT, chapter 4 EMT, EMT chap1, EMT test, EMT, EMT Final Exam practice, Chapter 31 quiz EMT, Acronyms just names, EMT test1, EMT test2, EMT test5, EMT test3, EMT test4, EMT vocabs, Chapter 16 quiz EMT, Chapter 15 quiz EMT, Cha...

View Set

Fish in a Tree, Esperanza Rising comprehension questions, Counting by 7s by Holly Goldberg Sloan, "The Crossover" By Kwame Alexander

View Set