Rounding Calculations in Tableau (and Excel and Alteryx)

I was doing some table calculations in Tableau and needed complete control over the rounding that was used. Tableau provides a single ROUND function. The exact specification of this (I believe) depends on the data source you are connected too, as it passes through to the underlying server. I needed to be able to look at…

Downloading FTSE Data From Yahoo! and Quandl using Alteryx

Following on from another post on downloading Quandl into Tableau via Python and the Data Extract API, I wanted to try downloading the current components of the FTSE 100, and then for each one download the history of prices using Alteryx. Yahoo! finance has a web page with the members of the index: The list…

Getting Started with Alteryx (Part 3) … Reading CSVs

One of the most common data file formats I have to deal with is CSV files. Assuming your file is well formed (i.e. starts in the top row, with or without a header, in a nice continuous table), then there is no difficulty. Drag the file into Alteryx’s designer and it will create an Input…

Getting started with Alteryx (part 1) …

I have been spending a fair amount of my time at work using Alteryx Designer. It is a nice ETL tool and is a great tool for use along side Tableau. I have found myself using it as a proof of concept for a data flow before transitioning back to my traditional Visual Studio C#…