Tableau Connect to Sharepoint Lists
Within Tableau it’s possible to connect to a Sharepoint list using the OData data connector. To connect to a Sharepoint list takes some understanding of …
Using Tableau Server groups for row level security
Tableau Groups are a very efficient way to manage security. User permissions managed in groups is far simpler to manage compared to managing each user …
Tableau row level security
There are a number of options available to implement row level security in Tableau. Row level security is to restrict access to only certain records …
SQL create a delimited string from a flat file
Recently I wrote a post on how to split a delimited string in SQL. Now I need to do the reverse and take the flat …
SQL split string by a delimiter to create new rows
Ever need to split a delimited string in SQL, creating new records? For example you could have a table called Users: Country User UK Bob|Fred|Bill …
Using Tableau’s database to build your own Tableau Server usage reports
Tableau provides some good tools to monitor what is happening on each Tableau site on the Tableau Server. Site admins and above have access to …
Starting out with R in Alteryx
One of the great things that makes Alteryx so useful is the integration with R. This makes advanced statistical analysis possible for those without the …
Alteryx and Tableau to display UK schools data
As part of my Alteryx training, following on from my starting out with Alteryx, I decided to try and use it for a real world …
Starting out with Alteryx
With all of the buzz around Alteryx I am trying learn it in my spare time. My initial thoughts on Alteryx are that it should …
Excel unprotect workbook and worksheets using VBA
I inherited some Excel spreadsheets which had protected workbooks and worksheets, but an unprotected VBA project. I didn’t have the passwords for the Excel spreadsheets. …