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!

Click to keep reading!

Dashboard Week Day 3 : Power BI for noobs

SPOILER ALERT: I like Power BI. Of course it has pros and cons, but overall, not too shabby.

 

Woah, we’re half way there! Woahhhhh!

It’s day 3 of Dashboard week which means we’re at the halfway point! See my viz from yesterday here.

Last night, Andy commented on Twitter that today’s project will be an ‘adventure’ (Figure 1). Immediate alarm bells!

Fig 1. Day 3 will be an adventure? Hmmmm that can’t be good.

 

And what an adventure it was.

 

Click to keep reading!

The Prep Off: Alteryx vs Tableau Prep

prep off

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!

Click to keep reading!