Category: Data AnalysisPage 3 of 3

Beginner-friendly posts on relational database basics, ad hoc analysis, and reporting.

Speed up SQL queries with indexes

Your query is running slow, have you checked your indexes?

SQL Joins without the Venn diagrams

Joining tables is the first big learning curve after getting your head around SQL basics.

Why I use SQL CTEs

CTEs are underrated compared to the subquery. Here’s why I prefer to use CTEs when building SQL queries.


VLOOKUP lets Excel do the hard work of matching up a value from one spreadsheet to another. It saves time and is an essential Excel tool.

How to customise SQL Server Management Studio (SSMS)

SSMS is highly customisable, here’s 10 ways to make it work best for you.

Relational database fundamentals

When working with data in relational databases there are some key concepts to understand