For the last 25 years and the next 25 years, the Holy Grail of BI and Analytics is, was, and shall be Adoption.
On Tableau Server, with a little elbow grease, we can get down to the nitty-gritty details of what users are doing, and figure out where we can create enablement and training programs. I’ve been combing the repository for the last few months to find the nuggets, and I’m happy to share them here.
From the HTTP_REQUESTS table, you can find out if the user taking advantage of…
Ask Data?
Contains([Http Request Uri (Http Requests)],'AskData')
Customized Views?
Contains([Http Request Uri (Http Requests)],'get_customized_view')
Explain Data?
Contains([Http Request Uri (Http Requests)],'explain-selected-mark')
Downloading Crosstabs?
CONTAINS([Http Request Uri (Http Requests)],'export-crosstab-to-csvserver')
Downloading Data?
CONTAINS([Http Request Uri (Http Requests)],'?summary=true')
Downloading Images?
CONTAINS([Http Request Uri (Http Requests)],'export-image-server')
Downloading PDFs?
CONTAINS([Http Request Uri (Http Requests)],'pdf-export-server-dialog')
Downloading PowerPoints?
CONTAINS([Http Request Uri (Http Requests)],'power-point-export'
Using via Mobile?
CONTAINS([Http User Agent (Http Requests)] ,'Mobile')
//You can also parse for 'Apple' and 'Android'
From the Asset_List table, you can see if the user is…
Using Collections?
[List Type] = 'collection'
Using Favorites?
[List Type] = 'favorites'
From the Share_Contents table, you can see what the user is sharing…
[Content Type] = 'collection'
[Content Type] = 'customizedview'
[Content Type] = 'datasource'
[Content Type] = 'project'
[Content Type] = 'view'
[Content Type] = 'workbook'
[Content Type] = 'metric'
From the User_Prefs table, you can see if the users have customized their preferences with this…
IF [Is User Set Timezone]
OR [Suspended Data Alert Notification]
OR [Suspended Subscription Notification]
OR [Suppress Getting Started Notifications]
OR Not ISNULL([Start Page])
OR Not ISNULL([Language Id])
OR Not ISNULL([Locale Id])
Then 'Yes' Else ''
END
Do you have anything you are tracking? Please share in the comments!