GLOBAL ACADEMY OF TECHNOLOGY
Department of Artificial Intelligence and Data Science
Affiliated to VTU, Accredited by NAAC with 'A' grade
RR Nagar, Bengaluru – 560 098
(Accredited by NBA 2019-2022)
22ADS61: Data Visualization using Tableau
Question Bank
MODULE-1
Sl. No. Question Cognitive Level
1 What is Data Visualization? Where is it important? L2
(Understanding)
2 List and explain the advantages and disadvantages of Data L2
Visualization. (Understanding)
3 Explain the importance of Data Visualization. L2
(Understanding)
4 List and explain the Data Visualization tools. L2
(Understanding)
5 Explain the pillars of Data Visualization. L2
(Understanding)
6 Explain in detail the components of a chart. L2
(Understanding)
7 Illustrate with examples the rules in drawing a bar, pie chart. L3
(Applying)
8 Describe the chart aesthetics in Data Visualization. L2
(Understanding)
9 Illustrate through examples the best practices to be followed in L3
designing a dashboard. (Applying)
10 Explain with use cases the different chart types in Tableau. L2
(Understanding)
MODULE-2
11 Explain the conditions to be met in creating a good dataset. L2
(Understanding)
12 Explain the different types of Key Performance Indicators. L2
(Understanding)
13 Explain the different types of Dashboards. L2
(Understanding)
14 Write a note on storytelling with data. L2
(Understanding)
15 Define a dashboard. Discuss its properties. L2
(Understanding)
16 Define a storyboard. Discuss its properties. L2
(Understanding)
17 What is an infographic? Discuss its properties. L2
(Understanding)
18 Discuss the Duell rules for actionable visualizations. L2
(Understanding)
19 What is Tableau? Explain its features. L2
(Understanding)
20 Explain the pros and cons of Tableau. L2
(Understanding)
21 Explain the various Tableau tools. L2
(Understanding)
22 Explain in detail Tableau Desktop Workspace Menu. L2
(Understanding)
23 Write a note on Tableau navigation. L2
(Understanding)
24 Write a note on Tableau data terminologies. L2
(Understanding)
25 Explain the various data types in Tableau. L2
(Understanding)
26 Explain the various data aggregation functions available in Tableau. L2
(Understanding)
27 Write a note on Tableau file types. L2
(Understanding)
MODULE-3
28 Discuss the data extraction in Tableau. L2
(Understanding)
29 Illustrate data joining in Tableau. L3
(Applying)
30 Explain data blending in Tableau. L2
(Understanding)
31 Illustrate data sorting in Tableau. L3
(Applying)
32 Write a note on Tableau Field operations. L2
(Understanding)
33 Explain the components of Tableau calculation. L2
(Understanding)
34 Explain the various Tableau operators with their order of precedence of L2
operation. (Understanding)
35 Explain with examples the Tableau functions. L2
(Understanding)
36 Define Calculated Field. Explain steps to create it. L2
(Understanding)
37 Demonstrate the steps in creating a calculated field and using a numeric L3
function in it. (Applying)
38 Demonstrate the steps in creating a calculated field and using a string L3
function in it. (Applying)
39 Demonstrate the steps in creating a calculated field and using a date L3
function in it. (Applying)
40 Define Tableau LOD expression. Explain the types. L2
(Understanding)
41 Demonstrate the following using Calculated Field on the Amazon L3
(Applying)
dataset:
a) Round-off the Rating to zero decimal places and plot it against User
Name.
b) Obtain the plot of Rating versus first 4 characters of the Product
Name.
c) Capitalize only first letter of the Product Name and plot it against any
measure.
d) Find the length of the dimension “Product Id”.
e) Determine if there are null values in the Rating and replace it with
zero.
f) Convert the Product Name into upper case letters.
g) Find the average Sales Price.
h) Capitalize first character of every word under the Product Name and
plot it against Discounted Price.
i) Round-off the Actual Price to the nearest lowest integer and plot it
against Product Names starting with ‘AG’.
j) Draw a stacked bar plot depicting the Product Id with series B07Q
against Rating.
42 Demonstrate the following using Calculated Field on the Purchases L3
(Applying)
dataset:
a) Get the plot of Order Id versus Quantity and Purchase Price
which is rounded off to the next highest integer.
b) Plot of Brand starting with 8 versus the Size and Purchase price
rounded off to the nearest integer.
c) Plot of Purchase Price higher than 12 with the Brand and its
Description.
d) Plot of only the year of posting the product against the quantity
and dollars.
e) Plot of the day of receiving the product versus quantity and
purchase price.
43 Apply any three numeric and any two logical functions on the various L3
(Applying)
fields of the Purchases dataset.
44 Apply any three string and any two date functions on the various fields L3
(Applying)
of the Purchases dataset.
MODULE 4
45 Write a note on Tableau Basic Filters. L2
(Understanding)
46 Write a note on Tableau Filter operations. L2
(Understanding)
47 Explain how quick filters are accessed in Tableau. L2
(Understanding)
48 Write a note on Tableau extract filters. L2
(Understanding)
49 Why is context filter important? Explain the steps involved in creating L2
it. (Understanding)
50 Illustrate the steps in creating a condition filter in Tableau. L2
(Understanding)
51 Why is data source filter needed? Explain the procedure in selecting a L2
data source filter. (Understanding)
52 What is a Tableau Top filter? Explain steps in creating it. L3
(Applying)
53 Write a note Tableau Build Groups. L2
(Understanding)
54 Write a note Tableau Build Hierarchy. L2
(Understanding)
55 What are sets in Tableau. Illustrate the steps in building sets. L2
(Understanding)
56 What is a bar chart? Write instructions to create a bar chart on the L6
given Superstore data using Tableau. (Creating)
57 What is a line chart? Write instructions to create a line chart on the L6
given Superstore data using Tableau. (Creating)
58 What is a pie chart? Write instructions to create a pie chart on the L6
given Superstore data using Tableau. (Creating)
59 What is a bubble chart? Write instructions to create a bubble chart on L6
the given Superstore data using Tableau. (Creating)
60 What is a bump chart? Write instructions to create a bump chart on the L6
given Superstore data using Tableau. (Creating)
61 What is a bullet chart? Write instructions to create a bullet chart on the L6
given Superstore data using Tableau. (Creating)
62 What is a Gantt chart? Write instructions to create a Gantt chart on the L6
given Superstore data using Tableau. (Creating)
63 What is a Crosstab chart? Write instructions to create a Crosstab chart L6
on the given Superstore data using Tableau. (Creating)
64 What is a Motion chart? Write instructions to create a Motion chart on L6
the given Superstore data using Tableau. (Creating)
65 What is a Waterfall chart? Write instructions to create a Waterfall L6
chart on the given Superstore data using Tableau. (Creating)
66 What is an area chart? Write instructions to create an area chart on the L6
given Superstore data using Tableau. (Creating)
67 What is a Pareto chart? Write instructions to create a Pareto chart on L6
the given Superstore data using Tableau. (Creating)
68 What is a Dual axis chart? Write instructions to create a Dual axis L6
chart on the given Superstore data using Tableau. (Creating)
69 What is a Histogram? Write instructions to create a histogram on the L6
given Superstore data using Tableau. (Creating)
70 What is a Scatter plot? Write instructions to create a scatter plot on the L6
given Superstore data using Tableau. (Creating)
71 What is a Boxplot? Write instructions to create a Boxplot on the given L6
Superstore data using Tableau. (Creating)
72 What is a Heatmap? Write instructions to create a Heatmap on the L6
given Superstore data using Tableau. (Creating)
73 What is a Treemap? Write instructions to create a Treemap on the L6
given Superstore data using Tableau. (Creating)
74 Write the instructions to perform the following on Coffee Chain dataset L4
in Tableau: (Analyzing)
(i) Create a heat map for Product Type, State, and Profit. Identify
which state has the lowest profit for Espresso?
(ii) Using boxplot, identify which of the Espresso product has the
highest distribution of sales?
(iii) Create a bar chart with Product Type, Product, and Profit. Write
your conclusion.
(iv) Create a scatter plot with State, Sales, and Profit. Draw your
conclusion.
(v) Identify the state with the highest and the lowest profit in the
market?
(vi) What is the number of Sales in the state Nevada for the product
Decaf Expresso?
(vii) What is the contribution of tea (in percentage) to the
overall Profit?
(viii) What is the average marketing in the area code 660 and
818?
(ix) In California, which is the product with highest and lowest
profit?
(x) Identify through side-by-side circles, the minimum marketing
for the Coffee Beans Colombian product.
(xi) What is the contribution of sales in the East market for Decaf?
(xii) In 2012, what is the contribution of sales in the East
market for Decaf?
(xiii) What is the average profit for all the products starting
with C?
(xiv) In the Central region, the Top 5 Products by sales
contributed _____ % of the total sales.
(xv) In 2013, identify the state with the highest profit in the
West market.
(xvi) Identify the total expenses to sales ratio of the state with
the lowest profit.
(xvii) What is the distinct count of area codes for the state
with the lowest budget margin in small markets?
(xviii) In 2013, what is the percentage of total profit for Caffe
Mocha falling under Major Market?
(xix) In which month and year did the sales cross $1,100 for
Decaf in Colorado as well as Florida?
(xx) Using tree maps, identify the market with its size having
maximum budget sales.
75 Write the instructions to perform the following on Office Supplies L4
dataset in Tableau: (Analyzing)
(i) Find the average units offered by the representative Richard.
(ii) Find the total units offered by the representative Richard.
(iii) What is the unit price of all items starting with P?
(iv) Find the unit price of Binders in the West region.
(v) Find the items most sold by Richard.
(vi) What is the average unit price of Pen Set in the East
Region?
(vii) Which item is sold the most in July 2014?
(viii) Create a scatter plot depicting the relation between any 3
variables.
(ix) Create a highlight table depicting the relation between any 3
variables.
(x) Create a stacked bar chart depicting the relation between
region, item and units.
MODULE 5
76 Explain the various formatting options in Tableau. L2
(Understanding)
77 What is forecasting? Discuss the steps involved in creating a forecast. L2
(Understanding)
78 What are trend lines? Discuss the steps involved in creating a trend line. L2
(Understanding)
79 Explain Power BI and the reasons for using it. L2
(Understanding)
80 Describe the various components of Power BI. L2
(Understanding)
81 Discuss the various features of Power BI. L2
(Understanding)
82 Explain with a neat diagram the architecture of Power BI. L2
(Understanding)
83 Give the differences between Power BI and Tableau. L2
(Understanding)
84 Explain the visualization options available in Power BI. L2
(Understanding)
85 Define Data Analysis Expressions. Explain the following: L2
a) DAX Data types (Understanding)
b) DAX Formula
c) DAX Calculation
86 Explain with examples different types of DAX functions. L2
(Understanding)
