General
Created between two or more tables based on the cardinality between them.
Relationships (Data Modeling)
The ETL tool used to shape, clean and transform data in Power BI.
Power Query
Which visualizations sole purpose is to filter data?
Slicer
What file extension is used for Power BI Desktop files?
Power BI Desktop files use the (.pbix) extension.
The different views in Power BI Desktop
Report View: Users can add visualizations and additional report pages and publish the same on the portal from here.
Data View: Data shaping can be performed through Query Editor tools.
Model View: Users can manage relationships between datasets in this view.
Used for aggregational calculations such as sum, average, minimum value, maximum value, counts, etc.
Measures
Where can you add, change, or customize graphics in Power BI?
Visualizations Pane
The BI in Power BI is an acronym representing these two words.
Business Intelligence
Upon signing in to the Power BI web service, which of the following do you download?
A. Power BI App
B. Power BI Desktop
C. Data Gateway
D. Power BI for Excel
B. Power BI Desktop
Changing data types, filtering rows, choose/remove columns, splitting a column into multiple columns, adding new columns ,etc. are examples of what?
Power Query/Editor Data Transformations
The recommended number of visuals for a Power BI report is?
eight visuals per page
Which of the following is not a Power BI data type?
A. Fixed decimal number
B. String
C. Whole number
D. Text
B. String
What does DAX stand for?
Data Analysis Expressions
A calculating expression which allows calculation on data stored in a new column. (a type of column)
Calculated Column
Which of the following is NOT a type of data visualization that can be created in Power BI?
A. Pie Chart
B. Scatter Plot
C. Column Chart
D. JavaScript code
D. JavaScript code
What is the Query Editor used for?
A. To shape & transform data, then load it into Power BI
B. To create relationships between data and lookup tables
C. To create measures & calculated columns using DAX
D. To design websites
A. To shape & transform data, then load it into Power BI
If you have two queries that have different data but the same columns, data types and headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?
Append
The steps section of the query settings pane.
Applied Steps of every transformation.
Which Visual is commonly used to show trends?
Line Chart
Many banana trees planted in a garden represents which type of relationship?
Many to one