You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?
The bar chart makes more sense due to the complexity of two added factors ie. country and shipping region. Otherwise you will have to create two Pie Charts
A. Pie chart.
A pie chart is an effective way to show the percentage of a whole, in this case, the percentage of late orders. The pie chart will display the percentage of late orders by country and shipping region. It is an excellent way to show a summary of the data and quickly identify areas that need attention. However, if you also want to compare the percentage of late orders between different countries or regions, a bar chart might be more appropriate.
I think we can use a pie chart, which is an effective way to show percentages.
The case study requires a visual to show the percentage of orders shipped late for a selected month or quarter. This can be achieved by making a pie chart with interaction setting as filter
The answer should be Bar chart. By using Pie chart, one can not include too much information in it. But refer to the question, "The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region
Customers that had multiple late shipments during the last quarter". We can't put all these into a pie chart.
Pie chart could help, but question says "a visualisation". Regions, countries and percentages would be complex to show in a pie chart, would need multiple pie charts. But questions says "a visual".
So if we use a stacked column chart:
- Each column represents a country,
- And the stacked segments represent different shipping regions.
- The height of each segment represents the percentage of late shipments.
As of submitting this comment most voted answer is A. However we need to refer not only to the question itself but the case study, where it states the requirement for showing the data by country and shipping region dimensions, hence pie chart is not meeting the 'full' requirement.
I believe the answer will be Bar chart. As mentioned, - "The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region
Customers that had multiple late shipments during the last quarter
Northwind Traders defines late orders as those shipped after the required shipping date.
The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.
The reports must show historical data for the current calendar year and the last three calendar years."
I think Pie Chart would not fit. Please let me know, if I'm wrong.
I initially chose pie chart. I think that it does work, but I think the reason C is the correct answer is because pie charts excel at summarizing a value column by one single dimension. The requirements need the value summarized by country and shipping region which would look messy as a pie chart but discernable in a bar chart.
There is no definite answer here, Microsoft is always confusing. Not sure sometimes if they are testing the knowledge of Power BI, because all they do is trick you. Real customer would never give such puzzled requirements.
Based on the question itself, I would show a Pie Chart to show the % of Late orders out of all orders. But based on the requirements in the report, I would show a 100% Stacked bar chart by Country and shipping region.
The case is complex, because the question ask for "a" visualization. So, just one visualization should shown all the information asked?
"The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region".
Pie chat is the best, but that will need at least 2 visualizations. we have Time Month and Quarter and 2 DIM.
Putting all in just 1 visualization, the bar chart will solve the problem. So, C
A pie chart is a type of visualization that is often used to display data as a percentage or a proportion of a whole. In this case, the On-Time Shipping report is showing the percentage of orders that were shipped late. The pie chart would be an ideal choice because it allows us to see the relative size of each category (i.e., country and shipping region) as a slice of the whole pie.
Becuase
The On-Time Shipping report will show the following metrics for a selected shipping month or quarter
there is two axis, so Pie Chart could be fit there
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Namenick10
Highly Voted 2 years, 1 month agoSucheta_SM
Highly Voted 2 years, 1 month agoFer079
2 years, 1 month agoBabaJee
1 year, 10 months agosa56
1 year, 6 months agoAfuIRa
6 months, 3 weeks agoSmitpowerbi
Most Recent 5 months, 2 weeks agoMoneyStacking
6 months agoIVO999
6 months, 3 weeks agoJohnChung
9 months agokimii1993
11 months, 2 weeks agoiamak96
9 months, 3 weeks ago9f73003
6 months, 2 weeks agojl234
1 year agoWRTopics
1 year agoJJMC5544
1 year, 3 months agohalofrosty
1 year, 4 months agoVNAS06
1 year, 5 months agoMcisneros
1 year, 5 months agoUlyUkr
1 year, 5 months agoOutsider
1 year, 5 months agoShalaleh
1 year, 6 months agoSanaCanada
1 year, 6 months ago