There is #mundaneart organised by and #whysocurious wonders who are the people who participated in the latest edition and how their posts are doing. So,
extracted the data of the posts with #mundaneart 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.
If filtered to look at data for posts from 4th February and there were 118 post in about 1.5 weeks. Interesting, the most number of posts was on the first day.
IMAGE LINK|图片链接: https://www.supload.com/BkolxO-DG
I clicked on the column in the bar chart for the first day and see who are the first movers.
IMAGE LINK|图片链接: https://www.supload.com/BkolxO-DG
I decided to focus on the table of users from 4th February and sort it by No. of Posts. Wow, 11 people busy with more than one posts of #mundaneart.
IMAGE LINK|图片链接: https://www.supload.com/BkFD7Iw8M
Then I sort it by Total Payout and one person, , has the highest. Even more than
.
I decided to focus on the table of users from 4th February and sort it by No. of Posts. Wow, 11 people busy with more than one posts of #mundaneart.
IMAGE LINK|图片链接: https://www.supload.com/BkFD7Iw8M
Next, sorting by Pending Payout, I’ll say even the highest will not likely be more than the highest paid out one.
IMAGE LINK|图片链接: https://www.supload.com/BkFD7Iw8M
Lastly, I sorted by number of votes and for the organiser has the highest number of votes. The next highest number of votes are 247 and 157. Coincidentally (?), 8 people had 247 votes and coincidentally (?), 5 people has 157 votes. (Head scratching)
IMAGE LINK|图片链接: https://www.supload.com/BkFD7Iw8M
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. In this example, I decided to look at just the one date of late entrants and the first image.
IMAGE LINK|图片链接: https://www.supload.com/H1tg4IvIG
There you have it. is happy to look at the data and check out on #mundaneart.
If you are interested in "touching" the Power BI report yourself, you can go to this link:
https://app.powerbi.com/view?r=eyJrIjoiMTk1NDRmNjItNWRiOS00ZWZkLTgwMGYtMDViYzk4MmY5ZTQ5IiwidCI6ImM1NzEzYTNiLWU1MTktNDIxMy1iNWUzLTQwMzRmN2E5ZTdiZiIsImMiOjEwfQ%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 month and see the data just for that month.
- 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