Good Afternoon Reader,
Today we had to web-scrap a cocktail website & use that data to create a dashboard. This was far harder than I and the cohort anticipated and there was a large group effort to complete this. I spent time in Excel & Power Query in an attempt to see if it could be completed in a faster & expeditious way there, but was met with resistance against the advanced editor within Power Query.
Ultimately this was all resolved within Alteryx. We created a batch macro that was replacing the browsing page within the cocktail website. One of our largest walls within this was - retrieving data past the search page for the letter A. After resolving this & retrieving the names of the cocktails we raced to the next section which was simply retrieving the other components of the beverages, however a lot of time had passed since then.
My own personal hurdle was filtering beverages to only view the drinks that contained Rum - as I'd tried to create a story/narrative on Pine Colada's - which naturally meant that I'd need to group / set / filter my data to only look at Rum as an ingredient. This was far harder than I anticipated due to the different variations of rum & the way it had been inputted, from Oz / tbsp / 1 / 3 / 'Rum/ 'rum'/ ' rum'.
I received some guidance to help segregate my data with a lifeline in the form of this LOD = { FIXED [Drink Name]: MAX([RUM])}.
In which RUM = IF CONTAINS([Ingredients], "rum") then 1 else 0 end.
I had limited time after Millie allowed me to continue to create the dashboard; and ultimately landed with this:
In the timeframe and with the constraints - I can at least look at this dashboard & smile.
During my time next week I see myself keeping this draft up but heavily modifying this to perhaps analyse Pina Colada's against the other beverages.
Dashboard week was enjoyable but today... today was...
Anyway, I hope you can enjoy a nice pina colada whilst drinking this and enjoy good friday.