EDA 27 Nov 2022 · 7 min read EDA of Horror Films (1950 - Present) Continuing on my journey through Python and given that we've just had Hallowe'en, I thought it'd be a good idea to find an appropriate dataset. Read more
jetreports 10 Nov 2022 · 4 min read Jet Reports 101 - Creating User Defined Options Report options are a powerful way of adding customisability to your reports that means you don’t have to have a designer to put a report into design mode to change a parameter or filter. So let’s see how we create them. Read more
Power BI 8 Nov 2022 · 3 min read Power BI: DAX - Calculated Measures & Columns Choosing between calculated columns and calculated measures. They may look similar, but there’s a big difference between calculated columns and measures. Let’s see what they’re about. Read more
EDA 5 Nov 2022 · 4 min read Exploratory Data Analysis of Kent County Council Library Use (My First Python EDA!) Although this is my latest post about my journey with Python, this is one of the first python data analysis projects I did back in January 2022. With this is mind, there's probably lots of inefficiencies in my code python so be gentle! Read more
data-analysis 22 Oct 2022 · 4 min read Exploratory Data Analysis (EDA) of the 2022 Commonwealth Games Continuing 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 more
data-analysis 10 Oct 2022 · 4 min read Jet Reports 101 - Improving Performance Some 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 more
data-analysis 3 Oct 2022 · 6 min read EDA of Olympic Medals Continuing 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 more
data-analysis 30 Sep 2022 · 5 min read Analysis of Formula 1 data As 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 more
data-analysis 15 Jan 2022 · 4 min read Libraries within Kent County Council - Data Analysis Importing Tools: import pandas as pd import numpy as np import matplotlib.pyplot as plt %matplotlib inline import matplotlib.patches as mpatches from matplotlib.pyplot import figure Reading in the Read more