by Daniel Lawson | May 4, 2023 | Daniel Lawson
Parsing unstructured text is a nightmare. As Data Analysts, clean data is a bit of a unicorn. If you’re lucky you might get data in a nice tabular dataset with columns and rows, but this isn’t always the case. Sometimes you’ll receive completely...
by Daniel Lawson | May 3, 2023 | Daniel Lawson
Here’s a story of how I extracted hidden data from an Excel template and saved hours of manual work. What I learned might just help you some day so come along for the journey and learn about XML files. The Hidden Life of XML Files An XML file by any other name would...
by Daniel Lawson | Mar 7, 2023 | Daniel Lawson
Hey ChatGPT, can you summarise this article for me? Sure thing! The article discusses the problem of parsing unstructured data and the challenge it poses for data analysis. Dan proposes a solution using natural language processing (NLP) and specifically ChatGPT API,...
by Daniel Lawson | Jan 30, 2023 | Daniel Lawson
LAG() & LEAD() | Advanced SQL Functions This is the second post in an N-Post series on Advanced SQL with a focus on Window Functions. You can find the first post here Intro to Window Functions in SQL. Stick around to level up your SQL skills. Preamble LAG()...
by Daniel Lawson | Jan 16, 2023 | Daniel Lawson
Preamble Parsing API Responses in Alteryx is a staple of the data analytics process, and the tool that enables is, the Download Tool is key. If you’ve had experience working with APIs then you might have use the Formula Tool to compose URLs before downloading them. If...
by Daniel Lawson | Jan 7, 2023 | Daniel Lawson
The Derbies Down Under: Who Comes Out On Top? Link to Viz on Tableau Public I’ll be the first to admit that this dashboard is not my proudest work. But, if we only share our wins then we set unrealistic expectations for those that come after us; those that want...
