@HappyDolphin🐬 checks on #MusicChallenge

There is #musicchallenge organised by @kona and #whysocurious wonders who are the music lovers and how their posts in the challenge are doing. So, @happydolphin extracted the data of the posts with #musicchallenge 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.

There were already 155 posts when I extracted yesterday. Mostly (108) posts were from last month.

Who has the the highest total payout so far? @stacee
But…. the total pending payout is higher and that is from @nearbird.
The person with the most number upvotes is not surprising @kona - the organiser.

Over the last 30 days, the day with the highest number of posts (12) is 20180119 and the total payout value is 93.53. The day with the next highest number of posts (8) is 2018026 and the total payout value is 94.79. There seems to be an uptrend but looks like the coming holidays is taking a toll on people.

A few people has more than 10 posts. I won’t tell you who. You can try and play with the report if you are really busybody enough :-)

IMAGE LINK|图片链接: https://supload.com/Bye90x4Uf

There you have it. @happydolphin is happy to look at the data and check out on #musicchallenge.

If you are interested in "touching" the Power BI report yourself, you can go to this link:
https://app.powerbi.com/view?r=eyJrIjoiOTg4NjhjMzYtN2IwMy00NDM3LWE4ZDYtYmFkN2Y5NTMxMzZjIiwidCI6ImM1NzEzYTNiLWU1MTktNDIxMy1iNWUzLTQwMzRmN2E5ZTdiZiIsImMiOjEwfQ%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

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