Peter Nicholson (Page 3)

12 Dec 2022 · 5 min read

Top 5 Good Practices when using SQL

Are you tired of dealing with messy, slow, and error-prone SQL queries? In this blog post, we will reveal the top five good practices that can help you avoid common pitfalls and write clean, efficient, and secure SQL code.

12 Dec 2022 · 2 min read

4 disadvantages to using the horrible pie chart

11 Dec 2022 · 4 min read

How To Implement A Data Warehouse

If you're a business owner or IT professional looking to implement a data warehouse from scratch, you're probably wondering where to begin. In this post, we'll outline the key steps you'll need to take in order to successfully implement a data warehouse from scratch.

10 Dec 2022 · 2 min read

Basic Data Extraction Using SQL

In SQL, data extraction is the process of retrieving specific data from a database. This is typically done using SQL SELECT statements, which allow you to specify the columns and rows that you want to retrieve from the database.

8 Dec 2022 · 3 min read

Using Power BI for your business

Using Power BI for a small business can help the company gain a better understanding of its data, customers, and market, and make more informed decisions.

8 Dec 2022 · 2 min read

What role does candor play in leadership?

Candor, or the quality of being open and honest, is an important trait for any leader to possess. Here are five reasons why candor is important in leadership.

7 Dec 2022 · 2 min read

Excel vs. Power BI - which one you should use

Both are powerful tools for analysing and presenting data. However, they have different strengths and capabilities, and choosing the right tool for your needs can be a challenging decision. Let's compare Excel and Power BI to help you decide which one is right for you.

3 Dec 2022 · 2 min read

Better Communication - The GPS Method

In his book "The First Minute", James Fenning has created what he calls the "GPS" method which is an easy to remember structure for creating a clear summary of a problem or idea.

2 Dec 2022 · 2 min read

Improve Your Alt Text For Graphs

Alt text (alternative text) is a description that is added to a graphical image to support and describe what the visual represents.

2 Dec 2022 · 2 min read

5 Reasons To Move Your ERP To The Cloud

With a huge increase in the number of people working from home, companies have been scrambling to set people up to enable remote access to their systems. It is more important than ever for business to consider moving their systems to the cloud. Let's explore 5 good reasons for doing so.

29 Nov 2022 · 3 min read

The Miles Framework - How you can find your "Unfair Advantages"

After having read The Unfair Advantage by Ash Ali & Hasan Kubba, I thought about their framework they explained, the 'MILES framework'. There are 5 categories of unfair advantages, which makes up the MILES framework.

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!