This was inspired by @paulag's [November Supper Supporter and Minnowsupport Report](https://steemit.com/minnowsupport/@paulag/november-supper-supporter-and-minnowsupport-report). This also aims to be my primer in using PowerBI. I am more comfortable in using Excel, however, in terms of growth, I'm pushing myself to learn Power BI. ## Outline 1. Scope of Analysis 2. Votes Given By @utopian-io 3. Utopian Super Supporter 4. Conclusion ## 1. Scope of Analysis * Only votes for November were extracted * There were a total of **4552** outgoing (from @utopian-io) votes * There were a total of **6640** incoming (to @utopian-io) votes ## 2. Votes Given By @utopian-io ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513002480/qchiz7gexpgvqs319ft4.png) There were **4552** votes given last November. Out of this, **617** unique authors benefited from receiving such votes. ## 4. Utopian Super Supporter ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513002518/qmgjt8rk8qrjewcf5tz7.png) **2461** unique accounts voted on Utopian posts which totaled to **6640 votes.** Out of which, @abh12345 led the pack with **70 votes** on Utopian posts and comments. ## 5. Conclusion > *Any imbalance in the give and take within a community is unsustainable. Eventually the givers grow tired of supporting the takers and disengage from the community.* - [Steem White Paper](https://steem.io/SteemWhitePaper.pdf) I posted this analysis to inculcate this - **No matter how small your vote value is, I encourage you to up-vote @utopian-io's posts and comments.** If you decide to not up-vote @utopian-io's posts and comments, to whom are you [paying it forward](https://steemit.com/stewardsofgondor/@abh12345/fulltimegeek-s-making-a-list-and-checking-it-twice)? ### Lessons Learned in Using Power BI: * It's more difficult to create reports in Power BI. Before you are able create an image, you need to first publish (upload) your report which takes some time. * I had to resort to using Window's Snipping tool and capturing the raw report from Power BI * It takes time to publish reports using Power BI most specially for slow internet connections * One needs to familiarize himself with the functionality within Power BI. * Creating of new columns to convert timestamp to date * Creation of new measures (e.g., to add two columns from the same table field but with different calculations - e.g., total votes and average of vote weight) * Formatting of text sizes, background colors, etc. <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@eastmael/utopian-super-supporter">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
post_id | 20,110,381 | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
author | eastmael | ||||||||||||||||||||||||||||||||||||||||||||||||
permlink | utopian-super-supporter | ||||||||||||||||||||||||||||||||||||||||||||||||
category | utopian-io | ||||||||||||||||||||||||||||||||||||||||||||||||
json_metadata | "{"type": "analysis", "repository": {"id": 104593314, "watchers": 38, "events_url": "https://api.github.com/repos/utopian-io/utopian.io/events", "forks": 35, "name": "utopian.io", "issues_url": "https://api.github.com/repos/utopian-io/utopian.io/issues{/number}", "trees_url": "https://api.github.com/repos/utopian-io/utopian.io/git/trees{/sha}", "fork": false, "git_url": "git://github.com/utopian-io/utopian.io.git", "assignees_url": "https://api.github.com/repos/utopian-io/utopian.io/assignees{/user}", "size": 60974, "owner": {"id": 18612062, "following_url": "https://api.github.com/users/utopian-io/following{/other_user}", "starred_url": "https://api.github.com/users/utopian-io/starred{/owner}{/repo}", "subscriptions_url": "https://api.github.com/users/utopian-io/subscriptions", "repos_url": "https://api.github.com/users/utopian-io/repos", "login": "utopian-io", "gists_url": "https://api.github.com/users/utopian-io/gists{/gist_id}", "followers_url": "https://api.github.com/users/utopian-io/followers", "received_events_url": "https://api.github.com/users/utopian-io/received_events", "type": "Organization", "avatar_url": "https://avatars2.githubusercontent.com/u/18612062?v=4", "site_admin": false, "organizations_url": "https://api.github.com/users/utopian-io/orgs", "gravatar_id": "", "events_url": "https://api.github.com/users/utopian-io/events{/privacy}", "url": "https://api.github.com/users/utopian-io", "html_url": "https://github.com/utopian-io"}, "forks_count": 35, "git_refs_url": "https://api.github.com/repos/utopian-io/utopian.io/git/refs{/sha}", "blobs_url": "https://api.github.com/repos/utopian-io/utopian.io/git/blobs{/sha}", "pushed_at": "2017-12-10T22:20:55Z", "watchers_count": 38, "teams_url": "https://api.github.com/repos/utopian-io/utopian.io/teams", "comments_url": "https://api.github.com/repos/utopian-io/utopian.io/comments{/number}", "archived": false, "svn_url": "https://github.com/utopian-io/utopian.io", "merges_url": "https://api.github.com/repos/utopian-io/utopian.io/merges", "subscribers_url": "https://api.github.com/repos/utopian-io/utopian.io/subscribers", "issue_events_url": "https://api.github.com/repos/utopian-io/utopian.io/issues/events{/number}", "stargazers_url": "https://api.github.com/repos/utopian-io/utopian.io/stargazers", "mirror_url": null, "statuses_url": "https://api.github.com/repos/utopian-io/utopian.io/statuses/{sha}", "has_projects": true, "milestones_url": "https://api.github.com/repos/utopian-io/utopian.io/milestones{/number}", "description": "Utopian.io Frontend - Utopian wants to reward open-source contributors!", "keys_url": "https://api.github.com/repos/utopian-io/utopian.io/keys{/key_id}", "open_issues": 91, "compare_url": "https://api.github.com/repos/utopian-io/utopian.io/compare/{base}...{head}", "ssh_url": "git@github.com:utopian-io/utopian.io.git", "license": {"name": "GNU General Public License v3.0", "key": "gpl-3.0", "url": "https://api.github.com/licenses/gpl-3.0", "spdx_id": "GPL-3.0"}, "html_url": "https://github.com/utopian-io/utopian.io", "commits_url": "https://api.github.com/repos/utopian-io/utopian.io/commits{/sha}", "open_issues_count": 91, "stargazers_count": 38, "branches_url": "https://api.github.com/repos/utopian-io/utopian.io/branches{/branch}", "full_name": "utopian-io/utopian.io", "forks_url": "https://api.github.com/repos/utopian-io/utopian.io/forks", "score": 65.239395, "deployments_url": "https://api.github.com/repos/utopian-io/utopian.io/deployments", "contributors_url": "https://api.github.com/repos/utopian-io/utopian.io/contributors", "homepage": "https://utopian.io/", "contents_url": "https://api.github.com/repos/utopian-io/utopian.io/contents/{+path}", "has_downloads": true, "collaborators_url": "https://api.github.com/repos/utopian-io/utopian.io/collaborators{/collaborator}", "created_at": "2017-09-23T19:24:57Z", "git_commits_url": "https://api.github.com/repos/utopian-io/utopian.io/git/commits{/sha}", "releases_url": "https://api.github.com/repos/utopian-io/utopian.io/releases{/id}", "private": false, "pulls_url": "https://api.github.com/repos/utopian-io/utopian.io/pulls{/number}", "git_tags_url": "https://api.github.com/repos/utopian-io/utopian.io/git/tags{/sha}", "notifications_url": "https://api.github.com/repos/utopian-io/utopian.io/notifications{?since,all,participating}", "language": "JavaScript", "updated_at": "2017-12-10T05:51:00Z", "has_wiki": true, "downloads_url": "https://api.github.com/repos/utopian-io/utopian.io/downloads", "hooks_url": "https://api.github.com/repos/utopian-io/utopian.io/hooks", "languages_url": "https://api.github.com/repos/utopian-io/utopian.io/languages", "default_branch": "master", "labels_url": "https://api.github.com/repos/utopian-io/utopian.io/labels{/name}", "url": "https://api.github.com/repos/utopian-io/utopian.io", "has_pages": false, "tags_url": "https://api.github.com/repos/utopian-io/utopian.io/tags", "clone_url": "https://github.com/utopian-io/utopian.io.git", "archive_url": "https://api.github.com/repos/utopian-io/utopian.io/{archive_format}{/ref}", "has_issues": true, "issue_comment_url": "https://api.github.com/repos/utopian-io/utopian.io/issues/comments{/number}", "subscription_url": "https://api.github.com/repos/utopian-io/utopian.io/subscription"}, "pullRequests": [], "format": "markdown", "image": ["https://res.cloudinary.com/hpiynhbhq/image/upload/v1513002480/qchiz7gexpgvqs319ft4.png"], "links": ["https://steemit.com/minnowsupport/@paulag/november-supper-supporter-and-minnowsupport-report", "https://res.cloudinary.com/hpiynhbhq/image/upload/v1513002480/qchiz7gexpgvqs319ft4.png", "https://res.cloudinary.com/hpiynhbhq/image/upload/v1513002518/qmgjt8rk8qrjewcf5tz7.png", "https://steem.io/SteemWhitePaper.pdf", "https://steemit.com/stewardsofgondor/@abh12345/fulltimegeek-s-making-a-list-and-checking-it-twice"], "app": "utopian/1.0.0", "platform": "github", "tags": ["utopian-io", "bisteemit", "analytics", "data", "contribution"], "community": "utopian", "users": ["paulag", "utopian-io", "abh12345"]}" | ||||||||||||||||||||||||||||||||||||||||||||||||
created | 2017-12-11 14:46:15 | ||||||||||||||||||||||||||||||||||||||||||||||||
last_update | 2017-12-11 14:46:15 | ||||||||||||||||||||||||||||||||||||||||||||||||
depth | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||
children | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||
net_rshares | 12,956,770,028,261 | ||||||||||||||||||||||||||||||||||||||||||||||||
last_payout | 2017-12-18 14:46:15 | ||||||||||||||||||||||||||||||||||||||||||||||||
cashout_time | 1969-12-31 23:59:59 | ||||||||||||||||||||||||||||||||||||||||||||||||
total_payout_value | 37.782 SBD | ||||||||||||||||||||||||||||||||||||||||||||||||
curator_payout_value | 13.332 SBD | ||||||||||||||||||||||||||||||||||||||||||||||||
pending_payout_value | 0.000 SBD | ||||||||||||||||||||||||||||||||||||||||||||||||
promoted | 0.000 SBD | ||||||||||||||||||||||||||||||||||||||||||||||||
body_length | 2,702 | ||||||||||||||||||||||||||||||||||||||||||||||||
author_reputation | 51,681,288,563,260 | ||||||||||||||||||||||||||||||||||||||||||||||||
root_title | "Utopian Super Supporter" | ||||||||||||||||||||||||||||||||||||||||||||||||
beneficiaries |
| ||||||||||||||||||||||||||||||||||||||||||||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||||||||||||||||||||||||||||||||||||||||||||
percent_steem_dollars | 10,000 | ||||||||||||||||||||||||||||||||||||||||||||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
abh12345 | 0 | 49,355,001,747 | 7% | ||
yuxi | 0 | 3,250,862,649 | 26% | ||
luvabi | 0 | 23,784,412,486 | 100% | ||
rt395 | 0 | 5,820,740,473 | 25% | ||
jassennessaj | 0 | 23,259,694,625 | 20% | ||
bearone | 0 | 11,599,653,545 | 15% | ||
paulag | 0 | 753,739,079,914 | 49% | ||
st3llar | 0 | 862,526,810 | 5% | ||
vallesleoruther | 0 | 110,638,265,232 | 100% | ||
steemitbc | 0 | 19,020,013,994 | 25% | ||
maxibyte | 0 | 121,520,499 | 10% | ||
steemitph | 0 | 17,154,309,796 | 20% | ||
aafeng | 0 | 24,170,686,639 | 39% | ||
sarmizegetusa | 0 | 40,445,261,508 | 100% | ||
yandot | 0 | 11,903,860,798 | 100% | ||
crokkon | 0 | 20,759,644,712 | 100% | ||
spotlight | 0 | 30,648,649,034 | 10% | ||
eastmael | 0 | 46,331,179,892 | 100% | ||
topbro | 0 | 9,438,811,018 | 100% | ||
j-alhomestudio | 0 | 4,776,717,128 | 100% | ||
utopian-io | 0 | 11,637,755,361,150 | 9.1% | ||
steemph.manila | 0 | 107,544,885,550 | 100% | ||
kslo | 0 | 3,502,938,883 | 100% | ||
thevoysing | 0 | 526,098,600 | 100% | ||
dailyjoke | 0 | 52,257,866 | 100% |
Thank you for the contribution. It has been approved. You can contact us on [Discord](https://discord.gg/UCvqCsx). **[[utopian-moderator]](https://utopian.io/moderators)**
post_id | 20,111,280 |
---|---|
author | thegoldenphoenix |
permlink | re-eastmael-utopian-super-supporter-20171211t145540728z |
category | utopian-io |
json_metadata | "{"app": "busy/1.0.0", "community": "busy", "tags": ["utopian-io"]}" |
created | 2017-12-11 14:55:39 |
last_update | 2017-12-11 14:55:39 |
depth | 1 |
children | 1 |
net_rshares | 22,770,335,505 |
last_payout | 2017-12-18 14:55:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.096 SBD |
curator_payout_value | 0.002 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 172 |
author_reputation | 10,797,751,623,277 |
root_title | "Utopian Super Supporter" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
eastmael | 0 | 22,770,335,505 | 50% |
Thank you @thegoldenphoenix.
post_id | 20,111,706 |
---|---|
author | eastmael |
permlink | re-thegoldenphoenix-re-eastmael-utopian-super-supporter-20171211t150010988z |
category | utopian-io |
json_metadata | "{"app": "steemit/0.1", "users": ["thegoldenphoenix"], "tags": ["utopian-io"]}" |
created | 2017-12-11 15:00:09 |
last_update | 2017-12-11 15:00:09 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-12-18 15:00:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 28 |
author_reputation | 51,681,288,563,260 |
root_title | "Utopian Super Supporter" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
I am very proud of your use of Power BI in this analysis, its all a learning curve and I take my hat off to those that wish to learn
post_id | 20,115,107 |
---|---|
author | paulag |
permlink | re-eastmael-utopian-super-supporter-20171211t153528531z |
category | utopian-io |
json_metadata | "{"app": "steemit/0.1", "tags": ["utopian-io"]}" |
created | 2017-12-11 15:35:24 |
last_update | 2017-12-11 15:35:24 |
depth | 1 |
children | 1 |
net_rshares | 45,315,238,261 |
last_payout | 2017-12-18 15:35:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.192 SBD |
curator_payout_value | 0.004 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 132 |
author_reputation | 224,445,607,823,384 |
root_title | "Utopian Super Supporter" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
eastmael | 0 | 45,315,238,261 | 100% |
Thank you very much Paula. It's been a long time coming. Lol. Thank you for showing in your analyses what's possible with Power BI. Another tool in the toolbox. :)
post_id | 20,115,478 |
---|---|
author | eastmael |
permlink | re-paulag-re-eastmael-utopian-super-supporter-20171211t153911348z |
category | utopian-io |
json_metadata | "{"app": "steemit/0.1", "tags": ["utopian-io"]}" |
created | 2017-12-11 15:39:06 |
last_update | 2017-12-11 15:39:06 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2017-12-18 15:39:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 SBD |
curator_payout_value | 0.000 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 163 |
author_reputation | 51,681,288,563,260 |
root_title | "Utopian Super Supporter" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
### Hey @eastmael I am @utopian-io. I have just upvoted you! #### Achievements - You have less than 500 followers. Just gave you a gift to help you succeed! - Seems like you contribute quite often. AMAZING! #### Community-Driven Witness! I am the first and only Steem Community-Driven Witness. <a href="https://discord.gg/zTrEMqB">Participate on Discord</a>. Lets GROW TOGETHER! - <a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for my Witness With SteemConnect</a> - <a href="https://v2.steemconnect.com/sign/account-witness-proxy?proxy=utopian-io&approve=1">Proxy vote to Utopian Witness with SteemConnect</a> - Or vote/proxy on <a href="https://steemit.com/~witnesses">Steemit Witnesses</a> [![mooncryption-utopian-witness-gif](https://steemitimages.com/DQmYPUuQRptAqNBCQRwQjKWAqWU3zJkL3RXVUtEKVury8up/mooncryption-s-utopian-io-witness-gif.gif)](https://steemit.com/~witnesses) **Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x**
post_id | 20,153,501 |
---|---|
author | utopian-io |
permlink | re-eastmael-utopian-super-supporter-20171211t233506199z |
category | utopian-io |
json_metadata | "{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}" |
created | 2017-12-11 23:35:06 |
last_update | 2017-12-11 23:35:06 |
depth | 1 |
children | 0 |
net_rshares | 45,774,302,795 |
last_payout | 2017-12-18 23:35:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.156 SBD |
curator_payout_value | 0.048 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 1,084 |
author_reputation | 152,913,012,544,965 |
root_title | "Utopian Super Supporter" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
eastmael | 0 | 42,330,402,208 | 100% | ||
kslo | 0 | 3,443,900,587 | 100% |