NEW
Font size
WorksheetsETL and Power BI Quiz
Total questions: 20
Worksheet time: 10mins
What does ETL stand for?
Extract, Transfer, Link
Evaluate, Transform, Load
Extract, Transform, Load
Export, Transfer, Link
Which ETL phase involves importing data from Excel or SQL Server?
Transformation
Loading
Cleansing
Extraction
Which activity is part of the Transformation process?
Connecting to Excel file
Creating charts
Removing duplicates
Saving report
Data cleansing is mainly performed during which ETL stage?
Extraction
Transformation
Loading
Visualization
Which of the following is NOT an example of data cleansing?
Removing null values
Correcting spelling errors
Standardizing date formats
Creating dashboards
What tool in Power BI is used to clean and transform data?
Power View
Power Pivot
Power Query Editor
Power Map
Which Power BI menu is used to connect data from Excel?
View > Excel
Home > Get Data > Excel
Transform > Excel
Insert > Excel
Which data source was used in the DFP40433 Syllabus?
SQL Server
CSV File
Web API
Excel File
Which Power Query transformation ensures values are treated correctly?
Rename Column
Remove Rows
Change Data Type
Split Column
What happens if the data type is incorrect?
Report loads faster
Visualizations become more accurate
Errors may occur in calculations
Power BI automatically fixes it
Which option removes empty or unnecessary records?
Replace Values
Remove Rows
Merge Queries
Add Column
Which transformation is used to separate values within one column?
Split Column
Add Column
Pivot Column
Filter Rows
Which feature lists all applied transformation steps?
Navigation Pane
Ribbon
Applied Steps Panel
Status Bar
Which panel shows the list of tables in Power Query Editor?
Applied Steps Panel
Navigation Pane
Ribbon
Formula Bar
Which menu contains options like Home, Transform, Add Column?
Navigation Pane
Data View
Ribbon
Report Canvas
What does the Load stage do in ETL?
Clean data
Convert data types
Load data into Power BI model
Remove duplicates
Which button applies transformations and loads data into the model?
Refresh
Get Data
Close & Apply
Save
Why is data cleaning important before analysis?
To reduce file size
To make dashboards colorful
To ensure accurate reporting
To speed up internet connection
Which of the following is an example of combine two or more queries?
Rename “Date” to “OrderDate”
Year = Date.Year([Date])
Remove blank rows
Merge two tables
Which statement BEST describes Power Query Editor?
A visualization tool
A programming language
A tool to import, clean, and transform data
A database server
