General
Created between two or more tables based on the cardinality between them.
Relationships (Data Modeling)
The tool used to shape, clean and transform data in Power BI.
Power Query
Which visualizations' 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
If you want to represent one number, you better use this visual
Card
Which of the following extensions we have loaded to Bower Bi?
A. .DOCX
B. .XLS
C. .CSV
D. .PNG
B and C
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 want to put two columns into one sigle column, what operation do you perform?
Merge
The steps section of the query settings pane.
Applied Steps of every transformation.
Which Visual is commonly used to compare different categories?
Stacked bar/column chart
Many banana trees planted in a garden represents which type of relationship?
Many to one