stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Power Bi Workshop Flashcards | StudBud
Explore
/
Power Bi Workshop
Power Bi Workshop
20 terms
·
StudBud Administration
·
22 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
Power BI is treating your
Sales Amount column
as text, so you can't perform calculations. What should you do?
Create a DAX Measure
Split Column by Delimiter
Sort the column
Change Data Type to Decimal/Number
2
What does a slicer do in Power BI?
Refreshes data
Deletes columns
Filters data in reports
Adds new visuals
3
Relationships in Power BI are created between columns in different tables.
True
False
4
you have a Date column and want to extract just the year. Which transformation would you use in Power Query?
Replace Values
Merge Queries
Add Column > Year
Format Column
5
What does a card visual in Power BI display?
A single value
A list of tables
Data relationships
Multiple charts
6
You want to change column name ‘SalesAmt’ to ‘Sales’. What do you do?
Rename Column
Format Column
Group By
Split Column
7
Which view allows you to create relationships between tables in Power BI Desktop?
Data View
Report View
Model View
Query View
8
What type of value does the DAX function SUM() return?
Column
number
Table
Boolean
9
You imported a table where column headers are in the first row. What transformation should you use to correct this?
Transpose
Promote Headers
Merge Queries
Use First Row as Headers
10
What is a relationship in Power BI data modeling?
A file extension
A visual element
A filter type
A way to link two tables based on common columns
11
What is Power BI primarily used for?
Operating systems management
Web development
Data analysis and visualization
Word processing
12
What visual would be most appropriate to show trends over time?
Line chart
Pie chart
Matrix
Card
13
Customer Column
has extra spaces. Which transformation removes them?
Clean
Group By
Replace Values
Trim
14
What does DAX stand for?
Data Aggregation Expressions
Data Analysis Expressions
Data Access Expressions
Data Analytics Expressions
15
A step in Power Query can be deleted anytime.
False
True
16
Which language is used in Power BI for data modeling and calculations?
SQL
DAX
R
Python
17
You can only have one relationship between two tables.
True
False
18
You can change a column’s data type in Power Query.
False
True
19
What happens when you click on a visual in Power BI report?
It runs a DAX function
It filters other visuals by default
Nothing
It disappears
20
Which tool in Power BI is used to clean and shape data before loading it into the model?
Data View
Report View
DAX Editor
Power Query Editor
