In the new year, @HappyDolphin checks on new challenge #DailyPetPhotography
#whysoserious. Pets are fun to have and there is a new photo challenge in the new year. ICYMI, it's #dailypetphotography.
@happydolphin extracted data of people who posted with #dailypetphotography tag.
Then exported the results into an Excel file 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.
In a week, based on data I extracted yesterday. There are already 74 posts. None have been paid out but total pending payout is 750.04 making the average page payout per post slightly about 10. See? One woman, i.e., @catwomanteresa, has top the pending payout with more than 400.
Who are the ones with the early posts? Well, here is on day 1, 04-Jan.
On day 2, 05-Jan, we see 7 posts with total pending payout more than 100.
We saw less posts on Monday and Tuesday, 08-Jan and 09-Jan, but I don't don't think we can conclude there is a pattern yet until this challenge runs longer. However, there seems to be peak yesterday Wednesday. Perhaps, people started to realise:
Woohoo, there is steem to be won from @kona who is organizing this challenge.
There you have it. @happydolphin is happy to look at the data and check out on #dailypetphotography.
If you are interested in "touching" the Power BI report yourself, you can go to this link:
https://app.powerbi.com/view?r=eyJrIjoiN2NiMjQ2ZmEtOWI3NS00NmQzLThjYjQtYzJhYzEwYjZmYTBkIiwidCI6ImM1NzEzYTNiLWU1MTktNDIxMy1iNWUzLTQwMzRmN2E5ZTdiZiIsImMiOjEwfQ%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 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
Don't forget to upvote.
Resteem if you like to share this 😎
Follow @happydolphin
for more