BUAN 132 Tableau Final Exam UPDATED
ACTUAL Exam Questions and
CORRECT Answers
File Menu - CORRECT ANSWER- ✔✔For any Windows program the file menu contains
New, Open, Close, Save, Save As, and Print, functions. The most frequently used feature
found in this menu is the Print to pdf option. This allows us to export our dashboard or
worksheet in pdf form. If you don't remember where Tableau places files, or you want to
change the default file-save location, use the repository location option for review the file and
change it. We can create a packaged workbook from the export packaged workbook option in
a fast manner.
Data Menu - CORRECT ANSWER- ✔✔You can use a data menu if you find some
interesting tabular data on a website that you want to analyze with Tableau. Highlight and
copy the data from the site, then use the Paste Data option to input it into Tableau. Once
pasted, then Tableau will copy the data from the Windows clipboard and add a data source in
the data window. The Edit Relationships menu option is used in data blending. This menu
option is needed if the field names are not identical in two different data sources. It allows
you to define the related fields correctly
Worksheet Menu - CORRECT ANSWER- ✔✔The Export option allows you to export the
worksheet as an Excel crosstab, an image, or in Access database file format. The Duplicate as
Crosstab option creates a crosstab version of the worksheet and places it in a new worksheet.
Shelf - CORRECT ANSWER- ✔✔is an area or window on the visualization screen where
you can drop pieces of data so that Tableau can
Dimension Shelf - CORRECT ANSWER- ✔✔The dimension presents in the data source for
example- customer (customer name, segment), order (order date, order id, ship date, and ship
mode), and location (country, state, and city) these all type of data source can be viewed in
the dimension shelf.
Measure Shelf - CORRECT ANSWER- ✔✔The measures present in the data source, for
example- Discount, Profit, Profit ratio, Quantity, and Sales- These all types of data source can
be viewed in the measure shelf.
, Marks Type - CORRECT ANSWER- ✔✔the type of visual element displayed in the View
section of the Tableau worksheet.
Worksheet - CORRECT ANSWER- ✔✔The worksheet is the space where the actual
visualization, design, and functionalities are viewed in the workbook. A worksheet can be
connected to one or more data sources (with linking/common fields) for its data.
Workbooks (.twb) - CORRECT ANSWER- ✔✔Tableau workbook files have the .twb file
extension. Workbooks hold one or more worksheets, plus zero or more dashboards and
stories.
Aggregation - CORRECT ANSWER- ✔✔Tableau will attempt to aggregate measures in the
view. This means that Tableau collects individual row values from your data source into a
single value that is adjusted to the level of detail in your view. Example aggregations include
data that is averaged (AVG), added (SUM), or set to the minimum (MIN) or maximum
(MAX) value from the individual row values. The Analysis menu can be used to toggle
between aggregated and disaggregated measures (will created more data point marks in the
view). The height of bars in a bar chart is determined by aggregating.
Calculated Field - CORRECT ANSWER- ✔✔A new field that you create by using a formula
to modify the existing fields in your data source. For example a calculate field named Cost
could be calculated by subtracting Profit from Sales.
Color Palette - CORRECT ANSWER- ✔✔Tableau offers three types of color palettes:
categorical, sequential/stepped, and quantitative/diverging.
Columns Shelf - CORRECT ANSWER- ✔✔A shelf at the top of the workbook that you can
use to create the columns of a data table. The shelf accepts any number of dimensions and
measures. When you place a dimension on the Columns shelf, Tableau creates headers (words
or labels) for the members of that dimension. When you place a measure on the Columns
shelf, Tableau creates quantitative axes that covers the range of values for that measure.
Dashboard - CORRECT ANSWER- ✔✔A collection of views shown in a single location
where you can compare and monitor a variety of data simultaneously.
ACTUAL Exam Questions and
CORRECT Answers
File Menu - CORRECT ANSWER- ✔✔For any Windows program the file menu contains
New, Open, Close, Save, Save As, and Print, functions. The most frequently used feature
found in this menu is the Print to pdf option. This allows us to export our dashboard or
worksheet in pdf form. If you don't remember where Tableau places files, or you want to
change the default file-save location, use the repository location option for review the file and
change it. We can create a packaged workbook from the export packaged workbook option in
a fast manner.
Data Menu - CORRECT ANSWER- ✔✔You can use a data menu if you find some
interesting tabular data on a website that you want to analyze with Tableau. Highlight and
copy the data from the site, then use the Paste Data option to input it into Tableau. Once
pasted, then Tableau will copy the data from the Windows clipboard and add a data source in
the data window. The Edit Relationships menu option is used in data blending. This menu
option is needed if the field names are not identical in two different data sources. It allows
you to define the related fields correctly
Worksheet Menu - CORRECT ANSWER- ✔✔The Export option allows you to export the
worksheet as an Excel crosstab, an image, or in Access database file format. The Duplicate as
Crosstab option creates a crosstab version of the worksheet and places it in a new worksheet.
Shelf - CORRECT ANSWER- ✔✔is an area or window on the visualization screen where
you can drop pieces of data so that Tableau can
Dimension Shelf - CORRECT ANSWER- ✔✔The dimension presents in the data source for
example- customer (customer name, segment), order (order date, order id, ship date, and ship
mode), and location (country, state, and city) these all type of data source can be viewed in
the dimension shelf.
Measure Shelf - CORRECT ANSWER- ✔✔The measures present in the data source, for
example- Discount, Profit, Profit ratio, Quantity, and Sales- These all types of data source can
be viewed in the measure shelf.
, Marks Type - CORRECT ANSWER- ✔✔the type of visual element displayed in the View
section of the Tableau worksheet.
Worksheet - CORRECT ANSWER- ✔✔The worksheet is the space where the actual
visualization, design, and functionalities are viewed in the workbook. A worksheet can be
connected to one or more data sources (with linking/common fields) for its data.
Workbooks (.twb) - CORRECT ANSWER- ✔✔Tableau workbook files have the .twb file
extension. Workbooks hold one or more worksheets, plus zero or more dashboards and
stories.
Aggregation - CORRECT ANSWER- ✔✔Tableau will attempt to aggregate measures in the
view. This means that Tableau collects individual row values from your data source into a
single value that is adjusted to the level of detail in your view. Example aggregations include
data that is averaged (AVG), added (SUM), or set to the minimum (MIN) or maximum
(MAX) value from the individual row values. The Analysis menu can be used to toggle
between aggregated and disaggregated measures (will created more data point marks in the
view). The height of bars in a bar chart is determined by aggregating.
Calculated Field - CORRECT ANSWER- ✔✔A new field that you create by using a formula
to modify the existing fields in your data source. For example a calculate field named Cost
could be calculated by subtracting Profit from Sales.
Color Palette - CORRECT ANSWER- ✔✔Tableau offers three types of color palettes:
categorical, sequential/stepped, and quantitative/diverging.
Columns Shelf - CORRECT ANSWER- ✔✔A shelf at the top of the workbook that you can
use to create the columns of a data table. The shelf accepts any number of dimensions and
measures. When you place a dimension on the Columns shelf, Tableau creates headers (words
or labels) for the members of that dimension. When you place a measure on the Columns
shelf, Tableau creates quantitative axes that covers the range of values for that measure.
Dashboard - CORRECT ANSWER- ✔✔A collection of views shown in a single location
where you can compare and monitor a variety of data simultaneously.
