RVS COLLEGE OF ARTS AND SCIENCE(AUTONOMOUS)
Sulur, Coimbatore - 641 402
Name :
Register Number :
Class :
Subject :
RVS COLLEGE OF ARTS AND SCIENCE(AUTONOMOUS)
Sulur, Coimbatore - 641 402
REGISTER NUMBER
Certified that this is a bonafide record of................................................................................................
practical work done by Mr./Ms .................................................................................... … … …pursuing
. .............................................. …I / II / III / IV / V / VI semester during the academic year 2024-2025 .
Faculty HOD
Submitted for the Practical Examination held at RVS College of Arts and Science on................
Examiners:
Internal … … … … … … … … … … .. … .
External … … … … … … … . … … … . …
TABLE OF CONTENTS
EX.NO DATE CONTENT PAGE. SIGNATURE
NO
1. 10.12.2024 TABULAR DATASET FOR
NO.OF.SALES AND PROFIT
2. 17.12.2025 TOP 5 PROFITABLE PRODUCTS
3. 18.12.2025 VISUALIZATION FOR PROFIT
GENERATED OVER SALES
4. 4.1.2025 PERFORMANCE IN READING
AND APTITUDE TESTS
5. 10.1.2025 PREDICTING THE FUTURE
TRENDS OF THE SALE
6. 10.1.2025 CREATE A CUSTOM
TERRITORY FOR ASIA
7. 22.1.2025 STUDENTS PERFORMANCE IN
MATH,READING AND
WRITING
TEST BASED ON GENDER
8. 23.1.2025 DISCOUNT FOR EACH REGION
9. 29.1.2025 COMPARISION OF AVERAGE
MONTHLY INCOME BY
EDUCATION
10. 29.1.2025 CUSTOMER NAME BEGINS WITH “B”
11. 30.1.2025 PERCENTAGE OF SHIPPING COST
12. 13.2.2025 DASHBOARD USING
GLOBAL SUPERSTORE
13. 20.2.2025 DASHBOARD FOR COURSES
14. 26.2.2025 WATERFALL CHART FOR
PROFIT OVER A PERIOD OF
TIME
15. 5.3.2025 PARETO CHART FOR TOTAL OF
SUM OF SALES
16. 6.3.2025 FUNNEL CHART IN TABLEAU
1. Using Tableau 10 generate a Highlighted tabular dataset. Create a tabular dataset for no.
of sales and profit earned as per their subcategories. Highlight the Discount earned on
each
subcategory using colors. Hint: Use the dataset – Sample Superset
2. Find the top 5 profitable products and arrange them in ascending order based on their
number of sales.
3. Create the best possible Graphical Visualization for profit generated over sales for all the
distinct products available (with different ProductID)
4. Using data blending, create a report on Students’ Performance in Reading and Aptitude Tests
as both the data are captured on different systems
5. Use the global superstore 2016 to create a visualization predicting the precise future trends
of the sale of the product over 6 quarters
6. Using the dateset “GlobalSuperstore 2016”, create a custom territory for Asia (using lasso
tool), with detailed view of countries.
7. Suppose, you are given Student Personal Information and Students Academic Information and
you are asked to create a tableau report on showing Students performance in math, reading
and writing test based on Gender.
8. Find the discount for each region broken down by segment using Box and whiskers plot
9. Using the “Employee Attrition Dataset”, create a tableau report for: a. Employee Attrition
based on job role and distance from home b. Comparison of average monthly income by
education
and attrition
a.
b.
10. given the “Superstore” data, find the top 10 most profitable customers wherein the
customer name begins with ‘B’ .
Sort the view in descending order for the desired result.
11. Given the “Superstore” dataset, find the percentage of shipping cost for the top 10 products.
12. we are building a dashboard using Global Superstore Dataset
a. Click on the Sheet Tab and rename it as Running Total Profit By Segment ▪ Drag
Segment field onto the Columns Shelf and apply a filter by selecting only Consumer ▪
Drag Profit field on to the Rows Shelf and apply quick table calculation of Running Total
▪ Drag Order Date field on to the Columns shelf and make it continuous measure ▪ Drag
Category field on to the Colors Shelf ▪ Select Area chart option from the Marks Card
b. Add another sheet and rename it as Profit By Sub-Category ▪ Drag Sub-Category field
on to the Rows shelf and Profit field on to the Columns shelf ▪ Sort Sub-Category
into descending order ▪ Drag Category field on to the Colors shelf
c. Click the Dashboard Tab ▪ Drag Running Total Profit By Segment sheet on to the view
pane ▪ Drag Profit By Sub-Category sheet on to the view pane ▪ Now, we can interact
with the Dashboard using the Legends ▪ Select the Office Supplies option from the
Category Legend, only Office Supplies part will be highlighted on the views
Apply Filter
13. Create an Interactive dashboard for Edureka’s most popular courses available in the dataset,
by adding various forms of objects to it.
14. With the help of Waterfall Chart show how the profit start, end and gets incremented over
a period of time. Use the dataset global superstore 2016
15. Create a Pareto Chart for Running total of sum of sales. Use the dataset global superstore 2016
Thus,we created Pareto chart.
16. Create funnel and advanced funnel chart in tableau
Advanced funnel chart:
Create negative sales
