+-+-+ +-+ +-+-+-+-+
|G|O| |4| |H|I|V|E|
+-+-+ +-+ +-+-+-+-+

 --- A GOPHER-LIKE INTERFACE FOR HIVE BLOCKCHAIN ---

Connecting Steem with Tableau

BY: @deepreddy | CREATED: Dec. 17, 2017, 11:52 p.m. | VOTES: 4 | PAYOUT: $0.75 | [ VOTE ]

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

[IMAGE: https://steemitimages.com/DQmVW9NNomoudFdQoki65psZ8ZvZXnGkvaGVy6zk1kCKv5g/Screen%20Shot%202017-12-17%20at%206.16.06%20PM.png]

Step3:

Choose the right tables and happy Tableauing.

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

[IMAGE: https://steemitimages.com/DQmYDRb78EgA8uKSxHuDmCLxXiW28cH6Dx7SxUBnZm1d9d3/Screen%20Shot%202017-12-17%20at%206.41.43%20PM.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.

[IMAGE: https://steemitimages.com/DQmYLXoq8U6ACNJM1VTpJ5N3kEJZfUbcFPmL7oZjaAtEBxr/Screen%20Shot%202017-12-17%20at%206.50.26%20PM.png]

KINDLY UPVOTE IF YOU LIKE THIS POST

TAGS: [ #steem ] [ #tableau ] [ #steemit ] [ #programming ] [ #odbc ]

Replies

@geekscience | Dec. 17, 2017, 11:58 p.m. | Votes: 1 | [ VOTE ]

very nice.

[ BACK TO TRENDING ] [ BACK TO MENU ]
CMD>