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. …
Tableau Candlestick Chart
This post shows how to create a candlestick chart in Tableau. It shows two different techniques to build a tableau candlestick chart. The first technique …
SSIS Import Multiple Files into a Table
Using SSIS I had a problem passing a file name into a Data Flow Task as a parameter. The Data Flow Task was part of …
Order of operations in Tableau
Edit: Since the below post was first written, back in 2013, Tableau has significantly evolved. Tableau have a page dedicated to showing the order of …
Keep an aggregation static and unaffected by Filter in Tableau
A question I’ve seen asked many times in different guises is how to keep an aggregation static in Tableau. Effectively this is creating a constant …