Skip to main content

Data Basics for BI Analysts

Data basics for BI means the spreadsheet and SQL skills used to inspect and summarise data before any dashboard is built. It includes lookup formulas and pivot tables in Excel, and SELECT queries with joins, filters and GROUP BY in SQL. Most BI work begins with these two tools.

Stage: BI Foundations · Part of the BI Analyst roadmap · Last reviewed 19 November 2026

What to learn in Data Basics

Data Basics interview questions

What is the difference between WHERE and HAVING in SQL?

WHERE filters individual rows before grouping happens, while HAVING filters groups after aggregation. For example, WHERE removes cancelled orders first, then HAVING keeps only customers whose summed order value exceeds a limit. Aggregate functions can appear in HAVING but not in WHERE.

What does an INNER JOIN return compared with a LEFT JOIN?

An INNER JOIN returns only rows with a match in both tables. A LEFT JOIN returns every row from the left table and fills columns from the right table with NULL where no match exists. LEFT JOIN is used to find customers with no orders.

Where Data Basics fits in the BI Analyst roadmap

Data Basics belongs to the BI Foundations stage (beginner level), which takes about 5 hours. The business of metrics.

Back to the full BI Analyst roadmap