Utopian Super Supporter by eastmael

View this thread on steempeak.com
· @eastmael ·
$51.11
Utopian Super Supporter
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/>
👍  , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
post_id20,110,381
authoreastmael
permlinkutopian-super-supporter
categoryutopian-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"]}"
created2017-12-11 14:46:15
last_update2017-12-11 14:46:15
depth0
children7
net_rshares12,956,770,028,261
last_payout2017-12-18 14:46:15
cashout_time1969-12-31 23:59:59
total_payout_value37.782 SBD
curator_payout_value13.332 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length2,702
author_reputation51,681,288,563,260
root_title"Utopian Super Supporter"
beneficiaries
0.
accountcnts
weight10
1.
accountdamla
weight23
2.
accountfreedom
weight658
3.
accountnetuoso
weight6
4.
accountsimnrodrguez
weight22
5.
accounttransisto
weight70
6.
accountutopian-io
weight536
7.
accountxeldal
weight27
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (25)
@thegoldenphoenix ·
$0.10
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)**
👍  
properties (23)
post_id20,111,280
authorthegoldenphoenix
permlinkre-eastmael-utopian-super-supporter-20171211t145540728z
categoryutopian-io
json_metadata"{"app": "busy/1.0.0", "community": "busy", "tags": ["utopian-io"]}"
created2017-12-11 14:55:39
last_update2017-12-11 14:55:39
depth1
children1
net_rshares22,770,335,505
last_payout2017-12-18 14:55:39
cashout_time1969-12-31 23:59:59
total_payout_value0.096 SBD
curator_payout_value0.002 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length172
author_reputation10,797,751,623,277
root_title"Utopian Super Supporter"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@eastmael ·
Thank you @thegoldenphoenix.
properties (22)
post_id20,111,706
authoreastmael
permlinkre-thegoldenphoenix-re-eastmael-utopian-super-supporter-20171211t150010988z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "users": ["thegoldenphoenix"], "tags": ["utopian-io"]}"
created2017-12-11 15:00:09
last_update2017-12-11 15:00:09
depth2
children0
net_rshares0
last_payout2017-12-18 15:00:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length28
author_reputation51,681,288,563,260
root_title"Utopian Super Supporter"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@paulag ·
$0.20
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
👍  
properties (23)
post_id20,115,107
authorpaulag
permlinkre-eastmael-utopian-super-supporter-20171211t153528531z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
created2017-12-11 15:35:24
last_update2017-12-11 15:35:24
depth1
children1
net_rshares45,315,238,261
last_payout2017-12-18 15:35:24
cashout_time1969-12-31 23:59:59
total_payout_value0.192 SBD
curator_payout_value0.004 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length132
author_reputation224,445,607,823,384
root_title"Utopian Super Supporter"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@eastmael ·
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. :)
properties (22)
post_id20,115,478
authoreastmael
permlinkre-paulag-re-eastmael-utopian-super-supporter-20171211t153911348z
categoryutopian-io
json_metadata"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
created2017-12-11 15:39:06
last_update2017-12-11 15:39:06
depth2
children0
net_rshares0
last_payout2017-12-18 15:39:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length163
author_reputation51,681,288,563,260
root_title"Utopian Super Supporter"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@utopian-io ·
$0.20
### 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**
👍  ,
properties (23)
post_id20,153,501
authorutopian-io
permlinkre-eastmael-utopian-super-supporter-20171211t233506199z
categoryutopian-io
json_metadata"{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}"
created2017-12-11 23:35:06
last_update2017-12-11 23:35:06
depth1
children0
net_rshares45,774,302,795
last_payout2017-12-18 23:35:06
cashout_time1969-12-31 23:59:59
total_payout_value0.156 SBD
curator_payout_value0.048 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length1,084
author_reputation152,913,012,544,965
root_title"Utopian Super Supporter"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)