Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
Experiment Title#: Visual Encoding and Basic Dashboards in Tableau
Aim/Objective:
The experiment aims to address the following objectives:
1. Understanding visual encoding principles
2. Exploring Tableau's visualization capabilities
3. Creating effective visualizations
Pre-Requisites:
• Idea on Tableau Dashboard.
Pre-Lab:
1. What are pre-attentive attributes in Tableau?
2. What do you understand by the term “Dashboard”?
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 60 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
3. Why is there a need to create dashboards?
4. How is the Context Filter different from other Filters?
5. There is a huge demand for dashboard in Business Meetings. Why do you think
dashboards play a dominant role in understanding various aspects of the company and
how?
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 61 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
In-Lab:
1. For the given dataset [Link] that contains data about various football players, perform
the following tasks on separate sheets:
a. After connecting the data use the data interpreter and clean the data.
b. Create a horizontal bar chart to depict the International Reputation of various nations
on an avg.
c. Check if there is any relation between wage and position(left/right). If yes, describe
the relation.
d. Plot a bar chart against Avg. Heading Accuracy and Body Type. Find out which body
type has highest and least accuracy.
e. Create a yellow colored Tree Chart to depict the total penalties of each nation and
thus determine the highest and lowest.
f. Using the above sheets create a dashboard and write an analysis report of what
insights can be drawn from this.
2. Visualizing data can be very interesting when different features and interesting shapes
come into picture. Observe the below visualization carefully and jot down the insights
that you get from it. Based upon your insights try to recreate the given visualization for
the given Pokémon data set.
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 62 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
• Procedure/Program:
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 63 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 64 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
• Data and Results:
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 65 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
• Analysis and Inferences:
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 66 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
Sample VIVA-VOCE Questions (In-Lab):
1. Can you explain the concept of visual encoding and its importance in data visualization?
2. What are the key visual properties in Tableau that can be used for encoding data attributes?
Provide examples of how each property can be used to represent different types of data.
3. How does the choice of visual encoding impact the communication of information and
insights in a visualization?
4. Can you discuss the principles of effective visual encoding, such as using appropriate scales,
color schemes, and sizes for data attributes?
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 67 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
• Analysis and Inferences:
(For Evaluator’s use only)
Evaluator Remark (if Any):
Marks Secured: _____out of 50
Signature of the Evaluator with Date
Evaluator MUST ask Viva-voce prior to signing and posting marks for each experiment
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 71 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
• Data and Results:
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 70 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 69 of 141
Experiment # <TO BE FILLED BY STUDENT> Student ID <TO BE FILLED BY STUDENT>
Date <TO BE FILLED BY STUDENT> Student Name <TO BE FILLED BY STUDENT>
Post-Lab:
1. For given COVID-19 dataset that contains data regarding the cases in US. Create a dashboard
which includes the below given visualizations. Make an analysis report on the same.
i. A map showing count of positive cases in different states of US.
ii. A bar graph showing which state is having highest count of positive cases and
represent deaths with the help of colour of the bar graph
iii. A side by side bar graph which shows count of both deaths and cases on monthly
scale.
• Procedure/Program:
Course Title <TO BE FILLED BY CC> ACADEMIC YEAR: 2023-24
Course Code(s) <TO BE FILLED BY CC AND MUST INCLUDE ALL R,A,P CODES> Page 68 of 141
