ISSS608 2017-18 T3 Assign Manu George Mathew Q1

From Visual Analytics and Applications
Jump to navigation Jump to search

MGM Title Band.jpg VAST Challenge 2018:Suspense at the Wildlife Preserve

Background

Data Preparation

Question 1

Question 2

Question 3

Conclusion

Back to Dropbox

 


Question:

Using the four large Kasios International data sets, combine the different sources to create a single picture of the company. Characterize changes in the company over time. According to the company’s communications and purchase habits, is the company growing?

Visualization and Analysis


Description Illustration

1.The expansion of Kasios
A close estimation of the company's size was obtained by plotting the number of Distinct Sources in the Data over time. The illustration shows the image of the dashboard used for analysis. Based on this, we can say that Kasios International is growing. From 11,084 employees in May 2015, it increased to 312,239 employees by end of Dec 2017.

Mgm Q1 1.jpg

2.Hiring and Attrition Patterns at Kasios
A static view of the employee count in a company does not give a clear picture of whether the company is growing. A better measure to look at will be talent aquisition and employee attrition. Thus, this dashboard aims to help us analyse the attrition and aquisition patterns in Kasios International.

Mgm Q1 2.jpg

3.Change in Communication and Purchase patterns over Time
These plots help us to identify the trend over time in communications and purchase patterns. On the communication aspect, we are looking at a dashboard to visualize

  1. Counts of Calls, Emails and Meetings over time
  2. Median number of Connections per Employee over Time


On the Purchase aspect, we are looking at the number of purchases over time in the company.

Mgm Q1 3.png

Purchases over Time:

Mgm Q1 4.png

Links and Guide to Dashboard

The Dashboard's data size exceeded limits of Tableau Public. Thus it is currently stored in OneDrive. Please Download and Extract the Same. It is available at this link


Insights

By using the above dashboards, we can infer that,

  • The company has been hiring at a steady pace since May 2015 based on the employee count.
  • But looking at the attrition count , more and more employees seem to be leaving the company over time.
  • On the communications front, There is an increasing trend in meetings over time.
  • The number of connections for a typical employee at Kasios have been getting smaller and smaller over time. this could show that the company is growing at a pace in which the teams are getting more isolated from each other