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
Feed Me Data 