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.
The C. Bar Chart is the best choice for this visualization because:
It can handle multiple dimensions (e.g., country and shipping region) simultaneously.
It clearly represents the percentage of late orders for each dimension.
It avoids the clutter and limitations of pie charts, which are unsuitable for multidimensional data.
Pie chart would visualize % break down for total 100% of late orders but not % of late orders out of total orders.
Scatterplot could visualize late orders by country and shipping region and set bubble size related to the % of late orders over total orders but would be not the most effective visual.
Bar chart is best way amongst suggested options to represent the % of late orders and would also mak easier to compare % values between different customers, regions, shipment regions....
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 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, 5 months agoSucheta_SM
Highly Voted 2 years, 4 months agoFer079
2 years, 4 months agoBabaJee
2 years, 1 month agosa56
1 year, 10 months agoAfuIRa
10 months, 2 weeks agoLayla0322
Most Recent 1 month, 2 weeks agojaume
2 months, 3 weeks agoSmitpowerbi
9 months, 1 week agoMoneyStacking
9 months, 3 weeks agoIVO999
10 months, 2 weeks agoJohnChung
1 year agokimii1993
1 year, 3 months agoiamak96
1 year, 1 month ago9f73003
10 months agojl234
1 year, 4 months agoWRTopics
1 year, 4 months agoJJMC5544
1 year, 7 months agohalofrosty
1 year, 7 months agoVNAS06
1 year, 8 months agoMcisneros
1 year, 9 months agoUlyUkr
1 year, 9 months agoOutsider
1 year, 9 months ago