As Steemit community is growing ,I think tools to analyze the performance of accounts are becoming more necessary
There are already some tools like Steemd,Steemdb,Vessel,etc.. which are helping many steemians to track their accounts, but I think an Excel tool will do much quicker to to work with large amounts of data
SteemOffice is a tool which wants to make easier to work with Steemit Accounts , both by showing meaningful charts to get perspective on the real state of our accounts,and also providing dynamic pivot tables as a source to elaborate analysis
SteemOffice pulls the data from SteemAPI , in this first version the tools is querying Account and Posts information , but eventually can get info of the Network and Market state which also provides the API
You can get the first version of the Excel Macro workbook here it will work in any Windows OS system with any recent MsExcel installed (you need to allow macros to run )
Please feel free to check the Excel , review the code , and give me feedback or any info you would like SteemOffice to pull in the future
Awesome, will try it out!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great! feedback appreciated!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks man, I'll use it tonight on my laptop!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks , let me know your thoughts about the tool
And dont forget it works better if you upvote the post ; )
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks a lot! I will, usually after 30 minutes!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is really good. Have you thought about using Power Query to connect to the datasource and then using Power Pivot and DAX to do a deeper analysis?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Not yet , but I will investigate
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
let me know if you need help. I love excel power tools( I teach using them)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Well , yes I need a lot of help :) , and you look quite an expert on Power Queries
I have worked mainly at calling the apis and processing JSON
But the "front" of the Excel can be definitely improved , maybe Power Querys could be used for it ,how do you see it?
From the other side, to get data from a SQL source I think we would need to use something like :
https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data
I have not checked if it is working fine
A quick question :
Can a Power Query pull data from a web api?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
yes power query can pull from an api and work with JSON. My problem is that I don't know sql. we should team up on this one.
Microsoft released power BI, which is a combo of Power Query, Power Pivot, and Power View. The interactive reports can be embedded then. So much better than the excel power tools.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sounds interesting :)
I have been struggling with the apis lately
Are you on the steemchat or discord or similar?, Would you have time to talk on this tomorrow?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
sure thing. I am on discord paulag#0515 you will find me in whaleshares or pal.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The fount end is more power view. Query is for getting the data, Power Pivot is for modeling the data (using DAX functional language for BI) and power view is for visualizing and telling stories with the data
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
There is also a language behind power query, know as M (not MDX)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
muy bueno tioo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Siguiendo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome. good post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @steemalf! You have received a personal award!
Click on the badge to view your own Board of Honor on SteemitBoard.
For more information about this award, click here
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very informative post, thanks for sharing.
I have the pleasure to follow you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @steemalf! You have received a personal award!
Click on the badge to view your Board of Honor.
Do not miss the last post from @steemitboard:
SteemitBoard and the Veterans on Steemit - The First Community Badge.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @steemalf! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit