PL-300: Microsoft Power BI Data Analyst
The Q&A visual lets you explore data "in your own words" using what?
DAX
M Code
Natural language queries
SQL
Answer is Natural language queries
Which of the following filter options applies only to the specific visual in which it is defined?
Visual level
Page level
Report level
Drill through
Answer is Visual level
Visual level filters apply only to the specific visual in which they are defined.
Which filter setting would you use if you wanted to return the top 3 categories by total profit?
Basic
Advanced
Top N
Dynamic
Answer is Top N
Top N options allow you to filter the top "n" amount of items by a specified value or measure.
What object could you add to a dashboard if the user would like an interactive way to sort and filter the data using dates?
Categorical Slicer
Date Slicer
Top N Filter
Report Level Filter
Answer is Date Slicer
Slicers provide an interactive way for users to sort and filter a report, and date slicers are exclusively for date fields.
What visual could you use if you wanted to understand the factors that drive a specific metric?
Decomposition Tree
Line Chart
Key Influencers
Treemap
Answer is Key Influencers
The key influencers visual helps you understand the factors that drive a specific metric.
Which visual allows you to break down a measure across multiple dimensions?
Decomposition Tree
Line Chart
Key Influencers
Treemap
Answer is Decomposition Tree
The decomposition tree visual allows you to perform exploratory analysis by successively breaking down a measure across multiple dimensions.
Which of the following filter options applies to all visuals across all pages of the report?
Visual level
Page level
Report level
Drill through
Answer is Report level
Report level filters apply to all visuals across all pages of the report.
You have a workspace that contains 10 dashboards. A dashboard named Sales Data displays data from two datasets. You discover that users are unable to find data on the dashboard by using natural language queries.
You need to ensure that the users can find data by using natural language queries.
What should you do?
From the settings of the workspace, modify the Language Settings.
From the Sales Data dashboard, set the dashboard as a Favorite.
From the properties of the datasets, modify the Q&A and Cortana settings.
From the properties of the dashboard, modify the Q&A settings.
Answer is From the properties of the datasets, modify the Q&A and Cortana settings.
You can modify the setting for Dataset property for sure. Not from Dashboard property.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-q-and-a-direct-query#limitations-during-public-preview
You are creating a report in Power BI Desktop.
You are consuming the following tables.
Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format.
You create the report shown in the exhibit.
You need to ensure that the months appear in the order of the calendar.
How should you sort the MonthName column?
by MonthNumber
ascending
descending
by DateKey
Answer is by MonthNumber
References:
http://ppmworks.com/sorting-month-names-chronologically-in-microsoft-power-bi-reports/
You plan to develop a Power BI report that has a bar chart to display the number of customers by location.
You have a table named Customer that has the following columns:
- CustomerID
- CustomerName
- Address
- City
- ProvState
- Country
You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.
How should you configure the drill down in the bar chart?
In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
In the Value field, add Country at the top, followed by ProvState, and then City.
In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
In the Axis field, add Country at the top, followed by ProvState, and then City.
Answer is In the Axis field, add Country at the top, followed by ProvState, and then City.
For drilldown drag-drop the fields in order into the same Axis bucket.
References:
https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down