Difference between revisions of "ISSS608 2017-18 T3 Assign Joel Choo Peng Yeow Company Growth"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 42: Line 42:
 
With an interactive dashboard constructed in tableau, we would like to find out if the company is growing and have they changed over time. According to the company’s communications and purchase habits, we will investigate the overall transactions across time and also its respective breakdown by Calls, Emails, Meetings & Purchases.
 
With an interactive dashboard constructed in tableau, we would like to find out if the company is growing and have they changed over time. According to the company’s communications and purchase habits, we will investigate the overall transactions across time and also its respective breakdown by Calls, Emails, Meetings & Purchases.
  
The dashboard consist of 4 components, selecting the filter will however only change 3 of the graphs indicated below.  
+
The dashboard consist of 4 components, selecting the filter will however only change 3 of the graphs indicated below.
 +
As of today, there have been around 26 million transactions and majority of then comes from emails (55.86%) and calls (40.72%). In its first month, there have been lesser records and when June came, the number of records have spiked and remain steady ever since. In terms of growth, they have probably retained the same number of headcounts since 2015.
 +
 
 +
Interestingly, when we look at the monthly movements graph, May was the only month where there have been a spike between 2015 and 2016.
  
 
[[File:Joel Intro.png||1000px]]
 
[[File:Joel Intro.png||1000px]]
Line 56: Line 59:
  
 
===Breakdown: Calls, Emails & Purchases===
 
===Breakdown: Calls, Emails & Purchases===
 +
Calls and emails have identical trends compared the overall company’s records. This is not surprising since they make up the bulk of the records.
 +
 +
As for purchases, they too have the same trends as the overall company’s records and have not seen a significant increase in purchases since June 2015.
 +
 
'''Calls'''<br>
 
'''Calls'''<br>
 
[[File:Joel Calls.png||1000px]]<br>
 
[[File:Joel Calls.png||1000px]]<br>
Line 67: Line 74:
  
 
===Breakdown: Meetings===
 
===Breakdown: Meetings===
If the dumping indeed took place, one would expect that <i> other birds species in this dumping area would also decrease in population </i> as they would migrate elsewhere or die from the dumping substance, not just affecting the Rose Pipits.
+
There have been an exponential increase in the number of meetings held in the organisation. In May 2015, they started out with only 15 meetings in the month and have climbed to an astonishing record of 10,633.
 
 
Other species that are dominantly clustered around the dumping site include the Ordinary Snape and Lesser Birchbeere. As such, these two species should also be affected by the dumping, if dumping indeed happened.
 
 
 
We will thus use <b> Ordinary Snape (OS) and Lesser Birchbeere (LB)</b> as our Control Group, and <b> Rose-Crested Blue Pipits (Rose Pipit) </b> as our Treatment Group.
 
 
 
<hr/>
 
 
 
===Breakdown: Purchases===
 
If the dumping indeed took place, one would expect that <i> other birds species in this dumping area would also decrease in population </i> as they would migrate elsewhere or die from the dumping substance, not just affecting the Rose Pipits.
 
 
 
Other species that are dominantly clustered around the dumping site include the Ordinary Snape and Lesser Birchbeere. As such, these two species should also be affected by the dumping, if dumping indeed happened.  
 
  
We will thus use <b> Ordinary Snape (OS) and Lesser Birchbeere (LB)</b> as our Control Group, and <b> Rose-Crested Blue Pipits (Rose Pipit) </b> as our Treatment Group.
+
Monthly movements across the years are similar across the months. <br>
  
 +
[[File:Joel Meetings.png||1000px]]
 
<hr/>
 
<hr/>

Revision as of 12:55, 8 July 2018

Joel MagnifyingGlass.png

"You See, But You Do Not Observe" - Sherlock
Looking Deeper Into The Network Of Connected Individuals

Background

Methodology

Company Growth

Are You Guilty?

Conclusion

[Back To Assignments]

 


Kasios International - Have You Grown?

Overview

With an interactive dashboard constructed in tableau, we would like to find out if the company is growing and have they changed over time. According to the company’s communications and purchase habits, we will investigate the overall transactions across time and also its respective breakdown by Calls, Emails, Meetings & Purchases.

The dashboard consist of 4 components, selecting the filter will however only change 3 of the graphs indicated below. As of today, there have been around 26 million transactions and majority of then comes from emails (55.86%) and calls (40.72%). In its first month, there have been lesser records and when June came, the number of records have spiked and remain steady ever since. In terms of growth, they have probably retained the same number of headcounts since 2015.

Interestingly, when we look at the monthly movements graph, May was the only month where there have been a spike between 2015 and 2016.

Joel Intro.png


Breakdown: Calls

To characterize the pattern relative to the alleged dumping site (blue triangle), the following facet plot shows the clustering patterns by Bird Species, independent of time.

From the cluster locations, we can see that the Rose-Crested Blue Pipits are clustered around the alleged dumping site, explaining why the 15 test birds provided are claimed to be Rose-Crested Blue Pipits to prove the allegation wrong. We can use this facet plot to have a good overview of other bird species’ cluster locations, such as the Ordinary Snape and Lesser Birchbeere being also clustered near to the Dumping Site.


Breakdown: Calls, Emails & Purchases

Calls and emails have identical trends compared the overall company’s records. This is not surprising since they make up the bulk of the records.

As for purchases, they too have the same trends as the overall company’s records and have not seen a significant increase in purchases since June 2015.

Calls
Joel Calls.png

Emails
Joel Emails.png

Purchases
Joel Purchases.png


Breakdown: Meetings

There have been an exponential increase in the number of meetings held in the organisation. In May 2015, they started out with only 15 meetings in the month and have climbed to an astonishing record of 10,633.

Monthly movements across the years are similar across the months.

Joel Meetings.png