0% found this document useful (0 votes)
11 views3 pages

Interactive Tableau Dashboard Assignment

The assignment for the Data Visualisation Using Tableau course at Sri Balaji University requires students to create an interactive dashboard using at least 8 visual elements to analyze HR data from a fictitious company. The dashboard must address specific questions related to performance scores, diversity, recruitment sources, termination predictions, and pay equity. The assignment is due on February 15, 2025, and will be evaluated based on various criteria including visual choice, design clarity, use of Tableau features, insightful analysis, and overall presentation.

Uploaded by

anshita digwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views3 pages

Interactive Tableau Dashboard Assignment

The assignment for the Data Visualisation Using Tableau course at Sri Balaji University requires students to create an interactive dashboard using at least 8 visual elements to analyze HR data from a fictitious company. The dashboard must address specific questions related to performance scores, diversity, recruitment sources, termination predictions, and pay equity. The assignment is due on February 15, 2025, and will be evaluated based on various criteria including visual choice, design clarity, use of Tableau features, insightful analysis, and overall presentation.

Uploaded by

anshita digwani
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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

Common questions

Powered by AI

Dashboards offer dynamic visual representations that can reveal patterns and trends not easily discernible in static HR reports. They allow users to interact with the data through features like filters and drill-downs, which can uncover relationships and variances over time or across different demographics. For example, a dashboard could track performance metrics across departments and reveal seasonal productivity trends or highlight retention issues in specific roles. By providing real-time analysis and offering the ability to forecast future trends, dashboards enable a more proactive approach to HR management .

Interactive elements in a Tableau dashboard, such as filters, parameters, and actions, allow users to engage directly with the HR data, facilitating deeper exploration and understanding. These elements enable decision-makers to dynamically adjust views and gain insights from multiple perspectives, uncovering patterns or correlations that static data presentation may obscure. They also enhance user experience by allowing detailed queries and data slicing, which can lead to more precise and relevant insights, thus influencing strategic HR decisions effectively .

Tableau dashboards can synthesize complex HR datasets into actionable insights, facilitating strategic recommendations by visualizing trends, identifying gaps, and predicting outcomes. Insights derived from dashboards can guide decisions on workforce planning, diversity enhancements, and performance improvements. For instance, analyzing pay equity and performance correlations can lead to informed compensation adjustments, while projected turnover trends might prompt strategic retention initiatives. Dashboards crafted with compelling narratives can convey these insights effectively to decision-makers, aligning HR strategies with organizational goals .

Selecting visual elements in a Tableau dashboard should be based on how well they represent the data and communicate insights effectively. The criteria include choosing the right type of charts (e.g., dual-axis charts or custom shapes) that tailor the visuals to audience needs, using colors strategically to highlight key data points, and ensuring axis labels and titles are clear. Incorporating third-party visuals for filtering and drilling down into the data can enhance interactive exploration. Advanced Tableau features like trend lines, forecasting, and clustering should be utilized to provide deeper insights into HR metrics .

Visual design and clarity are crucial in Tableau dashboards because they directly impact the viewer's ability to interpret and understand the information presented. A well-designed dashboard uses appropriate visuals, layouts, and colors to highlight key data points, which aids in clearer communication of insights. Cluttered designs or confusing labels can obscure important metrics, hindering decision-making processes. By ensuring axis labels and titles are clear, and by avoiding unnecessary complexity, dashboards can effectively guide viewers through the data narrative, enhancing comprehension and retention .

Best practices for using Tableau's advanced features include first ensuring quality data preparation to avoid inaccurate visualizations. Understanding the context and objective of the analysis is crucial before applying trend lines to observe temporal data changes or forecasting for predicting future trends. Clustering should be used to identify natural groupings within the data, such as performance score clusters to inform HR strategies. Interpreting these advanced analytics correctly helps build compelling narratives within dashboards, empowering users to make informed decisions based on robust insights .

An interactive dashboard in Tableau allows users to handle complex HR datasets efficiently by providing real-time analytics and insights. It enables decision-making by visually representing key metrics such as performance scores, diversity profiles, and equity in pay across departments. By integrating features like filters, parameters, and actions, users can explore data deeply to derive actionable insights. For instance, visuals can reveal the relationship between managerial influence and employee performance or identify recruiting sources that promote workforce diversity. Trend lines and forecasting can predict employee terminations with considerable accuracy, offering strategic foresight .

Ensuring equitable pay across departments can present challenges such as identifying pay discrepancies that aren't immediately apparent due to the large and complex datasets typically involved. Tableau dashboards can highlight these areas by visualizing salary distributions and comparing them against departmental performance metrics and demographics. Challenges also include mitigating subjective biases in performance evaluations that influence pay decisions and ensuring transparency in how pay structures are formed across different levels and roles within the organization .

Tableau dashboards can correlate the diversity profile of an organization with its recruiting sources by visualizing demographic distributions across different hire sources. By analyzing patterns and trends, Tableau can identify which sources consistently yield a more diverse applicant pool, such as universities with varied student bodies or job fairs. This helps HR departments focus their recruiting efforts towards these sources to enhance diversity, thus fostering an inclusive work environment. Dashboards can provide insights by comparing recruiting outcomes with company diversity goals, offering strategic direction for future recruitment planning .

Data analytics in Tableau can predict employee terminations by analyzing patterns such as performance scores, department trends, and past termination reasons. By employing advanced analytics features like clustering and forecasting, Tableau can model which factors contribute most significantly to terminations. The accuracy of these predictions depends on the quality and granularity of the available data, and while exact accuracy levels require empirical validation, integrating multiple perspectives typically enhances predictive power. A high degree of accuracy can be achieved by iteratively refining models based on historical data and identified trends .

You might also like