Dashboard Week Day 1

First day of dashboard week. I created an iterative macro to scrape data from the Asos website to visualise in Tableau.

The two most useful pieces of RegEx I used were:

The non greedy expression .*? to get clumps of data between fields: for example <article.*?

And

Using [a-z’-]* instead of \w* so that i could capture any number of words separated by hyphens.

It worked out perfectly in the end, but took waayyyyy longer than expected, so while it was an exciting day of Alteryx, the dashboard…

Author:
Ruth Amarteifio
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab