A couple of days ago, I made part 1, which is a 3D visualisation of where Steemit users are located. It was a lot of fun because it was also the first time I used PowerBI - a fantastic tool for data visualisations. Check out part 1 here: https://steemit.com/blockchainbi/@remuslord/where-are-all-the-steemit-users-around-the-world-oc
@plushzilla pointed out that it would be better to see the data on a normal map and perhaps across time. So that's what I've done here!
Since Tableau has an excellent (or good enough) location aggregator, and with some manual categorising I've managed to increase the number n of users in this analysis to around 170,000 from 30,000(!)
170k is about a 3rd-4th of the entire Steemit user base! So I think we've got an excellent approximation of the geographical distribution of users. I still think North America is underrepresented in the data because of the lower likelyhood of US users including US or USA. I tried to include some of the largest states manually.
Here is a gif of the accumulation of daily user profile updates to location (IMO a very close proxy to user registration). *I made it interactive, but Tableau Online is too sluggish on such a big database so that spoils the fun. Please let me know your feedback if you can spare a minute :)
You can watch the video in HD here: !
And the static graphs with comments:
Today's user base distribution: The map shows a relatively broad distribution across the world with pockets of popularity in North America, Europe, Nigeria, Venezuela, India, Malaysia, Indonesia.
Although the data for user updates seems to be jittery before June 2017, the user base is clearly dominated by North America and Europe. Over the last 6 months we see a globalisation of steemit, and the rest of the world is catching up.
Let me know what you think!
Thanks for reading :) Happy steeming! ^_^
PS: Big thank you goes to @arcange for providing development of the SteemSQL database that was used for this visualisation.
You keep outdoing yourself. This is so meta it's crazy.
Cheers! We should make an artistic visualisation together once :)
I'd be up for either something with Album Covers or old Comic Book covers. And there's always Lustiges Taschenbuch. How many roles/genres/periods has Donald Duck had a part to play in? I think he might be the most prolific fictional character of all time.
Fascinating - and good skills (beyond mine). Might be nice to do a user per capita per country version - The UK and US seem similarish but per capita UK use will be 6* higher.. also Nigeria's bubble would burst on that metric.
Nice post! Looks like there are fewer Steemit users in Russia than in Norway, I found that quite interesting.
Does anyone know how to make a lightweight animated gif? I think it would look better than a video, no?
@zeroooc ? or on giphy . com
thx i think i managed with premiere. 10mb is ok i think :P
lol!
you can export as a gif in premiere yes but the compression is usually terrible.
You could use ScreenToGIF to make the existing video smaller or try good old GifMaker!
Thanks for sharing
I hope steemit will grow, its such a nice concept. :)
Sehr coole und interessante Grafik wieder mal, danke fürs Erstellen und Teilen ;)
Andere Sache: Stell deine Posts in Zukunft besser auf 50/50 und nicht auf 100% Power-Up, 50/50 bringt dir wesentlich mehr Geld. Sehe das leider bei vielen, werden in ca. ner Stunde einen kurzen Artikel rausbringen, der das begründet!