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.
Last month, DS11 taught the public Tableau and Alteryx and this month, we are conducting webinars teaching the same content. Check out our meetup page for more details on upcoming webinars and events!
For both of these lessons, I taught Alteryx Data Prep. If you missed my webinar, it was recorded and will be uploaded so I will update this post with a link later.
In this blog post, I will go over my teaching experience and some top tips from myself and from the beautiful people at the Information Lab.
My Teaching Experience and Top Tips!
To prepare for teaching, I sought advice from the wealth of experience of the Information Lab consultants. The advice I received was super useful and helped me to prepare my lesson plan. Figure 2 below shows all the teaching tips I gathered categorised into four sections.
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.
DS11’s first week at the Data School was focused on introducing us to Alteryx; a super useful software for prepping messy data before visualising in Tableau. Amongst data preparation, Alteryx is also capable of spatial and predictive uses. In this guide, we will navigate through the interface of Alteryx Designer and I will also give some helpful hints on how to get started. Now, download Alteryx Designer and let’s get acquainted.
Alteryx Designer Interface
When opening Alteryx Designer, you will be met with an interface that looks like Figure 1. Matlab users out there will be very familiar with this layout!