Microsoft Power BI Data Analyst Questions and Answers
Question 21
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Options:
A.
a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
B.
a clustered column chart that shows balances by date (x-axis) and account category (legend) without
filters.
C.
a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
D.
a pie chart that shows balances by account category without filters.
E.
a ribbon chart that shows balances by quarter and accounts in the legend.
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
Options:
A.
Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B.
Change the data type of the Logged column to Date.
C.
Split the Logged column by using at as the delimiter.
D.
Apply a transformation to extract the first 11 characters of the Logged column.
Answer:
C
Explanation:
Explanation:
Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:
It will even automatically change the type to Date:
= Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})
Question 24
You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?
Options:
A.
decomposition tree
B.
funnel chart
C.
Q&A
D.
key influencers
Answer:
A
Explanation:
Explanation:
The key influencers visual is a great choice if you want to:
See which factors affect the metric being analyzed.
Contrast the relative importance of these factors. For example, do short-term contracts affect churn more than long-term contracts?
Note: The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time.