Sometimes it can be difficult to find a good data set to analyse. Kaggle offer data sets and run competitions on analysis and Microsoft also offer sample data sets such as World Wide importers. But sometimes a completely different data set is really cool to explore.

Over the last few weeks I have been using Power BI to analyse the SteemitSQL database and produce actionable insights. And today I would like to share some thoughts and reports with you.

What is Steemit?

Steemit is an online blogging platform that runs on block chain technology. It allows content creators publish content and reward those that engage with their content by micro payments. It also allows content creators monetize their content by receiving micro payments from their followers by way of up votes. It’s a social/blogging platform with a twist…..

The blockchain holds all of the data. Its holds the text from the blog posts, details on followers, profiles votes, payments, comments.

Think of it this way. With the likes of Facebook, Youtube and other centralised Social media platforms we can use Power BI to connect with API and get data that ‘they’ are willing to share.

The blockchain holds no secrets, and Steemit is a platform with masses of uncensored data that anyone can access.

As I mentioned Steemit is a blogging platform. At first I was blogging about Excel and Power BI. Hoping I could get a following with ‘How To’ type article. I thought it was a new community I could introduce Power BI to. However there was no real interest from the general Steemit user.

But now that I am publishing reports on the data, my posts are doing better and my following on the platform is growing. After a little under two months I have over 300 followers. As they grow accustom to these reports and dashboards, I hope I can convert them to Power BI users that will want the ‘How to’ articles

So today I would like to share with you an analysis I prepare on new Steemit users in July. The data has been taken directly from SteemSQL