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
Read the pieceTopic
data-analysis
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.
Read the piece
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.
Read the piece
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.
Read the piece
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.
Read the piece
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.
Read the piece
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.
Read the piece
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?
Read the piece
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.
Read the piece