Data Analysis Technology Bootcamp: Power BI
True or False: When using a slicer, only one selection can be made within the slicer
False
True or False: You can run Power BI desktop on a mac Operating System.
False
True or False: You can only display data in a table tat is the data model in Power BI
True
Which of the following is an example of a one-to-one relationship?
an employee can be assigned to only one office, and an office can only have one employee
Which of the following is an example of a one-to-many relationship?
an employee can only have one ID, but the employee ID might be associated with many sales
Which of the following is a source from which you can import data into Power BI
Excel Access text files web
True or False: A matrix is a less flexible visual compared to a table
False
True or False: Calculated columns and measures are essentially the same thing in Power BI
False
True or False: Formatting for visualizations is done under the Fields Pane in Power BI
False
True or False: In Power BI, once data is imported, additional columns cannot be added to tables
False
True or False: In Power Bi, once data is imported, additional tables cannot be added to the model
False
True or False: It is not possible to edit thickness of the line in a line chart in Power BI
False
True or False: Microsoft Power BI Desktop requires a sign in via e-mail when you open to the program
False
True or False: Microsoft Power BI is seldomly updated by Microsoft
False
True or False: Once a measure is created in Power BI, it cannot be deleted
False
True or False: Once a relationship is created in Power BI, it cannot be edited or deleted
False
True or False: Tables are the equivalent of pivot tables in Excel
False
True or False: A single slicer can filter three visuals on one tab
True
True or False: Data can be transformed prior to loading into Power Bi in a prgram called Power Query
True
True or False: Matrices in Power BI are somewhat comparable to pivot tables in Excel
True
True or False: Microsoft Power BI Desktop is the free version that anyone can download without signing in
True
True or False: The background color of the Power BI canvas can be changed to a color of your choice
True
True or False: The data that was loaded for Raider Industries has five total tables
True
True or False: The user has the flexibility to name a calculated column however they see fit
True
True or False: The user has the flexibility to name a measure however they see fit
True
True or False: To create a calculated column, the user only enters the formula once and Power BI applies that formula to all rows to create a new column of information
True
True or False: When formatting a slicer, you can add a SELECT ALL option
True
True or False: You can format a slicer to contain a drop-down menu
True
True or False: You can have multiple slicers interacting with one visual
True
Which of the following best describes a slicer's function
it is used to filter the data that appears on the visuals in Power BI
What is true about a calculated column?
the data that results from a calculated column appears in a table within the data view of Power BI a calculated column is a "vertical" calculation a calculated column is a "horizontal" calculation
The RELATED function in Power BI allows you to
use fields from one table in a formula in a different table
which of the following fields does a matrix contain that a table does not?
values rows
Adding a border around a visual is done under which tab in the "Format your Visual" area?
General
Which of the following is a type of chart available in Power BI?
Line Chart Stacked Bar Chart Pie Chart Clustered Column Chart
Which of the following are "views" within Power BI
Table View Model View Report View
Which of the following is TRUE about a measure in Power BI
a measure is created by the user a measure is a "vertical" calculation measures can be used in the calculation of other measures the calculation of a measure is dynamic in that it adjusts to your filter (ex. slicer) selections
Which of the following is an example of a many-to-many relationship?
a student can register for several classes, and a single class may contain several students
Which of the following are relationship types found in Power BI?
one-to-one many-to-many one-to-many
