Dashboard Week Day 1: Webscraping Asos

by Sarah Jellenc

Day 1 of Dashboard Week was certainly a challenge! Our task was to web scrape all the new men’s and women’s clothing items from the Asos website in Alteryx and then use that data to build a viz in Tableau. We needed to pull out the brand, cost, description, and product type for each individual item.

Once I had built a functional workflow to scrape the items from the first page of men’s clothing and the first page of women’s clothing, I created a macro (with lots of help from Jonathan and Hesham) to pull the data I needed from the subsequent product pages. It’s a mess of a workflow, but it got the job done:

Once I got the macro working for women’s clothing, I repeated the process for men’s clothing and unioned the two outputs.

Finally, I threw the resulting data set into Tableau to try to build a viz in a mad frenzy.

How to Prepare for the Tableau Certified Associate Exam

3 mins read

Tue 27 Aug 2019

Dashboard Week Day 5: Uber Movement

1 mins read

Fri 23 Aug 2019

Dashboard Week Day 4: No-go for Tableau

2 mins read

Thu 22 Aug 2019

Dashboard Week Day 3: Four KPI Dashboards

2 mins read

Wed 21 Aug 2019