Connecting Steem with Tableau

in #steem7 years ago

Here is a setup tutorial on how to connect steem database (MS SQL Server) to Tableau.

Step 1:

Installing SQL Server ODBC drivers on your machine.

Please use below link to download & install ODBC drivers on your machine depending on your OS.

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

Restart the machine once drivers are installed

Step2:

Entering SQL Server credentials in Tableau

Open Tableau Professional. Unfortunately, you will need the Professional Edition since the Personal edition doesn't contain the connector for SQL Server.

Goto Connect > Microsoft SQL Server

Enter credentials:
Server: sql.steemsql.com
User: steemit
Pass: steemit

Screen Shot 2017-12-17 at 6.16.06 PM.png

Step3:

Choose the right tables and happy Tableauing.

Once the connection has been established, choose your tables and plot your charts.

Screen Shot 2017-12-17 at 6.41.43 PM.png

Unfortunately steem is providing access to few tables only to public (Ex: Followers, Reblogs, etc.) and hope we get access to others as well.

Step4:

Example chart in Tableau.

Below is the chart containing accounts with highest followers in Tableau.

Screen Shot 2017-12-17 at 6.50.26 PM.png

KINDLY UPVOTE IF YOU LIKE THIS POST

Coin Marketplace

STEEM 0.20
TRX 0.13
JST 0.030
BTC 65800.35
ETH 3464.66
USDT 1.00
SBD 2.68