Published inTowards DevHow to use Python to send messages into a slack channelLooking back at my codebase for the last few years, I found some code which I wrote to post messages into slack using python. The reason…Dec 18, 2023Dec 18, 2023
Published inTowards DevAssigning a fixed IP address to a GCP Compute Engine instanceHave you ever spun up a compute engine instance within GCP but struggled to have a fixed IP address? I have. There have been two recent…Aug 31, 2023Aug 31, 2023
Published inSelectFromSave a tonne of time & effort BigQuery SQL using QUALIFY for Windowing FunctionsEveryone talks about saving time and effort but very few actually find solutions to their problems. In the world of analytics, automation…Oct 13, 20222Oct 13, 20222
Published inTowards DevPython code to generate LookML from Pandas dataframeAnother week, another opportunity to make life simpler. For the past couple of weeks I have been supporting people with Looker and having…Sep 21, 2022Sep 21, 2022
Published inTowards DevConverting API request from curl to pythonI have recently created an app in streamlit using python to fetch the latest exchange rates from Remitly and Wise and then carry out some…Sep 15, 2022Sep 15, 2022
A single function for all time series/regression model statsOver the past few weeks I have been working on a regression analysis project. I took this project on from someone else and I had been given…Aug 8, 2022Aug 8, 2022
Linear Regression vs Elastic Net Regression in PythonI’ve recently discovered elastic net for building models using Python so I thought I would write up about it as its good for the community…Jul 12, 2022Jul 12, 2022
Published inTowards Dev2 ways to chain your SQL queries Google Cloud PlatformI’ve recently been chaining my queries and cloud functions using cloud scheduler as my source of keeping things running on time. However…Jun 22, 20221Jun 22, 20221
My first data science hackathonOn Tuesday 14th June 2022, I embarked on an EMEA wide data science hackathon. Objective: Predict the advertising genre category of…Jun 15, 2022Jun 15, 2022
Roadmap: Creating a simple marketing data science roadmapAIDA is also known as the conversion funnel. It is the process that marketers use to nurture customers through the journey with the end…Jun 9, 2022Jun 9, 2022