The Prep Off: Alteryx vs Tableau Prep Round 2

Two major contenders in the ring tonight: new but developing at light speed, Tableau Prep and tried and trusted, Alteryx Designer.

Who will win this time after a draw in the last Prep Off? Watch the replay of Round 1 here.

How do these two softwares compare when cleaning an Excel spreadsheet with 182 fields? The chosen data features the table seen in Figure 1. This data was used in Makeover Monday Week 2 2019 (after it was cleaned, of course). Download the Excel file (Freedom of the Press) and follow along with me. 

Fig 1. Original Excel spreadsheet. Years go from 1979-2016

Ready? Fight!

The Prep Off: Alteryx vs Tableau Prep

The Prep Off…

Two major contenders in the ring tonight: new kid on the block, Tableau Prep and reigning champion here at the Information Lab, Alteryx Designer.

How do these two softwares compare when cleaning two Excel sheets (within the same workbook)? The chosen data features the table seen in Figure 1. The data includes merged cells, totals, unnecessary content, dates in a row and times in a column, plus its in German! Download the Excel file (2018-09-18 Hamburg) and follow along with me.

Fig 1. Original Excel spreadsheet sample with red boxes indicating the removable content

 

Ready? Fight!