Are you familiar with SoundCloud? Familiar with hosting Postcasts? DSound.Audio is an awesome app built upon the Steem Blockchain, that is just like SoundCloud but it is decentralised and creators can earn STEEM from upvotes on their content.
DSound is the brain child of Pedro 
The aim of this analysis is to monitor the monthly activity from 
This analysis will be carried out on a monthly basis so that trends can be established and growth measured.
The data from the blockchain is limited. When it comes to sharing audio for creators, metrics such as play duration and number of listeners are of critical importance if you are trying to grow your channel. However this data is not collected on the blockchain and not part of this analysis
Using PowerBI, I have connected to the SteemSQL database (paid subscription service held and managed by 
@dsound Votes AnalysisIn Feb 2018 DSound voted 532 times for 2733 Authors. The average vote payout was SBD $21 and the total approx. payout given by DSound was SBD $56.82K We can also see from above that the average % voting weight used by
In February 13K posts were made by 3054 authors receiving 34K comments and 179K votes. The payout value of this posts is SBD $72.82K.
The average post payout in Feb for #dsound posts was $5.60 – substantially higher than the overall post payout average on the Steemit blockchain
We see above that DSound have given out approx. SBD $56.82K. That equates to 78% of the total rewards for this category/tag/app
These 13K posts received 34K comments from 7158 authors. The comments received 12K votes and received rewards of SBD $1.23K
Below shows which accounts have posted the most to DSound in the month of February
And the list below shows those that engage with the posts via comments
DSound is an awesome project, receiving 13K posts in the month of Feb and voting for 2,733 of them. This means that almost 1 in 5 posts made will be voted on by
78% of the payout in this category comes from
Welcome to the block
Do you have any questions or queries on the data above? If so, please do leave a comment below.
The SQL query used to collect data for votes made by
SELECT *
FROM Txvotes (NOLOCK)
WHERE [voter] in ('dsound')
AND CONVERT(DATE,timestamp) BETWEEN '2018-02-01' AND '2018-02-28'
The query used to collect data for posts made to the category/tag Dsound on steemit was:
SELECT
author,
json_metadata,
permlink,
total_payout_value,
pending_payout_value,
net_votes,
created,
children,
Category,
Depth
FROM comments (NOLOCK)
where CONVERT(DATE,created) BETWEEN '2018-02-01' AND '2018-02-28'
and json_metadata like ('%"dsound"%')
The Current vote worth for Dsound has been taken from https://steemworld.org/@dsound at 6st March 2018.
I am part of a Blockchain Business Intelligence community. We all post under the tag #BlockchainBI. If you have an analysis you would like carried out on Steemit or Blockchain data, please do contact me or any of the#BlockchainBI team and we will do our best to help you...
You can find #BlockchainBI on discord https://discordapp.com/invite/JN7Yv7j