Sort:  

let me know if you need help. I love excel power tools( I teach using them)

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?

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.

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?

sure thing. I am on discord paulag#0515 you will find me in whaleshares or pal.

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

There is also a language behind power query, know as M (not MDX)

Coin Marketplace

STEEM 0.23
TRX 0.24
JST 0.038
BTC 95361.20
ETH 3282.78
USDT 1.00
SBD 3.29