There is a matrix using a standard date hierarchy. It is currently showing a range of years.
How do you display just a specific year and that year's quarters? - ANSWER Select 'Drill
Down', and then the preferred data point, which will drill down into the specific year and its
quarters.
What pane allows the user to set the order that visuals move between after pressing Tab? -
ANSWER Selection pane. It provides a list of all objects on the current page and allows
the user to group and hide visuals as well as change the layer and tab order.
What Power Query feature removes spaces from the beginning and the end of any string in a
column? - ANSWER Trim (Under Transform > Format). This removes leading and trailing
spaces from a string
What are two ways to add a custom visual from the online Microsoft Store to a Power BI re-
port? - ANSWER Go to the Home tab, select More Visuals, and select "From AppSource"
or go the Insert tab, select the dropdown containing all of the visuals, and select "Get more
Visuals"
There is a dataset of Employee Data which includes the 'Department' and 'Salary' fields. To
understand whether Department has an influence on Salary, what two actions need to be
taken? There is a Key Influencers visual. - ANSWER Drag Salary into the 'Analyze' section
and Department into the 'Explain By' section. The field in the Analyze section is the numeri-
cal field that you are wanting to have explained. The field(s) in the "Explain by" are the fields
you want to see have an influence.
What AI visual allows users to analyze data by drilling down into various fields? - AN-
SWER Decomposition Tree. The measure that is to be broken down is placed into the An-
alyze section, and then how it is to be broken down is placed in the Explain By section. This
1
,allows users to drill-down into different related fields in their data model and learn how they
all influence each other.
When filtering a visual to values containing certain text, what wildcard represents zero to
many characters? For example, I want to show all values starting with 'St' that include an-
other 'T' - ANSWER Asterisks (Example: St*t*)
What does Column Distribution in the Power Query editor show? - ANSWER Unique and
Distinct values
How are changes to an original column reflected in Duplicated and Referenced columns, re-
spectively? - ANSWER Duplicating a query means that the query as it currently is will be
copied into another query. Subsequent changes to the original query will not affect a dupli-
cated query.
Referencing a query means that there is a link to the original query. Subsequent changes to
the original query will affect a referenced query
Is a Power BI Pro license needed to use Sync Slicers? - ANSWER No, it is not
What needs to be entered into the 'Starting Index' and 'Number of Characters' fields in the
Extract Text Range feature of the Power Query Editor to extract the 3rd character from a
field, and why? - ANSWER Starting Index = 2, Number of Characters = 1 (Note STARTING
INDEX = STARTING FROM)
The M language is zero-based. This means that the first character is Index 0. Therefore, the
third character is Index 2.
The Number of characters is how many characters you want to return, not the final index.
What happens when the data type of a column that contains text and numbers is changed to
Decimal Number? - ANSWER Any text (non-numerical) data returns an Error
2
,There is a dataset which includes a Date field, and "Total Pay" and "Department" fields.
There has been a visual which uses anomaly detection created.
Which type of visual is being used, and what fields could be used in that visual? - AN-
SWER A line chart, with a date field in the X-axis, Total Pay in the Y-axis (the Legend sec-
tion is empty).
Anomaly detection cannot be used on charts with legends or a stacked column
What storage mode would help reduce a delay in visuals being affected by slicers when the
data used is from a SQL server? - ANSWER Import storage mode, since the visuals
changed are based on data already loaded from the cache imported
What feature allows you to combine the rows of one query into another? - ANSWER Ap-
pend Queries
What are all of the ways that you can see empty values in a column in Power Query Editor? -
ANSWER View - Column Profile and View - Column Quantity
What does Column Quality in Power Query Editor display? - ANSWER Displays valid, er-
ror, and empty values
What does Column Profile in Power Query Editor display? - ANSWER Displays Count, Er-
ror, Empty, Distinct, Unique, NaN, Zero, Min, Max, Average, and Standard Deviation
What does Column Distribution in Power Query Editor display? - ANSWER Displays Dis-
tinct and Unique values (not null or empty)
What is an advantage or using a 100% Stacked Bar Chart over a Pie Chart for displaying pro-
portions? - ANSWER A 100% Stacked Bar Chart can display proportions within different
dimensions (Think Seniority proportions with different departments)
3
, What is a Group in Power BI? - ANSWER Grouping allows two or more elements on a vis-
ual to be viewed and analyzed together. Grouping elements on a visual together adds them
to the Fields list
What is Binning in Power BI? - ANSWER Binning splits numeric or date/time data from
Calculated Columns into equally sized groups
What feature allows the user to change what happens to other visuals when one visual is se-
lected in a Report? - ANSWER Edit Interactions
What Format Style is used to allow the color of one column to be stated in another? - AN-
SWER Field Value
What change has to be made to a page to add it as a Tooltip? - ANSWER Change the Page
type to Tooltip in the Format Pane
Where can Auto Date/Time for new files be turned off? - ANSWER File - Options and Set-
tings - Options
What feature displays what filters on what fields in a dataset would produce a differently
shaped bar chart? - ANSWER Right-clicking on the chart and selecting Analyze and then
selecting 'Find where the distribution is different". A Key Influencers visual would show what
filters on a field affect a particular measure, but not the shape of a chart.
How can the default aggregation of a field be changed from Sum to Max? - ANSWER Se-
lecting the field and then selecting the Summarization drop-down in the Column Tools rib-
bon
What feature saves the currently displayed page and the selected filters? - ANSWER
Bookmarks
4
How do you display just a specific year and that year's quarters? - ANSWER Select 'Drill
Down', and then the preferred data point, which will drill down into the specific year and its
quarters.
What pane allows the user to set the order that visuals move between after pressing Tab? -
ANSWER Selection pane. It provides a list of all objects on the current page and allows
the user to group and hide visuals as well as change the layer and tab order.
What Power Query feature removes spaces from the beginning and the end of any string in a
column? - ANSWER Trim (Under Transform > Format). This removes leading and trailing
spaces from a string
What are two ways to add a custom visual from the online Microsoft Store to a Power BI re-
port? - ANSWER Go to the Home tab, select More Visuals, and select "From AppSource"
or go the Insert tab, select the dropdown containing all of the visuals, and select "Get more
Visuals"
There is a dataset of Employee Data which includes the 'Department' and 'Salary' fields. To
understand whether Department has an influence on Salary, what two actions need to be
taken? There is a Key Influencers visual. - ANSWER Drag Salary into the 'Analyze' section
and Department into the 'Explain By' section. The field in the Analyze section is the numeri-
cal field that you are wanting to have explained. The field(s) in the "Explain by" are the fields
you want to see have an influence.
What AI visual allows users to analyze data by drilling down into various fields? - AN-
SWER Decomposition Tree. The measure that is to be broken down is placed into the An-
alyze section, and then how it is to be broken down is placed in the Explain By section. This
1
,allows users to drill-down into different related fields in their data model and learn how they
all influence each other.
When filtering a visual to values containing certain text, what wildcard represents zero to
many characters? For example, I want to show all values starting with 'St' that include an-
other 'T' - ANSWER Asterisks (Example: St*t*)
What does Column Distribution in the Power Query editor show? - ANSWER Unique and
Distinct values
How are changes to an original column reflected in Duplicated and Referenced columns, re-
spectively? - ANSWER Duplicating a query means that the query as it currently is will be
copied into another query. Subsequent changes to the original query will not affect a dupli-
cated query.
Referencing a query means that there is a link to the original query. Subsequent changes to
the original query will affect a referenced query
Is a Power BI Pro license needed to use Sync Slicers? - ANSWER No, it is not
What needs to be entered into the 'Starting Index' and 'Number of Characters' fields in the
Extract Text Range feature of the Power Query Editor to extract the 3rd character from a
field, and why? - ANSWER Starting Index = 2, Number of Characters = 1 (Note STARTING
INDEX = STARTING FROM)
The M language is zero-based. This means that the first character is Index 0. Therefore, the
third character is Index 2.
The Number of characters is how many characters you want to return, not the final index.
What happens when the data type of a column that contains text and numbers is changed to
Decimal Number? - ANSWER Any text (non-numerical) data returns an Error
2
,There is a dataset which includes a Date field, and "Total Pay" and "Department" fields.
There has been a visual which uses anomaly detection created.
Which type of visual is being used, and what fields could be used in that visual? - AN-
SWER A line chart, with a date field in the X-axis, Total Pay in the Y-axis (the Legend sec-
tion is empty).
Anomaly detection cannot be used on charts with legends or a stacked column
What storage mode would help reduce a delay in visuals being affected by slicers when the
data used is from a SQL server? - ANSWER Import storage mode, since the visuals
changed are based on data already loaded from the cache imported
What feature allows you to combine the rows of one query into another? - ANSWER Ap-
pend Queries
What are all of the ways that you can see empty values in a column in Power Query Editor? -
ANSWER View - Column Profile and View - Column Quantity
What does Column Quality in Power Query Editor display? - ANSWER Displays valid, er-
ror, and empty values
What does Column Profile in Power Query Editor display? - ANSWER Displays Count, Er-
ror, Empty, Distinct, Unique, NaN, Zero, Min, Max, Average, and Standard Deviation
What does Column Distribution in Power Query Editor display? - ANSWER Displays Dis-
tinct and Unique values (not null or empty)
What is an advantage or using a 100% Stacked Bar Chart over a Pie Chart for displaying pro-
portions? - ANSWER A 100% Stacked Bar Chart can display proportions within different
dimensions (Think Seniority proportions with different departments)
3
, What is a Group in Power BI? - ANSWER Grouping allows two or more elements on a vis-
ual to be viewed and analyzed together. Grouping elements on a visual together adds them
to the Fields list
What is Binning in Power BI? - ANSWER Binning splits numeric or date/time data from
Calculated Columns into equally sized groups
What feature allows the user to change what happens to other visuals when one visual is se-
lected in a Report? - ANSWER Edit Interactions
What Format Style is used to allow the color of one column to be stated in another? - AN-
SWER Field Value
What change has to be made to a page to add it as a Tooltip? - ANSWER Change the Page
type to Tooltip in the Format Pane
Where can Auto Date/Time for new files be turned off? - ANSWER File - Options and Set-
tings - Options
What feature displays what filters on what fields in a dataset would produce a differently
shaped bar chart? - ANSWER Right-clicking on the chart and selecting Analyze and then
selecting 'Find where the distribution is different". A Key Influencers visual would show what
filters on a field affect a particular measure, but not the shape of a chart.
How can the default aggregation of a field be changed from Sum to Max? - ANSWER Se-
lecting the field and then selecting the Summarization drop-down in the Column Tools rib-
bon
What feature saves the currently displayed page and the selected filters? - ANSWER
Bookmarks
4
