Sri Balaji University, Pune (SBUP)
ASSIGNMENT (15 MARKS)
Name of Course Data Visualisation Using Tableau
Name of Assignment Create an Interactive Dashboard in Tableau
using at least 8 Visual Elements to represent the
given data for decision making
Specialization PM & HR
Semester II
Learning Outcome Handling large complex datasets to provide real-
time analytics by building interactive dashboards.
Deciding the types of visuals, dashboard layout
and elements on the dashboard. Rendering
insightfulness and key decision metrics.
Nature of Assignment Dashboard / Infographic
Date of Assignment 16th January 2025
Assignment Deadline 15th February 2025
Instructions to Students
The attached Tableau Assignment 01_Data.xlsx data file talks about a fictitious company and
its HR data set contains names, DOBs, age, gender, marital status, date of hire, reasons for
termination, department, whether they are active or terminated, position title, pay rate, manager
name, and performance score.
Create a Dashboard to include Visuals that answer the following questions:
-----------------------------------------------------------------------------------------------------
1. Is there any relationship between who a person works for and their performance score?
2. What is the overall diversity profile of the organization?
3. What are the best recruiting sources if the company wants to ensure a diverse
workforce in the organization?
4. Is it possible to predict as to who is going to get terminated and who isn't? What level
of accuracy be achieved in this prediction?
5. Are there areas of the company where pay is not equitable?
Guidelines for Submission
1. .twb file along with hardcopy of screenshots of the dashboards to be submitted to
concerned faculty on A-4 papers.
2. The assignment carries 15 Marks and is to be done and submitted on INDIVIDUAL
BASIS.
3. Please find the attached Sample Rubrics, the actual rubric will change as per the
assignment and subject
Rubrics for Evaluation:
Parameters Poor Average Good Excellent
/ Grade (0-4) Marks (5-8) Marks (9-12) Marks (13-15) Marks
Choosing of Use of Using simple Selecting charts / Tailoring charts to
Visuals / inappropriate charts without visuals that best the specific data
Charts chart / visual much represent data and and audience,
types. customization are properly using advanced
which lacks formatted. features like dual-
impact axis charts or
custom shapes.
Visual No use / Overuse Using default or Using multiple and Creating / using
Design & of Colours. standard colour right colours and Third Party
Clarity Including too schemes and layouts for Visuals that allow
much or too less layout which highlighting key users to filter and
information don’t enhance data points. All Axis drill down into the
leading to the data story Labels and titles are data for more
confusion clear and insights.
informative
Use of Not cleaning or Applying simple Incorporating Utilizing
Tableau preparing data filters and interactive elements advanced
Features properly before sorting options, like filters, analytics features
importing it into which help but parameters, and like trend lines,
Tableau, leading don’t fully actions to allow forecasting, and
to inaccurate or leverage users to explore the clustering to
misleading Tableau’s data. provide deeper
visualizations. capabilities insights.
Insightfulne Only presenting Identifying and Conducting a Using a
ss and basic statistics or presenting thorough analysis combination of
Analysis obvious trends trends but not that includes visuals to tell a
without deeper exploring the multiple compelling story,
analysis. underlying perspectives and guiding the viewer
causes or considers various through the data
implications. factors. with clear insights
and conclusions.
Overall Failing to Reporting Providing well- Crafting a
Presentation provide common metrics supported, compelling
background without tailoring impactful narrative that
information or them to the recommendations guides the
context that specific needs of that can drive audience through
helps explain the the audience or strategic decisions. the data,
data. project highlighting key
insights and their
implications.
Dr. Mittal Mohite
Controller of Examinations
