Using Alteryx for Data Quality checks

2018-05-22T19:27:36+00:00November 15th, 2016|Alteryx|

Data Quality is now a rapidly growing area in many Financial Services organisations. There are multiple vendors, such as Informatica and Ab Initio, with software specifically marketed as a data quality tool. Undoubtedly they are both great products, however they are expensive, in all likelihood in the majority organisations would take significant time before they [...]

Move or Copy files in Alteryx

2018-05-22T19:29:55+00:00July 26th, 2016|Alteryx|

In previous posts I’ve written about how to use the Run Command tool in Alteryx to publish a tableau extract to tableau server and how to unzip a file in Alteryx. Another great use for the Alteryx Run Command tool is to move and copy files. To move files from a directory into another directory [...]

Unzip a file in Alteryx

2018-05-22T19:26:07+00:00April 21st, 2016|Alteryx|

I question often seen on the Alteryx forums is how to unzip a file in Alteryx. In an earlier post I covered how to use the Alteryx Run Command tool to publish a Tableau Data Extract to the Tableau Server in an Alteryx workflow using TabCmd. This post is similar but is showing how to [...]

Install Alteryx non admin version

2016-02-10T10:34:15+00:00February 10th, 2016|Alteryx|

Installing the Alteryx non admin version was a slight challenge as I couldn't find the right link simply from the Alteryx home page. Therefore here is a link taking you to the page containing the latest admin and non admin versions of Alteryx:

Publish Tableau Data Extract directly from Alteryx

2018-05-23T07:18:44+00:00December 29th, 2015|Alteryx, Tableau, Tableau Server|

For those Alteryx and Tableau Server users the ability to publish Tableau Data Extract (tde) files directly from Alteryx to the Tableau Server is a huge benefit for report automation. There are a number of good posts already published advising how this should be done, such as this excellent guide from Interworks. In this post [...]

Alteryx output to Tableau Data Extract tde file

2015-10-06T21:30:09+00:00October 6th, 2015|Alteryx, Tableau|

To output data from Alteryx to Tableau is incredibly simple, Alteryx has the output File Format of a TDE file. Just select your data, drag in an Output tool and set the file type to be Tableau Data Extract (tde). Alternatively enter a .tde file name into the 'Write to File or Database' input box [...]

Starting out with R in Alteryx

2018-05-07T18:36:03+00:00February 17th, 2014|Alteryx|

One of the great things that makes Alteryx so useful is the integration with R, making advanced statistical analysis possible for those without the ability to code in R. As part of my Alteryx training series the R integration is one of the areas I believe is key to learn. If you are new to [...]

2012 Primary Schools Performance in Tableau

2018-05-07T07:34:25+00:00February 8th, 2014|Alteryx, Tableau|

I wrote an earlier post as part of my Alteryx training using 2012 UK primary school data. As per this post on joining data in Alteryx, using the trade area tool in Alteryx and exporting the data into a TDE file, a Tableau Data Extract, I have now put the data into Tableau. In a [...]

Alteryx and Tableau to display UK schools data

2018-05-21T20:06:00+00:00February 6th, 2014|Alteryx, Tableau|

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 example to test it out. I recently had a baby so have to start thinking about schools. Luckily the UK government make school performance data public and the excellent Guardian [...]