ACC 3510 Chapter 11: Data Analytics In Accounting: Tools And Practice
relationships
After connect to data sources in Tableau, the next step is to create relationships among the tables.
Blank 1: goal, objective, goals, or objectives
An important part of understanding the data involves questioning how the data supports the overall objective of the visualizations.
categorical
Dimensions in Tableau are categorical fields.
compare
For horizontal bar charts, the purpose is to compare information among categories.
relationships
In Power BI, the relationships view allows you to set connections among tables.
icon
In the Power BI report view, the Visualizations area allows you to click on an icon to select specific types of charts or visualizations.
dashed line.
In the relationships view in Power BI, inactive relationships are shown with a dashed line.
time
Line charts typically are used to show values over time.
numeric
Measures are numeric fields.
data
On the left, the Power BI report view screen shows icons representing the three different views: report, data, and relationships.
tables
Part of getting the Excel data is to convert the raw data into tables.
sources
Part of understanding the data is to find relevant sources for the data.
whole
Pie charts are typically used to show the composition of a whole.
data view
The data view in Power BI lets you calculate new fields and set formatting for fields, such as currency fields.
obtain
The first step in preparing the data and developing visualizations is to obtain data.
Blank 1: relationships or associations
The second step in preparing the data and developing visualizations is to set relationships among tables to exploit any database structure.
report
To create a table visualization in report view in Power BI, click on the Table icon in the visualizations area and then select the appropriate fields.
primary keys
To create relationships among Excel tables, you link foreign keys to primary keys.
fields
To use the Tableau Show Me tool, select one or more of the fields of interest while holding down the control (CTRL) key.
categories
Treemaps show relationships among nested categories.
True
True or false: Bar charts compare information among categories.
False
True or false: Excel is always the best visualization tool.
False
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
True or false: In Tableau, there is one best type of visualization for each combination of dimensions and measures.
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.
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.
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.
metrics
Understanding the data also includes selection of appropriate metrics.
categories
Vertical column charts typically show fewer categories than horizontal bar charts.
circles
When joining two tables in Tableau, the overlapping circles indicate the type of join.
Microsoft Access
Which of the following is NOT a well-known visualization tool? Microsoft Excel Power BI Desktop Microsoft Access SPSS Statistical Software
Set relationships among tables
Which of the following is NOT part of selecting and modifying the visualization? Select relevant filters Add titles, legends, colors as appropriate Select the right type of chart Ensure clear presentation of message Set relationships among tables
Data visualizations are the only way to present data
Which of the following is NOT true about data visualizations. Data visualizations are the only way to present data There are many ways to develop data visualizations Data visualizations are graphical representations Data visualizations present information to decision makers
They show distribution of a single variable
Which of the following is NOT true about line charts? They show distribution of a single variable They compare categorical information They show values over time They show trends
They compare values across time
Which of the following is NOT true of pie charts? They compare values across time They can only show positive numbers They should be limited to a relatively small number of slices They show composition of a whole
Name
You can use Value Field Settings to specify a Custom Name for a field.
Pie charts
treemaps are similar in purpose to which of the following charts? Vertical column charts Line charts Horizontal bar charts Pie charts
