Difference between revisions of "ISSS608 2017-18 T3 Assign Manu George Mathew Q1"
(3 intermediate revisions by the same user not shown) | |||
Line 43: | Line 43: | ||
<font size="5"><font color="#ae946e">'''Visualization and Analysis'''</font></font> | <font size="5"><font color="#ae946e">'''Visualization and Analysis'''</font></font> | ||
− | + | ||
<table border='1'> | <table border='1'> | ||
<tr> | <tr> | ||
− | <th>Description</th> | + | <th>Description</th> |
− | <th>Illustration</th> | + | <th>Illustration</th> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 1.The expansion of Kasios </b> | + | <td> |
− | <br>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 | + | <b> 1.The expansion of Kasios </b> |
− | 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. | + | <br>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. |
− | </td> | + | </td> |
− | <td>[[File:mgm_Q1_1.jpg|500px|center]]</td> | + | <td> |
+ | [[File:mgm_Q1_1.jpg|500px|center]] | ||
+ | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 2.Hiring and Attrition Patterns at Kasios </b> | + | <td> |
− | <br>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. | + | <b> 2.Hiring and Attrition Patterns at Kasios </b> |
− | </td> | + | <br>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. |
− | <td>[[File:mgm_Q1_2.jpg|500px|center]]</td> | + | </td> |
+ | <td> | ||
+ | [[File:mgm_Q1_2.jpg|500px|center]] | ||
+ | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 3.Change in Communication and Purchase patterns over Time</b> | + | <td> |
− | <br>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 | + | <b> 3.Change in Communication and Purchase patterns over Time</b> |
+ | <br>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 | ||
− | <ol> | + | <ol> |
− | <li>Counts of Calls, Emails and Meetings over time</li> | + | <li>Counts of Calls, Emails and Meetings over time</li> |
− | <li>Median number of Connections per Employee over Time</li> | + | <li>Median number of Connections per Employee over Time</li> |
− | </ol> | + | </ol> |
− | <br>On the Purchase aspect, we are looking at the number of purchases over time in the company. | + | <br>On the Purchase aspect, we are looking at the number of purchases over time in the company. |
− | </td> | + | </td> |
− | <td> | + | <td> |
− | [[File:mgm_Q1_3.png|500px|center]] | + | [[File:mgm_Q1_3.png|500px|center]] |
− | + | Purchases over Time: | |
− | [[File:mgm_Q1_4.png| | + | [[File:mgm_Q1_4.png|400px|center]] |
+ | </td> | ||
</tr> | </tr> | ||
Line 86: | Line 93: | ||
<font size="5"><font color="#ae946e">'''Links and Guide to Dashboard'''</font></font> | <font size="5"><font color="#ae946e">'''Links and Guide to Dashboard'''</font></font> | ||
− | <p>The Dashboard's data size exceeded limits of Tableau Public. Thus it is currently | + | <p> |
+ | 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 [https://smu-my.sharepoint.com/:u:/g/personal/mgmathew_2017_mitb_smu_edu_sg/EW05NkgX3A5Nm-h6JiqDip8BjspXxjSq8_39pfnwVXdqEA?e=eNpaTx link] | ||
+ | </p> | ||
+ | |||
<font size="5"><font color="#ae946e">'''Insights'''</font></font> | <font size="5"><font color="#ae946e">'''Insights'''</font></font> | ||
<p>By using the above dashboards, we can infer that,</p> | <p>By using the above dashboards, we can infer that,</p> | ||
<ul> | <ul> | ||
− | + | <li>The company has been hiring at a steady pace since May 2015 based on the employee count.</li> | |
− | + | <li>But looking at the attrition count , <b>more and more employees seem to be leaving the company over time.</b></li> | |
− | + | <li>On the communications front, There is an <b>increasing trend in meetings over time.</b></li> | |
+ | <li>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</li> | ||
</ul> | </ul> |
Latest revision as of 17:42, 11 July 2018
|
|
|
|
|
|
|
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
|
|
2.Hiring and Attrition Patterns at Kasios
|
|
3.Change in Communication and Purchase patterns over Time
|
Purchases over Time: |
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