data-analysis - Peter Nicholson

25 Feb 2024 · 2 min read

Good Data Visualisation - Who Are IBCS?

We know that data and business intelligence is a company's "gold", but the presentation of data in visualisations is not something that is explicitly taught to

Business

5 Nov 2023 · 2 min read

Medallion Architecture: Unmasking the Illusion of Perfection

In the digital world where data is often the lifeblood of decision-making, Medallion Architecture has emerged as a kind of 'knight in shining armour', ready to rescue organisations from the clutches of data disarray. But, not all that glitters is gold.

1 Nov 2023 · 3 min read

Using a pie chart? Boooo!

Pie charts are one of the most widely recognised and frequently used chart types in data visualisation. Despite their popularity, many experts have criticised the use of pie charts, arguing that they are ineffective in communicating information.

21 Mar 2023 · 5 min read

An Introduction to DAX

Behind the scenes of Power BI lies a language called Data Analysis Expressions (DAX), which is used to manipulate data within the application. In this blog post, we’ll take a deep dive into DAX and explore how it can help you make better business decisions.

8 Mar 2023 · 3 min read

Dividing Customers into Four Quartiles Based on Total Revenue Using SQL and AdventureWorksDW2019

Analysing customer revenue is a critical aspect of understanding the performance of any business. In this blog post, we will explore how to use SQL and the AdventureWorksDW2019 database to group customers into four quartiles based on their total revenue.

4 Mar 2023 · 2 min read

Mastering Window Functions: How to Calculate a Moving Average in SQL

Learn how to analyse sales trends with a moving average calculation in SQL. This powerful tool can help you identify growth opportunities and improve business performance.

30 Jan 2023 · 4 min read

Exploratory Data Analysis (EDA) of UK Museums

It's been a while since I last posted a small EDA article in my learning journey of Python so I've dusted off VS Code and found a dataset on UK Museums.

4 Jan 2023 · 2 min read

Report or Dashboard?

As a data analyst, you know the value of presenting your findings in a clear and effective way. But when it comes to choosing between a report and a dashboard, which one is the right fit for your needs?

28 Dec 2022 · 2 min read

Best Practices For Visualising Data

In this post, we'll delve into these best practices and provide tips on how to create visualisations that are both informative and easy to interpret.

23 Dec 2022 · 2 min read

How to get started with Python for data analysis

Python is a powerful and versatile programming language that is widely used in a variety of industries, including data science, web development, and finance. If you are interested in learning Python, there are a number of tools and resources available to help you get started.

21 Dec 2022 · 2 min read

The advantages of implementing a Data Warehouse

A data warehouse is a critical tool for any business that wants to make data-driven decisions. Read about why a data warehouse should be in your business.

19 Dec 2022 · 1 min read

My Top 10 Python Libraries For Data Analysis

The 10 most important Python libraries to use for exploratory data analysis (EDA).

12 Dec 2022 · 4 min read

How Tasks Are Needed To Run A Data Warehouse?

The day-to-day tasks involved in managing a data warehouse can vary depending on the specific needs and requirements of the organisation.

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.

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.

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.