The archive
Imagine a scenario where you’re tasked with analysing sales data for the prior two years, but you’ve been given the information in 24 separate Excel documents. What do you do? This is where Power Query comes to the rescue.
Read the pieceIf too much reliance is put on volatile functions, it can make recalculation times slow in Excel alone - when you couple that with Jet reporting it can compound the issue further.
Read the pieceContinuing my learning journey of Python (and tools) in data analysis, there was a data set for the 2022 Commonwealth Games. I thought that since I had just done some EDA on the Olympics, it would be good to look at this data set.
Read the pieceSome reports can run in a matter of seconds, but if it is not built following ‘best practice’ guidelines, over time it can grow into an unoptimised mess that takes MUCH longer to run. This article will explore some of the most impactful ways to streamline a Jet report.
Read the pieceContinuing my learning journey of Python (and tools) in data analysis, I found a good dataset on Kaggle that has Olympics medals data of each participating country since 1896.
Read the pieceAs a huge Formula 1 fan, I was very happy to find a dataset on Kaggle that has lots of stats for seasons from 1950 to 2021. I decided to try an encorporate some SQL into this project too.
Read the pieceTopic: Visualize Your Progress and Stay the Course with a Habit Tracker * When it comes to building better habits, a crucial step is to visualize the
Read the pieceLife Management Flows The reason for this page is to help me get a better picture of how I manage information in my life. I seem
Read the pieceLobsters (more broadly, Trilobites) have been on earth for nearly 270 million years which predates dinosaurs. Given that lobsters and humans are worlds apart, there doesn&
Read the piece
