Peter Nicholson - Peter Nicholson (Page 4)

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.

21 Nov 2022 · 2 min read

The MILES Framework (The Unfair Advantage)

The MILES framework helps you identify how you can help position yourself to position yourself to take advantage of luck.

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.

8 Nov 2022 · 9 min read

How To Talk

I had thought it was pretty obvious how to speak, we all do it every day of our lives so what is there to learn? I hope that in the 10 minutes it takes you to read this, you will learn things about speaking that you don't know now, and will make a difference in your life.

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.

7 Nov 2022 · 6 min read

Jet Reports 101 - Scheduling Reports with Jet Scheduler

It’s safe to say that any opportunity to automate a report is an opportunity I always pounce on. The Jet Scheduler is a powerful tool that allows you to schedule reports to be automatically run by the Windows Task Scheduler.

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!

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