Tuesday, March 20, 2018

Tableau a tool in analysis of attrition

I have experience in few tools for data visualisation. Among those I believe Tableau is a versatile tool .
Can Tableau be used as a tool for data analysis and prediction. A work is made to understand the data of employee attrition using Spss Modeler. The CART alogirthm classifies based on the users requirements and gives a detailed analysis.
The same data is used in the tableau for visualisation.
Even though Spss modeler has features to draw graph- the  graph board, Tableau has options to drill down, filter, and abilities which can be easily made and understandable.( Cognos BI too has the ability).
A sample data of attrition  of employees need to be analysed. How was the problem approched ?
Is it significant ? can we pin point women attrition ?
All the above questions were answered in one single dashboard / storyboard in Tableau.
I shall present those and give a brief outline about them.


  1. In the above visualisation, the first attempt was made to identify the count of  women attrition.
  2. Department wise distribution was taken
  3. How many of them were in the current role ? This gives an understanding that majority were in the first fews years .
  4. Is there any relation with the marital status?
  5. The major factor - single women is identified.
  6. What % of single women is  leaving the organisation
  7. Is travel a factor?
  8. Tableau has options to get detailed analysis in one single page the dashboard and the storyboard can convert it into the required format.
  9. The above is a sample of the workdone to analyse how the information can be split , viewed and used in gaining Business Intelligence.
All these above in the dashboard is not only useful for getting the visualisation of the past, but also helps in getting future predictions about attrition.

No comments:

Post a Comment