blog
- That time my SQL tips and tricks went viral
- Data cleaning with SQL: filling missing dates
- Using SQL to calculate how often and how many days a store's inventory is out of stock
- Creating custom colour palettes in Tableau from the command-line
- Which Sydney LGAs have the lowest and highest unemployment rates?
- Using Spotify's Web API to analyse my Favourite Rock playlist
- Splitting a delimited string column into rows using Snowflake
- Applying colour conditional formatting to individual table columns in Tableau