#MonthlyAuthorChallenge is monitored by steemitboard.com and @future24 mention planning to have some prize for that. So, #whysocurious checks who have posted for February and how their posts are doing. So, @happydolphin extracted the data of the posts with #montlyauthorchallenge tag and the votes of these posts. Then exported the results into 2 Excel files and loaded it to Power BI. I just wanted a snapshot of the data to work with so I didn’t make Power BI query #steemsql database directly. Anyway, the query could take a long time.
I extracted the data a couple of days ago and only look at post created in February. There were 117 authors with more than 1,600 posts in total but after 2 thirds of the month past, the number of posts, the number of posts per day start to taper off. Haha… many did not complete the challenge. Then again only 2 days have more than 117 posts. So, more likely many did not post everyday for the month.
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
I clicked on the No. of Posts column in table to sort in reverse order to see that there are people who has more than 28 posts. Whoa… does that means some people post more than one a day?
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
Then there are those who wrote less than a few.
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
Let’s see a few authors. I click on the specific author in the author column to see these.
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
Now, that is consistency. :-)
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
IMAGE LINK|图片链接: https://supload.com/HJIV2Ajuf
I added a tab with the images from different authors with a date slicer which gives you an image grid of the images from posts that are within the selected date range. If you are interested, you can go and try in the report.
There you have it. @happydolphin is happy to look at the data and check out on #MonthlyAuthorChallenge.
If you are interested in "touching" the Power BI report yourself, you can go to this link:
https://app.powerbi.com/view?r=eyJrIjoiOGQyMGJiYzctMzE1OC00MzQwLWJmYWYtM2FiYjJmOWRiYmIyIiwidCI6ImM1NzEzYTNiLWU1MTktNDIxMy1iNWUzLTQwMzRmN2E5ZTdiZiIsImMiOjEwfQ%3D%3D
Note: Don’t worry. You won't break the report but I can’t guarantee it will be there forever.
If you do go play with the report, a few things you can try are:
- Click on the header of the matrix table to see the data sort differently.
- Click on an author in the matrix table and see how the chart change to present for that author.
- Click on a date and see the data just for that day.
- Click on a column in the chart to see how the matrix table of author post summary changes
I am part of a Steemit Business Intelligence community. We all post under the tag #blockchainbi. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #blockchainbiteam and we will do our best to help you.
You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j
Note: Access to SteemSQL is currently provided at subscription fee of 10 SBD per month.
See this post from @arcange for more details:
SteemSQL is moving to a monthly subscription model
Hope you like it.
Don't forget to upvote.
Resteem if you like to share this 😎
Follow @happydolphin
for more