How To Analyze Utopian Contributions Using BI-Utopian and Excel

"Teaching is a noble profession." - heard from my mentor
"No man is an island." - John Donne

These were the messages that reverberated in me that prompted me to write this.

In this tutorial, I'll walk you through how I generated my analyses using the open-source tool biutopian.

Outline

1. Background
2. Available Biutopian Tools
3. Installation
4. Run Biutopian's Data Extractor
5. Sample Analysis

1. Background

This tool was prompted both by the #blockchainbi (formerly #bisteemit) and #utopian-io communities. The tool was initially used as a private repository and then eventually shared as an open-source project.

This is not an automated post creator tool. It just extracts the data as a CSV and then analysis is manually done on that extracted data.

There are other SQLs I use with my analyses that are outside the scope of this tutorial. These SQLs are simpler in nature and I believe the readers can easily research on their own.

2. Available Biutopian Tools

As of this writing, there are three tools available in the said project:

1. utopian_io_all_time.js - this gets all the posts from utopian voting history where the @utopian-io bot has voted for posts (excludes up-votes on comments and down-votes on top-level posts);
2. steem_languages.js - extracts the number of posts in different languages by date; this is from the STEEM blockchain as a whole;
3. utopian_not-voted.js - still under development; this aims to analyze the number of contributions not voted by the bot in a round;

In this tutorial, we will cover utopian_io_all_time.js - how to analyze Utopian contributions up-voted by the bot.

3. Installation

As written in the project's README, to run biutopian tools, you'll need the following to generate the CSV file:

1. git
   • I use git for windows
2. node.js

Follow the installation instructions for these two tools and when done, come back to this tutorial.

I also assume that a charting software is installed on your machine. This list is not extensive, but any of the following will do:

1. Ms Excel
2. Power BI
3. Libre Office

For this tutorial, let's use MS Excel.

4. Run Biutopian's Data Extractor

As mentioned in one of the previous sections, the tool this tutorial covers is utopian_io_all_time.js - data extractor for the bot's votes.

Go to any arbitrary folder (e.g., e:\develop\east\) and run the following commands:

$ git clone [email protected]:eastmaels/biutopian.git
$ cd biutopian
$ npm install
$ node utopian_io_all_time.js

Here are the steps in my environment with the corresponding screen shots:

• $ git clone [email protected]:eastmaels/biutopian.git
  
• $ cd biutopian
• $ npm install
  
• $ node utopian_io_all_time.js - this will take some time; may take up to 15 minutes;
  
• Press Ctrl + C to end the program or just close the window

If all went well, then you should have a CSV generated in your project's analysis folder with a filename in the format utopian-io_yyyymmdd_HHMMss.csv. This is the raw data to be used in this analysis.

5. Sample Analysis

For this tutorial, this author will cover a simple analysis - top contributors by post count. The final output will be like this:

---

And here's the video from YouTube.

What's Next ?

Other topics to be covered:

1. Top Contributors (by Post Count) - this post
2. Top Contributed Project
3. Top Categories by Contribution
4. Top Rewarded Authors

Tools Used to Generate this Tutorial

• SteemSQL by @arcange
• MS Excel
• node.js
• npm
• VMix for the video

Source Code

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

---

^{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...}

---

Posted on Utopian.io - Rewarding Open Source Contributors

---