create account


advanced mode

How to connect Excel to Steemd User Data - Steemit Business Intelligence by paulag

View this thread on steemit.com
View on official site
· @paulag · (edited)
$6.78
How to connect Excel to Steemd User Data - Steemit Business Intelligence
<center><a href='https://dtube.video/#!/v/paulag/9au0857a'><img src='https://earth.i.ipfs.io/ipfs/QmfDC1BWiXtpg1CMo6njG5mLKzfxQQw3RM7enQz2vqU9M1'></a></center><hr>
CLICK IMAGE TO PLAY VIDEO

There are many ways to get data into Excel and many reasons you would want to pull data into Excel.  Today we are going to use Excel to connect to Steemd and extract data for steemit accounts. The process shown can be used to extract and transform data from other websites too.

Want to know how to do this in Power BI?  http://theexcelclub.com/power-bi-connecting-to-tables-on-a-website-and-transforming-that-data/

In a recent post I went through the steps in calculating the worth of a vote.  You can read the post here. https://steemit.com/bisteemit/@paulag/how-to-calculate-the-worth-of-any-steemit-vote-steemit-business-intelligence
In this calculation we needed both the voters voting power and also the vote’s Effective sp.  What you will learn in this post is how to extract this data into excel so that you can easily update it without the need for manual entry into excel. 

Connecting to a table on a website using Excel 

The website we wish to connect to is https://steemd.com/@paulag
https://steemitimages.com/DQmVumV26aSmFKbhyQM9U15Pu2kde7WcknoGCcxzjMbeuTA/17.png
 
The fields of data that we want are in the table boxed in red. As we can see this table also contains a lot of data we do not want, data we can call noise.
To connect to the datasource in Excel we are going to use the add in Power Query (available for Excel 2010 and 2013) and is a feature of Excel 16 ‘get and transform data’.  The example shown uses Excel 2013.
In Excel on the power query ribbon first we will select from web and in the URL we can enter the website that contains the table of data.
https://steemitimages.com/DQmVKRDnQX4vL3JXpoDEdXKeq6XFhHCuX9JbrhrjtWebzMr/1.png
 
Once Excel connects to the website a new window, the navigator window will open.  On the left you can see a list of tables that Excel has found on the webpage.  By selecting a table on the left, you will see a preview on the right.  Once we have found the correct table and ensure that we have ticked it, we can then select edit.
https://steemitimages.com/DQmXuKYrUrLQmF56vTcf6VJzM4wmAfnJZTaH9yLitgHz4pR/2.png
 
By selecting edit the power query window will now open.  The data contains two columns.  The first column are attributes and the second column are the value.
 
https://steemitimages.com/DQmXr3Ty3PRwGNPZnybSYYs3QUxWbJChwfgiHbQjHQkDDBM/3.png

Transforming the data in Excel

The first step in transforming this data to a usable format is to make the attributes row headers.  The steps involved here are rather simple.

First on the transform ribbon select transpose
https://steemitimages.com/DQmb9KFmGkZRMaMiAhAGLmioMfbGovp1cYzK11XoA8U7tcq/4.png
 
This will move all of the data from column 1 to row 1 and all of the data from column 2 to row 2
 https://steemitimages.com/DQmUu7vzGxbfh4xNr65YM2ECFziP3XjiByiQAFurxDQAasu/5.png
 
Next also under the transform ribbon we will select Use First Rows and Headers.
https://steemitimages.com/DQmcj7xjz5DoyxGYG2stmgqACGXV3gSH7J7upGDBMQnic6u/6.png
 
The next step in this transformation is to remove the columns of data that we do not need.  To do this, we will select the 3 columns we need to keep.  Name, % Voting Power and Effective SP.  Once we have these selected, on the home ribbon, select remove columns and remove other columns.  We will then be left with the data that we require.
https://steemitimages.com/DQmTcbFeDrevCt5EjaNMDUazteU9rqSVyznq4CLUZXXuPWW/7.png
 
Finally we need to change the data types.  Voting power needs to be changed to % and effective sp such be a decimal number.  To do this go to the transform ribbon and select the correct data type.
https://steemitimages.com/DQmQ3Xs7Cx67tRmXNL1RwDF7L8FgcPXAEKowqH9a4LSt5JB/8.png
 
Adding more accounts to the table

Once you have created and transformed your first table of data, it is easy to add more users to this table.
Expand the query tab on the left of the screen.  In here you will find the query we have been working on.  Right click this query and select duplicate.

https://steemitimages.com/DQmWqp3EP7vQHAgDv3hDttoUeaEegieCDsEkDp9HvmaQokn/9.png
 
You can also rename the query so you don’t get mixed up.  At the moment the data in the first and second queries are the same.  To quickly change the user open the Advance editor on the home ribbon

https://steemitimages.com/DQmXCoxAPBgSETRRHcsMeXV3urNLoBfiVSqb1QFRi1fM7kH/10.png
 
This will open the advanced editor window showing the M code used to get and transform the data.  In here we will replace the name @paulag with @steemitbc found on the first row of code. Then we will save

https://steemitimages.com/DQme7qm8QTK4XsTSqVGcXsAAFbSwwBpn3s6u3EiJRsHMkyN/11.png
 
 
Our second table of data now contains the data for @steemitbc.
https://steemitimages.com/DQmYzjuSCnU81ZRxUtPCDKMzoPd4CC9zNfhunrJkC3WRyZw/12.png

Appending queries

The final step you will learn today is how to append these tables together.  In this example I have only taken two accounts, however you can do the steps above multiple times and append them all together.
To append both of these table together, select the first table from the queries tab.  Then under the home ribbon under combine, select append.  
https://steemitimages.com/DQmXwcvg2nuUuv4dZcoAeKVjMQj5r3X9kMXij2RiGSSW8kd/13.png
 
This will then open a new window allowing you select which queries you wish to append
https://steemitimages.com/DQmS2NKU4jRwiiAE7cmFKe2YiN9zruMnnaj8Pzb9oG2sxHG/14.png
 
This will leave you with a table of data containing both of the queries.

 
To keep this data up to date you just need to Refresh the data from the home ribbon.  Now if you select close and load, this will load your table into excel.

 I am part of a Steemit Business Intelligence community.  We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you... 

you can find #bisteemit on discord https://discordapp.com/invite/JN7Yv7j

Follow, upvote and resteem
<hr><a href='https://dtube.video/#!/v/paulag/9au0857a'>► Watch on DTube</a><br /><a href='https://gateway.ipfsstore.it:8443/ipfs/QmVinnU2QZaoYTiTKUdEJVwxsoqJG1ryhoJ89jsXqnFCFE'>► Watch Source (IPFS)</a>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
json_metadata"{"video":{"info":{"title":"How to connect Excel to Steemd User Data - Steemit Business Intelligence","snaphash":"QmfDC1BWiXtpg1CMo6njG5mLKzfxQQw3RM7enQz2vqU9M1","author":"paulag","permlink":"9au0857a"},"content":{"videohash":"QmVinnU2QZaoYTiTKUdEJVwxsoqJG1ryhoJ89jsXqnFCFE","description":"There are many ways to get data into Excel and many reasons you would want to pull data into Excel. Today we are going to use Excel to connect to Steemd and extract data for steemit accounts. The process shown can be used to extract and transform data from other websites too.\n\nWant to know how to do this in Power BI? http://theexcelclub.com/power-bi-connecting-to-tables-on-a-website-and-transforming-that-data/\n\nIn a recent post I went through the steps in calculating the worth of a vote. You can read the post here. https://steemit.com/bisteemit/@paulag/how-to-calculate-the-worth-of-any-steemit-vote-steemit-business-intelligence\nIn this calculation we needed both the voters voting power and also the vote’s Effective sp. What you will learn in this post is how to extract this data into excel so that you can easily update it without the need for manual entry into excel. \n\nConnecting to a table on a website using Excel \n\nThe website we wish to connect to is https://steemd.com/@paulag\n\n \nThe fields of data that we want are in the table boxed in red. As we can see this table also contains a lot of data we do not want, data we can call noise.\nTo connect to the datasource in Excel we are going to use the add in Power Query (available for Excel 2010 and 2013) and is a feature of Excel 16 ‘get and transform data’. The example shown uses Excel 2013.\nIn Excel on the power query ribbon first we will select from web and in the URL we can enter the website that contains the table of data.\n \nOnce Excel connects to the website a new window, the navigator window will open. On the left you can see a list of tables that Excel has found on the webpage. By selecting a table on the left, you will see a preview on the right. Once we have found the correct table and ensure that we have ticked it, we can then select edit.\n\n \nBy selecting edit the power query window will now open. The data contains two columns. The first column are attributes and the second column are the value.\n \n\nTransforming the data in Excel\n\nThe first step in transforming this data to a usable format is to make the attributes row headers. The steps involved here are rather simple.\nFirst on the transform ribbon select transpose\n \nThis will move all of the data from column 1 to row 1 and all of the data from column 2 to row 2\n \nNext also under the transform ribbon we will select Use First Rows and Headers.\n \nThe next step in this transformation is to remove the columns of data that we do not need. To do this, we will select the 3 columns we need to keep. Name, % Voting Power and Effective SP. Once we have these selected, on the home ribbon, select remove columns and remove other columns. We will then be left with the data that we require.\n \nFinally we need to change the data types. Voting power needs to be changed to % and effective sp such be a decimal number. To do this go to the transform ribbon and select the correct data type.\n \nAdding more accounts to the table\nOnce you have created and transformed your first table of data, it is easy to add more users to this table.\nExpand the query tab on the left of the screen. In here you will find the query we have been working on. Right click this query and select duplicate.\n \nYou can also rename the query so you don’t get mixed up. At the moment the data in the first and second queries are the same. To quickly change the user open the Advance editor on the home ribbon\n \nThis will open the advanced editor window showing the M code used to get and transform the data. In here we will replace the name @paulag with @steemitbc found on the first row of code. Then we will save\n \n \nOur second table of data now contains the data for @steemitbc.\n\nAppending queries\nThe final step you will learn today is how to append these tables together. In this example I have only taken two accounts, however you can do the steps above multiple times and append them all together.\nTo append both of these table together, select the first table from the queries tab. Then under the home ribbon under combine, select append. \n \nThis will then open a new window allowing you select which queries you wish to append\n \nThis will leave you with a table of data containing both of the queries.\n \nTo keep this data up to date you just need to Refresh the data from the home ribbon. Now if you select close and load, this will load your table into excel.\n\n I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you... \n\nyou can find #bisteemit on discord https://discordapp.com/invite/JN7Yv7j\n\nFollow, upvote and resteem\n","tags":["dtube","dtube-bisteemit","dtube-stats","dtube-excel","dtube-video"]},"_id":"c6ec3124fa795661d1c15d8a85b1e2d7"},"tags":["dtube","bisteemit","stats","excel","video"],"app":"steemit/0.1","users":["paulag","steemitbc"],"image":["https://earth.i.ipfs.io/ipfs/QmfDC1BWiXtpg1CMo6njG5mLKzfxQQw3RM7enQz2vqU9M1","https://steemitimages.com/DQmVumV26aSmFKbhyQM9U15Pu2kde7WcknoGCcxzjMbeuTA/17.png","https://steemitimages.com/DQmVKRDnQX4vL3JXpoDEdXKeq6XFhHCuX9JbrhrjtWebzMr/1.png","https://steemitimages.com/DQmXuKYrUrLQmF56vTcf6VJzM4wmAfnJZTaH9yLitgHz4pR/2.png","https://steemitimages.com/DQmXr3Ty3PRwGNPZnybSYYs3QUxWbJChwfgiHbQjHQkDDBM/3.png","https://steemitimages.com/DQmb9KFmGkZRMaMiAhAGLmioMfbGovp1cYzK11XoA8U7tcq/4.png","https://steemitimages.com/DQmUu7vzGxbfh4xNr65YM2ECFziP3XjiByiQAFurxDQAasu/5.png","https://steemitimages.com/DQmcj7xjz5DoyxGYG2stmgqACGXV3gSH7J7upGDBMQnic6u/6.png","https://steemitimages.com/DQmTcbFeDrevCt5EjaNMDUazteU9rqSVyznq4CLUZXXuPWW/7.png","https://steemitimages.com/DQmQ3Xs7Cx67tRmXNL1RwDF7L8FgcPXAEKowqH9a4LSt5JB/8.png","https://steemitimages.com/DQmWqp3EP7vQHAgDv3hDttoUeaEegieCDsEkDp9HvmaQokn/9.png","https://steemitimages.com/DQmXCoxAPBgSETRRHcsMeXV3urNLoBfiVSqb1QFRi1fM7kH/10.png","https://steemitimages.com/DQme7qm8QTK4XsTSqVGcXsAAFbSwwBpn3s6u3EiJRsHMkyN/11.png","https://steemitimages.com/DQmYzjuSCnU81ZRxUtPCDKMzoPd4CC9zNfhunrJkC3WRyZw/12.png","https://steemitimages.com/DQmXwcvg2nuUuv4dZcoAeKVjMQj5r3X9kMXij2RiGSSW8kd/13.png","https://steemitimages.com/DQmS2NKU4jRwiiAE7cmFKe2YiN9zruMnnaj8Pzb9oG2sxHG/14.png"],"links":["https://dtube.video/#!/v/paulag/9au0857a","http://theexcelclub.com/power-bi-connecting-to-tables-on-a-website-and-transforming-that-data/","https://steemit.com/bisteemit/@paulag/how-to-calculate-the-worth-of-any-steemit-vote-steemit-business-intelligence","https://steemd.com/@paulag","https://discordapp.com/invite/JN7Yv7j","https://gateway.ipfsstore.it:8443/ipfs/QmVinnU2QZaoYTiTKUdEJVwxsoqJG1ryhoJ89jsXqnFCFE"],"format":"markdown"}"
last_update2017-09-06 14:02:00
created2017-09-06 13:44:36
active2017-09-07 08:34:51
last_payout2017-09-13 13:44:36
depth0
children8
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value4.900 SBD
curator_payout_value1.881 SBD
author_rewards3,966
net_votes130
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries
0.
accountdtube
weight2,500
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation6,269,402,668,703
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (132)

vote your-acct "paulag" "9au0857a" 100 true
post_comment your-acct "re-paulag-9au0857a-20170923t075604266z" "paulag" "9au0857a" "" "your reply.." "{}" true

View on official site
@rt395 ·
Finally we get to see how you do it. I think this post is going to the moon!
json_metadata{"tags":["dtube"],"app":"steemit/0.1"}
created2017-09-06 14:17:06
active2017-09-06 17:32:18
last_payout2017-09-13 14:17:06
depth1
children3
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation2,213,530,769,728
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "rt395" "re-paulag-9au0857a-20170906t141705931z" 100 true
post_comment your-acct "re-rt395-re-paulag-9au0857a-20170923t075604277z" "rt395" "re-paulag-9au0857a-20170906t141705931z" "" "your reply.." "{}" true

View on official site
@paulag ·
this post was a nightmare.  because I have used Dtube, I was unable to load the images when I created the post on Dtube.  This means I then had to edit the post to add the images, but even at that it was not that simple.
👍  
json_metadata{"tags":["dtube"],"app":"steemit/0.1"}
created2017-09-06 14:20:15
active2017-09-06 17:32:18
last_payout2017-09-13 14:20:15
depth2
children2
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation6,269,402,668,703
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "paulag" "re-rt395-re-paulag-9au0857a-20170906t142016550z" 100 true
post_comment your-acct "re-paulag-re-rt395-re-paulag-9au0857a-20170923t075604286z" "paulag" "re-rt395-re-paulag-9au0857a-20170906t142016550z" "" "your reply.." "{}" true

View on official site
@rt395 ·
Well it shows the lengths you'll go to do things right. Did you just screenshot them?

I really don't like posts with only video's and no written description. Video's are great, but in the internet age, time matters.
json_metadata{"tags":["dtube"],"app":"steemit/0.1"}
created2017-09-06 14:28:21
active2017-09-06 17:32:18
last_payout2017-09-13 14:28:21
depth3
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation2,213,530,769,728
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "rt395" "re-paulag-re-rt395-re-paulag-9au0857a-20170906t142822314z" 100 true
post_comment your-acct "re-rt395-re-paulag-re-rt395-re-paulag-9au0857a-20170923t075604295z" "rt395" "re-paulag-re-rt395-re-paulag-9au0857a-20170906t142822314z" "" "your reply.." "{}" true

View on official site
@paulag ·
time does matter.  yep I screen captured the images as I worked through the exercise
json_metadata{"tags":["dtube"],"app":"steemit/0.1"}
created2017-09-06 17:32:18
active2017-09-06 17:32:18
last_payout2017-09-13 17:32:18
depth4
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation6,269,402,668,703
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-rt395-re-paulag-re-rt395-re-paulag-9au0857a-20170906t173221906z" 100 true
post_comment your-acct "re-paulag-re-rt395-re-paulag-re-rt395-re-paulag-9au0857a-20170923t075604303z" "paulag" "re-rt395-re-paulag-re-rt395-re-paulag-9au0857a-20170906t173221906z" "" "your reply.." "{}" true

View on official site
@minnowsupport ·
$0.09
<p>Congratulations!  This post has been upvoted from the communal account, @minnowsupport, by paulag from the Minnow Support Project.  It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews/crimsonclad, and netuoso.  The goal is to help Steemit grow by supporting Minnows and creating a social network.  Please find us in the <a href="https://discord.gg/HYj4yvw">Peace, Abundance, and Liberty Network (PALnet) Discord Channel</a>.  It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.</p>
👍  
json_metadata{"tags":["dtube"],"app":"cosgrove/0.0.1rc7"}
created2017-09-06 14:21:12
active2017-09-06 14:21:12
last_payout2017-09-13 14:21:12
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.068 SBD
curator_payout_value0.022 SBD
author_rewards56
net_votes1
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation27,431,382,614,741
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "minnowsupport" "re-paulag-9au0857a-20170906t142111865z" 100 true
post_comment your-acct "re-minnowsupport-re-paulag-9au0857a-20170923t075604311z" "minnowsupport" "re-paulag-9au0857a-20170906t142111865z" "" "your reply.." "{}" true

View on official site
@ervin-lemark ·
Hello. A neat trick. I didn't know that excel (with addons) can query a web page. I first thought that this tutorial will be about accessing data from [steemsql.com](http://www.steemsql.com/).

Nice to know that it could be done in many ways. Thanks!
json_metadata{"tags":["dtube"],"links":["http://www.steemsql.com/"],"app":"steemit/0.1"}
created2017-09-06 14:56:51
active2017-09-06 17:35:21
last_payout2017-09-13 14:56:51
depth1
children1
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation55,575,775,198,412
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "ervin-lemark" "re-paulag-9au0857a-20170906t145652895z" 100 true
post_comment your-acct "re-ervin-lemark-re-paulag-9au0857a-20170923t075604317z" "ervin-lemark" "re-paulag-9au0857a-20170906t145652895z" "" "your reply.." "{}" true

View on official site
@paulag ·
Thank you @ervin-lemark.  Excel has awesome powers now.  is is the basis for microsofts new package, power bi.

I also access data from steemsql, its an awesome resource.  I will be doing some tutorials on it in the future
json_metadata{"tags":["dtube"],"users":["ervin-lemark"],"app":"steemit/0.1"}
created2017-09-06 17:35:21
active2017-09-06 17:35:21
last_payout2017-09-13 17:35:21
depth2
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation6,269,402,668,703
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "paulag" "re-ervin-lemark-re-paulag-9au0857a-20170906t173522767z" 100 true
post_comment your-acct "re-paulag-re-ervin-lemark-re-paulag-9au0857a-20170923t075604323z" "paulag" "re-ervin-lemark-re-paulag-9au0857a-20170906t173522767z" "" "your reply.." "{}" true

View on official site
@pisolutionsmru ·
Really great trick!

Who would have thought Excel has this power also XD

Thanks for sharing :)

After talking with @heimindanger, I made a post with the latest stats of DTube and how well it is competing with Youtube. Do check it out! You are part of the stats @paulag :)

Cheers XD
json_metadata{"tags":["dtube"],"users":["heimindanger","paulag"],"app":"steemit/0.1"}
created2017-09-07 08:34:51
active2017-09-07 08:34:51
last_payout2017-09-14 08:34:51
depth1
children0
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment12,105,888
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
beneficiaries[]
root_title"How to connect Excel to Steemd User Data - Steemit Business Intelligence"
pending_payout_value0.000 SBD
total_pending_payout_value0.000 STEEM
author_reputation2,439,558,649,900
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "pisolutionsmru" "re-paulag-9au0857a-20170907t083451575z" 100 true
post_comment your-acct "re-pisolutionsmru-re-paulag-9au0857a-20170923t075604330z" "pisolutionsmru" "re-paulag-9au0857a-20170907t083451575z" "" "your reply.." "{}" true


created by @roadscape