Question

Which of the following reporting tools would you use to show the dimension "city" next to the dimension "source" in a report?

a) Date comparison
b) Table filter
c) Table sort
d) Plot rows
e) Primary dimension
f) Secondary dimension
g) Pie chart
h) Pivot table

Answer 1

To display the dimensions "city" and "source" side by side in a report, one should use a pivot table, a tool designed to handle multi-dimensional data display effectively.

Step-by-step explanation:

To show the dimension "city" next to the dimension "source" in a report, you would use h) Pivot table. This reporting tool allows you to display data in a two-dimensional table format, where one dimension is listed down the side (row labels), and another is listed across the top (column labels). In this case, you could set "city" as the row labels and "source" as the column labels to compare the data grouped by these two dimensions.

While other tools such as line graphs, pie charts, and bar graphs, are effective for showing parts of a whole or comparing quantitative data, they do not directly facilitate the displaying of two dimensions side by side in a table format. A pivot table, however, is specifically designed to handle such tasks efficiently and is often used for summarizing, analyzing, exploring, and presenting data in various business and technology reports.