Some stats submission for SqlSatSlo 2015

October 1st 2015 was deadline for submitting the sessions for SQL Saturday Slovenia, taking place in Ljubljana on December 12th, 2015.

After closing the Call for Sessions, the result was, 121 Sessions submitted from 50 speakers coming from 20 different countries.

Simple data set (courtesy of Dejan):

id,SpeakersCount,SessionCount,country
1,1,1,Austria
2,2,6,Bulgaria
3,1,2,Canada
4,3,9,Denmark
5,6,17,Germany
6,1,2,Hungary
7,8,17,Italy
8,1,1,Macedonia
9,1,3,Netherlands
10,1,1,Norway
11,1,4,Poland
12,1,3,Portugal
13,1,2,Romania
14,1,2,Russia
15,1,1,Serbia
16,1,1,Slovakia
17,3,3,Slovenia
18,1,1,Sweden
19,12,36,UK
20,3,9,USA

After Dejan Sarka created first visualization for #sqlsatslovenia I have decided to play and goof around with simple dataset as well.

First the Treemap representing the number of sessions per country:

Treemap_sessionCount

Following is dendrogram, based on euclidean distance between groups, presented with 3 clusters. Keep in mind that dendrogram is representation of only two variables (SpeakersCount,SessionCount) which are also highly (and positive) correlated (our UK, German and Italian colleagues are super outliers, but we love them and they were not normalized). 🙂

Clusters_SQLSatSlovenia2015

Adding some more visualizations:

Sankey_Flow_levels

circos_pie

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s