Peter Nicholson (Page 4)

3 Nov 2022 · 4 min read

Jet Reports 101 - Row 1 & Column A… what CAN you use it for?

We see tutorials and instructions state that Jet Reports uses Column A and Row 1. But what can we use this row and column for? Let's find out!

31 Oct 2022 · 3 min read

Jet Reports 101 - NL(Filter) vs. LINK=

When writing reports, you may find that you need to filter your data based on information stored in a separate table. Let's take a look at how to do this in Jet Reports.

29 Oct 2022 · 5 min read

Excel 101 - Combine Multiple Files From Folders Using Power Query

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.

25 Oct 2022 · 2 min read

Jet Reports 101 - Evaluating Formulas NP(Eval)

If 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.

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.

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.

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.

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.

30 Aug 2022 · 8 min read

Build Better Habits - The James Clear Way

Topic: 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 progress you’re making,

30 Aug 2022 · 5 min read

Types of information storage for a ‘second brain’

Life 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 to have apps galore

Communication

18 Apr 2022 · 3 min read

Can we learn from lobsters? Jordan Peterson thinks so.

Lobsters (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't seem to

11 Apr 2022 · 5 min read

You own all of your time

Every single person on the planet has 24 hours a day. It's the one constant, the level playing field of life and yet it doesn't always

6 Apr 2022 · 1 min read

How to update Ghost on DigitalOcean

If you're self hosting Ghost on DigitalOcean, then you'll find yourself needing to update it at some point. Below are the simple steps that I take

25 Mar 2022 · 4 min read

Atomic Habits - Book Review

Atomic HabitsNo matter your goals, Atomic Habits offers a proven framework for improving--every day. James Clear, one of the world’s leading experts o...GoodreadsJames Clear Publisher Description: No matter

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

3 Jan 2022 · 4 min read

My Top 5 Books 2021

I'm trying to read more and this year I read 21 books - a new record! I enjoyed most of them, but the following 5 books are the ones that stood out for me.

28 Dec 2021 · 7 min read

Budget With Buckets

YNAB announced a sudden price increase - what alternatives are there? Buckets is the one that I have moved to and it ticks most of the boxes.

13 Nov 2021 · 4 min read

Sorry YNAB, I'm moving on

I found YNAB back in June 2020 and it completely changed my financial health for the better. So why am I leaving it?