Kombat Syndicate statistical data v2.0

Mac.

The Dutch Noob
Honorable Member
Kombat Syndicate
May 14, 2016
1,053
1,868
108
27
Eindhoven, The Netherlands
Hello guys,

as most of you have probably seen, on the old forum I had a topic about particular data of KS and its members and forum.
This week I still have some days off from work, so I decided to redo the work I already did a few months ago, made it up-to-date and elaborated it.

______________
The dashboard


The result is below and divided into three sections:
- Page 1: Forumdata regarding topics, joinrequests and banrequests.
- Page 2: Forumdata regarding memberfluctuations, joinrequests and unbanrequests.
- Page 3: Memberdata regarding postcounts, likecounts and banrequests created.

Page 1:
Zvtm4OI.png


Page 2:
26tuTK5.png


Page 3:
cwO5Rf8.png


_____________
Definitions


I could image that some of you might have som questions about certain terms and visualisations, so below some brief explanations:
  • Chance of joining: Calculated by [ Accepted requests / Total requests ] and shows the rate in how likely it is to get your application accepted.
  • (Un)banrequest success: Calculated by [ Accepted requests / Total requests ] and shows the rate in how likely it is to get your (un)banrequest accepted.
  • Likes per post ratio: Calculated by [ Total likes / Total posts ] nd shows the ratio between likes and posts for each member. Where 1.00 means a member has an equal amount of posts and likes; and anything higher than 1.00 means a member has more likes than posts. Vice versa.
_____________
Conclusions


So, what quick conclusions can be drawn from this data?
  • Since 2016 the chance of getting your join-application accepted has drastically dropped. In 2015, a rate of 70% was common, while in 2016 a rate of 25% is very common. Have we become more strict? Or are the applicants simply not sufficient anymore?
  • On average 89% of all banrequests created by our members have been accepted and thus this means that our members are doing a good job reporting hackers!
  • On the other hand, 68% of all unbanrequests are also getting accepted. Does this mean wrong people are getting banned? Or are we too ''soft''?
______________
Suggestions?


If anyone has any suggestions of data that can be analyzed, feel free to tell me and I'll see what I can do! :)

______________
Sourcedata


For those interested in what the sourcedata is and which tools I used:
  • I used Microsoft Excel to create the datasets. This Excel-sheet can be downloaded here for those interested.
  • For the visualisations, I used Microsoft Power BI. I've been working with this data-analytics tool for 6 months during my internship/studies, so I'm kinda experienced in using it. You can download the actual dashboard pages here but you'll need to have Power BI installed in order to open it.
______________

Hope you like it :) I'll see how much I can keep this up-to-date.

Best regards,
~ Mac.
 

Hary

Imagine,Believe,Achieve.
Honorable Member
May 15, 2016
5,369
8,041
108
27
wow wonderful analytical and statistical work there :D Nice job @Mac :)
Is it possible to display an overall data of this?I mean like an "overall conclusion" of all the above charts? Just like a difference between 2015 and 2016 based on everything that happened. I don't have a clear idea for it maybe you could put some sense through it if possible.

All in all, these charts are damn good. Good job again :)
 
  • Like
Reactions: Perfectionist

neRo!

Leader
Staff member
Leader
Kombat Syndicate
Recruitment Team
Ban & Unban Team
Donating Member
May 14, 2016
2,237
2,915
158
Very nice work :) Interesting :)


_____________
Conclusions


So, what quick conclusions can be drawn from this data?
  • Since 2016 the chance of getting your join-application accepted has drastically dropped. In 2015, a rate of 70% was common, while in 2016 a rate of 25% is very common. Have we become more strict? Or are the applicants simply not sufficient anymore?
  • On average 89% of all banrequests created by our members have been accepted and thus this means that our members are doing a good job reporting hackers!
  • On the other hand, 68% of all unbanrequests are also getting accepted. Does this mean wrong people are getting banned? Or are we too ''soft''?
As for the first point:
In the recent weeks the amout of applications increased significantly because our servers are running stable and are well populated. Unfortunately most of these many applications were not convincing at all due to lack of activity/interest/efforts etc. which is a reason why we became more strict in recruiting people. But also for the fact that we got 70+ members and are doing quite well, we are watching out for people who will be reliable to keep up the quality of our member setup. Thus the the poor applications become less relevant for us.

In my opinion we should give our the best to receive as many people as we can because we still have capacity to get bigger and to keep the well member setup, though this also depends on the interest displayed by the members. As our main priority is to get reliable members, we also have to weigh whether to accept an application or not.
It's a pity to see that we denied many applicants who appeared recently, but to be honest, it's obvious that it's necessary to put at least a bit effort in an application and show interest. I know that many people of the mw3 community have problems with the english language, so I can comprehend if someone doesn't use decent english or barely can explain himself in an application. But showing interest in being active, staying in communication with us, showing a bit off their personality is not a big deal and which is rather important for me than the quality of speech. Unfortunately lack of activty and communication were the main reasons to deny the recent applications though, I guess.

Second point:
The high rate of valid reports looks good and shows that our members, but also players who reported, are doing a reliable job.

Third point:
The result of this ratio could have different reasons. Surely some bans were done wrongly, maybe because members didn't spectate enough to get sufficient proof or just because they did a mistake as we are only humans and some members need to gain experience in spotting hackers.
But recently there were many unban requests due to camping. Actually because they got the "1005 invalid connection" message which appears after the tempban expired. For this reason the case needed to be solved manually. Noticed WilD1 about the fact that tempbans turned into a kind of permban, and this problem should be fixed asap. Of course those cases can be solved if an affected players appears here, but until it's fixed maybe to try to prevent tempbanning players for slight reasons such as camping, rather kick them so far.
 

WatchMiltan

Honorable Member
Honorable Member
May 14, 2016
1,575
1,998
158
Very interesting! Thank you :) I would like to add that the chance of getting accepted almost everytime depends on the questions Why are you interested in joining [TsG]? and What skills and attributes can you add to the community? The probablity of these questions getting answered correctly is about 1 % :D
 

Hary

Imagine,Believe,Achieve.
Honorable Member
May 15, 2016
5,369
8,041
108
27
Very interesting! Thank you :) I would like to add that the chance of getting accepted almost everytime depends on the questions Why are you interested in joining [TsG]? and What skills and attributes can you add to the community? The probablity of these questions getting answered correctly is about 1 % :D
You're goddamn right :D
 
  • Like
Reactions: Perfectionist

ArkantoS

Active Member
May 14, 2016
248
232
38
33
my accepted banrequests is just 75% ?? :eek:
@CntrlAltDel is a hacker slayer ,, :D 22 banrequests ,,

thank you man ,, really
it is an amazing and very helpful and informative work you have put there ,,

just like @Hary said ,, we need to know the deference between 2015 and 2016 ,,
especially regarding the number of join requests ,, to see how popular KS became over the time ,,
 

Mac.

The Dutch Noob
Honorable Member
Kombat Syndicate
May 14, 2016
1,053
1,868
108
27
Eindhoven, The Netherlands
my accepted banrequests is just 75% ?? :eek:
@CntrlAltDel is a hacker slayer ,, :D 22 banrequests ,,

Well, you have to take into account that this is just about the banrequests from May 2016 - August 2016. All banrequests before this period were on the old forum, so I can't use that data anymore ;)

wow wonderful analytical and statistical work there :D Nice job @Mac :)
Is it possible to display an overall data of this?I mean like an "overall conclusion" of all the above charts? Just like a difference between 2015 and 2016 based on everything that happened. I don't have a clear idea for it maybe you could put some sense through it if possible.

All in all, these charts are damn good. Good job again :)

I could give that a shot; create a bigger overview (like a summary). :)
But for example about the banrequests, like I said to Arkantos, I only have the data of those from May 2016 - August 2016 due to getting a new forum, so can't compare this subject with previous year.

But I'll see what I can do for the rest :)
 

LeiTRoSaS

Help and Respect
Honorable Member
May 14, 2016
4,376
5,039
108
Portugal
Very interesting! Thank you :) I would like to add that the chance of getting accepted almost everytime depends on the questions Why are you interested in joining [TsG]? and What skills and attributes can you add to the community? The probablity of these questions getting answered correctly is about 1 % :D
To analize it correctly, we also need to understand that most of teknomw3 players r kids. Finding maturity enought is kinda difficult around all tekno servers.
 
  • Like
Reactions: Perfectionist

neRo!

Leader
Staff member
Leader
Kombat Syndicate
Recruitment Team
Ban & Unban Team
Donating Member
May 14, 2016
2,237
2,915
158
Very interesting! Thank you :) I would like to add that the chance of getting accepted almost everytime depends on the questions Why are you interested in joining [TsG]? and What skills and attributes can you add to the community? The probablity of these questions getting answered correctly is about 1 % :D
To analize it correctly, we also need to understand that most of teknomw3 players r kids. Finding maturity enought is kinda difficult around all tekno servers.
I don't think that denials only depends on that question, but I am sure that many people mistake this question. That's why I am also thinking about changing that question or at least adding a similar question like Hary suggested in another thread.
 

LeiTRoSaS

Help and Respect
Honorable Member
May 14, 2016
4,376
5,039
108
Portugal
I don't think that denials only depends on that question, but I am sure that many people mistake this question. That's why I am also thinking about changing that question or at least adding a similar question like Hary suggested in another thread.
the denies happens cz they dont put effort enough. kids that only want to be in a clan. of corse they fail in the hard one. have u ever went to cod facebook or forum. did u check how they are and speak? a bunsh of kids. it seems that we are from one reality and they belong to another completly different.
as i stated i that thread. the question is not a problem. is a ANSWOME Filtrating method. i <3 it :)
sincerly i don think u should change it. cz all of them have the 2nd chance to answer it.
(ps: if u change i'll stop my 2nd chances ;))
 
  • Like
Reactions: Perfectionist

Hary

Imagine,Believe,Achieve.
Honorable Member
May 15, 2016
5,369
8,041
108
27
the denies happens cz they dont put effort enough. kids that only want to be in a clan. of corse they fail in the hard one. have u ever went to cod facebook or forum. did u check how they are and speak? a bunsh of kids. it seems that we are from one reality and they belong to another completly different.
as i stated i that thread. the question is not a problem. is a ANSWOME Filtrating method. i <3 it :)
sincerly i don think u should change it. cz all of them have the 2nd chance to answer it.
(ps: if u change i'll stop my 2nd chances ;))
Like i said, maybe we can add another question from the choices that i mentioned without changing the question which is now there ?Or..
 

Mac.

The Dutch Noob
Honorable Member
Kombat Syndicate
May 14, 2016
1,053
1,868
108
27
Eindhoven, The Netherlands
Okaay, stick to the topic lol :)

In some way it is still related to the topic :p
I mean, data being displayed has the goal to inform and give insights. Those insights instigate discussion ^^

Do you have any particular idea on how you're gonna keep it up-to-date? Is there like monthly changes or something of that ilk?

Well, not really, the only way to keep it up-to-date is by manually checking the numbers (e.g. the amount of topics for that month) and adding it to the dataset. So for now I can keep that up, but it actually takes up some time and when my studies start again, idk if I've got the time for it :p
 
  • Like
Reactions: Perfectionist