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
- Build a pivot table that summarises sales by region and month
- Use XLOOKUP or VLOOKUP to combine two sheets on a key
- Write a SQL query joining orders to customers and grouping by city
- Filter aggregated results with HAVING rather than WHERE
- Spot duplicates and nulls that would distort a report
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.
Other units in this stage
Back to the full BI Analyst roadmap