Challenge:-
Enable external connections to the Tableau
Server Repository and, using Tableau Desktop, create a Viz showing the most
popular workbooks in terms of Users and Views.
Steps:-
1. The Tableau Server repository is configured to block external connections by default. We can use 2 accounts to connect to the repository, ‘tableau’ and ‘readonly’, and these can be enabled with the following commands:
tabadmin dbpass --username tableau p@ssword
tabadmin dbpass --username readonly p@ssword
More
details about this process can be found on this article.
2. Open a new instance of Tableau Desktop and open a new ‘PostgreSQL’
connection:
More
details about this connection can be found here.
3. In the Data Source tab, bring in the ‘_views_stats’ and
‘_workbooks’ tables, join them by ‘workbook_id’ as indicated below:
4.Go into a new sheet
and build a customized viz.
5.Done!!!
Thanks Guru's,
Prazval.ks
