BI Foundations

Plain-English guides to the core ideas behind business intelligence.

Start here if you want clear explanations of the terms, tools and concepts that come up again and again in BI, analytics, dashboards and reporting.

Recommended path

Want to go from concepts to practical BI skills?

The BI Analyst Starter Program gives you a structured route through SQL, dashboards, data modelling, real projects and portfolio building.

Explore the BI Analyst Starter Program →

Foundation guide

What is SQL

SQL (Structured Query Language) is the language used to query, retrieve, and manipulate data stored in databases and data...

Read guide →

Foundation guide

What is a Data Pipeline

A data pipeline is the system that automatically moves, updates, and processes data from source systems into a data warehouse so it can be monitored and...

Read guide →

Foundation guide

What is ETL

ETL (Extract, Transform, Load) is the process of taking data from different sources, cleaning and organising it, and loading it into a data warehouse so it can be...

Read guide →