![mountains-nature-sky-sunny.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513944892/zxwlqrmrqk3oy3wsnlwz.jpg)
<sup>[Image Source](https://www.pexels.com/photo/mountains-nature-sky-sunny-6629/)</sup>

Have you been to the top? Have you reached the pinnacle of success? How did it feel? To some it may be a dream, but to those who are afraid of heights, it's a nightmare.

In this analysis, this author took a closer look into Utopian's top projects.

## Outline

1. Criteria for Top
    1. Point System
1. Scope of Analysis
1. Growth Check
1. Top Projects
    1. By Contributions
    2. By Payout and Rewards
    3. By Votes
    4. By Comments
1. Results Tally
    1. By Total
    1. By Average
    1. Your Champion

## 1. Criteria for Top

To identify the top projects, this author decided to use a point system.

### 1.1. Point System

1. Four categories of 'top' were considered: by contributions, by total *rewards<sup>1</sup>*, by number of votes, and by engagement (total comments)
1. For each category, only the top 10 projects were included
1. For each category, points were awarded to the top 5, none for the remaining
    1. 5 points for the top spot
    2. 4 points for the second
    3. 3 points for the third
    4. 2 points for the fourth
    5. 1 point for the fifth
1. The total points for each category were tallied
1. The projects were sorted in descending order based on the tallied points to determine their rank

***

<sup>1</sup>: *All throughout this document, the term **reward** refers to the vote value given by @utopian-io to a contribution.*

## 2. Scope of Analysis

* Contributions were acquired on **Dec. 24, 2017 1100H UTC**
* Data extracted was from `2017-09-28 1539H UTC` to `2017-12-24  0520H UTC`
* Down-votes were excluded
* Up-votes on comments were excluded

## 3. Growth Check

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514115446/dzpcnwswclgchxqmlefo.png)

As of December 24, there were **895 authors rewarded, 1508 projects contributed,** and **7555 contributions up-voted.**

Let's compare November and December to determine its growth:

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514115476/xcqxbmmuos4fvhrlqodc.png)

As of date, authors grew by **42%,** projects by **100%,** and contributions by **81%.**

Let's look into the different categories to determine the top projects.

## 4. Top Projects

To determine the top projects for each category, two graphs were created at the beginning of each section:

1. A *bar chart* (left) to get the total the count of the *subject value* (e.g., the sum of all contributions) per project, and 
2. A *line chart* (right) with a running total of the *subject value* through time

The reasons for creating these two charts were: 
1. To easily identify which projects got the most of the *subject value* (*left*), and
2. To see how the *subject value* grew over time (*right*)

Let's see this applied on the first category.

### 4.1. By Contributions

| <center>By Contribution (Top 10)</center> | <center>Growth Over Time (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100005/pm7rjvg84nqlfnqzxmqv.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100186/t5w3xofurozvjy9o3z0j.png) |

The message was the same for the two charts given: `utopian-io/utopian.io` and `steemit/condenser` led other projects by a large margin.

The bar chart (*left*) showed that there were close to **1000 contributions** to `utopian-io/utopian.io`. Next to it was `steemit/condenser` with around **800**.

#### 4.1.1. Result

Putting this into a table with the corresponding points:

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100237/xgsgzkwpldsgdimo1rmu.png)

`utopian-io/utopian.io` got the top spot for its **974 contributions.**

The **null** project, mostly for blog entries, was skipped because it had no specific repository, thus was not rewarded any points; points were awarded to the succeeding projects. This rule was applied to the other categories as well, unless stated otherwise.

Let's look at the contributions for November and December.

#### 4.1.2. A Look Into November and December

| <center>November (Top 5)</center> | <center>December (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100614/buasspchiigm20tfusvw.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100678/jxaug8amn4xuukrsjg8j.png) |

They also gave the same message that `utopian-io/utopian.io` and `steemit/condenser` got the top two spots.

Let's look how many authors contributed to the projects.

### 4.1.3. Distinct Contributors

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514116291/cnyjwziyv9ecd7ayex5d.png)

In `utopian-io/utopian.io` there were **290 distinct authors** who made the **974 contributions**.

Let's look into the next category.

### 4.3. By Payout and Reward

To reiterate: 
* **Payout** is the value displayed as the contribution's payout value
* **Reward** is the up-vote value given by @utopian-io

Here's an image to illustrate:

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513957479/q4dri4jegdl4mlf6alud.png)

First, let's look at the total rewards.

#### 4.2.1. Total Rewards

| <center>Total Rewards (Top 10)</center> | <center>Reward Growth (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514100869/kg6zo9yyhl19eboxyq9j.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514116586/omq8vsfxdcn8seb6vgc8.png) |

The bar chart (*left*) showed that `utopian-io/utopian.io` has generated **close to $23K rewards**. Next to it was `steemit/condenser` with **more than $17K**.

One thing became obvious - **total rewards were tied to the number of contributions.** Thus, the projects that will get the top positions from this category onward were projects that had the **most number of contributions**.

As such, the author tried to look at it from a different angle - by **average reward per contribution** for projects that had more than 10 contributions (*the number 10 was chosen arbitrarily*).

##### 4.2.1.1. Rewards - A Different View

| <center>Scatter Chart</center> | <center>Ave. Vote Value (Top 10)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514101578/nh5nawqsyefrbcukavyp.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514116739/dbrazxvangegzi3ros0l.png) |

The chart on the left showed that `steemit/condenser` and `utopian-io/utopian.io` were outliers when it comes to the number of contributions (*y or vertical axis*) and unique authors (*x or horizontal axis*).

> **What is an outlier?**
> *a data point on a graph or in a set of results that is very much bigger or smaller than the next nearest data point.* - [source](https://www.google.com.ph/search?q=define%3Aoutlier&oq=define%3Aoutlier&aqs=chrome..69i57j69i58.4355j0j7&sourceid=chrome&ie=UTF-8)

The table on the right showed that when it comes to the average vote value ($), `gornanization/1k` got the top spot with an average of **$59** per contribution. `utopian-io/utopian.io` and `steemit/condenser` were at the **80<sup>th</sup>** and **86<sup>th</sup>** spots, respectively, which gave out an average of **$22 to $23** for each contribution.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514116892/r76ohkoiw30obyelih2r.png)

To make it somehow fairer for other projects, the author decided to use the **average value** as the criterion to determine the top projects from hereon.

Let's now look into the total payouts.

#### 4.2.2. Total Payout

| <center>Total Payout (Top 10)</center> | <center>Payout Growth (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514101859/wg7cpj4mckxprsddjfw7.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117080/ncqfcokgibt5pudn38lg.png) |

It looked the same with **total rewards** - `utopian-io/utopian.io` and `steemit/condenser` got the top two spots.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117224/k9dznqvp7xh9lzbjwiky.png)

`utopian-io/utopian.io` has generated **more than $30K total payout** while `steemit/condenser` has generated **more than $22K**.

Let's look into the average payout.

##### 4.2.2.1. By Average Payout

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117463/qhmdqgzocsvw7lmewfjr.png)

`Minecolonies/minecolonies` got the top spot with an average of **$68** for each contribution.

#### 4.2.3. Results

Here were the two tables for the results of **average rewards** and **average payouts**.

| <center>Ave. Rewards</center> | <center>Ave. Payout</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117502/bmgpjllcqawirtyaimbf.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117484/wf4m1njibxwycsn8lzsk.png) |

`gornanization/1k` got the top spot for the **average reward** category, while `Minecolonies/minecolonies` got the top spot for the **average payout** category.

Let's now look into the total votes generated.

### 4.3. By Votes

| <center>Total Votes (Top 10)</center> | <center>Vote Growth (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117624/e1dhxccjd4vu0yjrvcwk.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117712/nsctcjy9kagnflev60bw.png) |

For this category, we see a large gap between `utopian-io/utopian.io` and `steemit/condenser`. The former accumulated a total of **43K votes** while the latter got **29K**. A **14K** difference.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117770/qza9ip2igc9ezjrmymgm.png)

Looking at this on an average vote per contribution for projects that had more than 10 contributions.

#### 4.3.1. By Average Number of Votes

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514117983/jpnwzcizcfmv5v2tk8mg.png)

The table showed that `MattyIce/bottracker` got the top spot with an average of **104 votes** per contribution.

And for the last category, let's look into the comments.

### 4.4. By Comments

| <center>Total Comments (Top 10)</center> | <center>Comments Growth (Top 5)</center> |
| -- | -- |
| ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514118072/lft6ghhceztxvu7ycl6m.png) | ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514118191/whhsa2azbzbhbsueljwg.png) |

Again, `utopian-io/utopian.io` and `steemit/condenser` got the top two spots for the totals category.

An interesting story here was the total comments for each project were close - **8894 comments** for `utopian-io/utopian.io` and **8117 comments** for `steemit/condenser`. This author also observed the gap shrinking in the *growth* chart (*right*). 

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514118240/lswlw2zf93bndbw2ekvh.png)

Let's look at the average.

#### 4.4.1. By Average Number of Comments

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514118422/vchlfpztinvh08qxjp7y.png)

The table showed that `MattyIce/bottracker` got the top spot with an average of **23 comments** per contribution.

Let's tally the results.

## 5. Results Tally

This author was divided whether to highlight the top projects based on **total** or by **average**. As such, he decided to show both and let **you**, the reader, decide your champion.

### 5.1. Tally By Total

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514167987/wjdtws1y5eucnfljpcxr.png)

This chart showed that `utopian-io/utopian.io` led all categories. Put this into a table:

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514168114/djgnsi7xemlecshexuxp.png)

And then tallied the results:

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514169249/okxq99o7m2jq0ekg6wc2.png)

`utopian-io/utopian.io` got the top spot for all categories garnering a total of **25 points**. 

### 5.2. Tally By Average

Here were the tally of the results for the **average**.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1514118982/lrkissguur1emfgpe3mt.png)

`MattyIce/bottracker` got the top spot by garnering a total of **12 points**. This project got the top spot for two categories: **Ave. # of Votes** and **Ave. # of Comments.**

### 5.3. Your Champion

If you chose the **total** as your criterion to determine your winner, then your champion is `utopian-io/utopian.io`.

However, if you choose the **average** as your criterion to determine your winner, then your champion is `MattyIce/bottracker`.

**This author lets you - the reader - decide.**

***

#### Tools Used

* [SteemSQL](http://www.steemsql.com/) by @arcange
* Node.js and npm to extract the data
* Power BI and Excel to generate the charts

#### Source Code

Codes used to extract data for this analysis are available in Github:
https://github.com/eastmaels/biutopian

***
<sup>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...</sup>

<sup>You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j</sup>

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@eastmael/utopian-top-projects-a-closer-look-blockchain-business-intelligence">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>