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#: Hierarchical Data and Topographical Data Visualizations in Tableau.
Aim/Objective:
The experiment aims to address the following objectives:
1. Understanding hierarchical data structures:
2. Exploring Tableau's capabilities for hierarchical data visualization
3. Visualizing topographical data
4. Applying visualization techniques to hierarchical and topographical data
Pre-Requisites:
• Idea on Hierarchical Data
• Idea on Topographical Data..
Pre-Lab:
1. Why is there a need for hierarchical and topographical kinds of data in real time?
2. Mention the various types of visualizations that can be done in Python for
Hierarchical and Topographical data.
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 72 of 228
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. Is there a need for the visualization to interact with the users? If yes, how can
they be implemented?
4. What is meant by actions in Tableau?
5. How can actions be implemented and what are the advantages of incorporating
actions into our visuals?
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 73 of 228
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. Vishal is appointed as a Food-Inspecting officer and is assigned a task to distinguish the
categories of food visually where in each food item falls into a sub-group and this sub-group
is a part of the main category. Help Vishal accomplish his task using data visualization
concepts in Tableau with appropriate technique and chart.
2. The given data set consists information about wages from various states and substates in
US. Create a geolocational Map on Tableau and incorporate basic actions such that when
clicked on any one of the states its substates should be shown and the tax returns filed. If
none of the states is clicked only the country with 5 divisions only.
• 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 74 of 228
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 75 of 228
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 76 of 228
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 77 of 228
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 hierarchical data and its relevance in data visualization?
Provide examples of real-world scenarios where hierarchical data structures are commonly
encountered.
2. How does Tableau support the visualization of hierarchical data? Discuss the different
visualization techniques or chart types that can be used in Tableau to represent hierarchical
relationships.
3. What are some challenges or considerations when visualizing hierarchical data in Tableau?
How can these challenges be addressed to create clear and meaningful visualizations?
4. Can you explain the concept of topographical data and its significance in data visualization?
Provide examples of applications where topographical data visualizations are commonly
used.
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 78 of 228
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. A supermarket company named Dango collected data regarding sales of their products and the
same is attached below. It is trying to understand its profits based on category, sub- category and
product segment. Help the company understand it in a better way by implementing Data
Visualization Concepts in Tableau.
• 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 79 of 228
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 80 of 228
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 81 of 228
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 82 of 228
