Preparing Data for BI Analysts
Preparing data is the step of extracting data from sources, cleaning it and reshaping it so it can be loaded into a model. In BI this is done with ETL pipelines or with Power Query, which records each transformation step. Clean inputs matter because a dashboard cannot be more accurate than its data.
Stage: Data Modelling · Part of the BI Analyst roadmap · Last reviewed 19 November 2026
What to learn in Preparing Data
- Connect Power Query to a CSV file and an SQL table
- Remove duplicates, fix data types and trim whitespace in applied steps
- Unpivot a wide spreadsheet into a tidy table of rows
- Merge and append queries to combine data from several sources
- Explain the difference between ETL and ELT
Preparing Data interview questions
How does ETL versus ELT affect the data an analyst can query?
In ETL, data is transformed before it is loaded into the target. In ELT, raw data is loaded first and transformed inside the warehouse using its own compute. ELT is common with cloud warehouses because storage is cheap and transformations can be rerun. ELT keeps raw data available to analysts.
Why unpivot data before building a report?
Wide layouts with one column per month are hard to filter, chart and aggregate. Unpivoting turns them into rows with a month column and a value column, which is the tidy shape BI tools expect for slicing by time.
Where Preparing Data fits in the BI Analyst roadmap
Preparing Data belongs to the Data Modelling stage (beginner level). Make reports fast and right.
Other units in this stage
Back to the full BI Analyst roadmap