Where are all the Steemit users around the world? [OC]
blockchainbi·@remuslord·
0.000 HBDWhere are all the Steemit users around the world? [OC]
# Here's a globe! <a href="https://app.powerbi.com/view?r=eyJrIjoiNTAwYjA4Y2QtYTc0Ni00NzgwLTk2OGQtZTBlYjlkODNjZjAwIiwidCI6ImQ4MDc0ODg1LTRhMTktNGZkZi04NWY3LTdmMmY1MWZmMWVmNyIsImMiOjh9"> <img src="https://steemitimages.com/DQmUjNM5rqL25EXRDr8HuJ8R2Ed9QV3wbdJA2TYSfg5WCaj/image.png"> </a> ## [Check out the 3D view-it-yourself visualisation here.](https://app.powerbi.com/view?r=eyJrIjoiNTAwYjA4Y2QtYTc0Ni00NzgwLTk2OGQtZTBlYjlkODNjZjAwIiwidCI6ImQ4MDc0ODg1LTRhMTktNGZkZi04NWY3LTdmMmY1MWZmMWVmNyIsImMiOjh9) *Make sure you let it load a little, could take a minute to plot all the data* # Data is obviously from the super awesome SteemSQL database - graciously developed, maintained and kept alive by @arcange, who I once again have to thank endlessly for making this and all my other data viz experiments regarding Steemit blockchain stuff. Just started experimenting with Power BI, which is fantastic :) (Thanks for the recommendation @paulag) ### Caveat: - Location data is taken from (voluntary) entries on Steemit user profiles, so it's limited in the sense that it's by far not complete and in some cases just wrong (when people lie about their location) - The US data is likely highly underestimated as it's not common for Americans to state their location finishing with US at the end. Furthermore, they are only marked if it says "'city', USA". - I purposely left out numbers in the viz to not distract - but just FYI, the voluntarily inputted data covers around 30,000 users - or just under 10% of total registered users. #### If there's interest in this visualisation, I'll try to make it a live version and work on the aesthetics and presentation some more too :) Thanks for reading! Happy steeming! ^_^ <center> https://steemitimages.com/DQmcH5NJMY2jT9NgGx5xZaJqspSoAZrXC8ecVF4bjzLSXhY/image.png </center> EDIT: The viz doesn't seem to work well on mobile at all - please use your laptops/desktops :)