Parsing data with RegEx

Parsing data with RegEx

Before the Christmas break I did Alteryx Challenge 188 on parsing data. In the challenge, we are asked to extract relevant tax data from a text file and present it as shown in the screenshot below. This looks like a daunting task, but with a bit of RegEx magic and a...
Cross Tab – My New Best Friend

Cross Tab – My New Best Friend

If I can give myself in the past a piece of advice about Tableau, that would be to use crosstab. This is especially the case when you have a lot of calculations going on in your Tableau workbook. During those days preparing for the Data School application, I often...