Exam AWS Certified Data Analytics - Specialty topic 1 question 89 discussion

A provides needful

A: I passed the test

A pivot table of sales volume data summed up at the state level will meet the requirement of an interactive and intuitive visualization of which states across the country recorded a significantly lower sales volume compared to the national average. The pivot table can be sorted by the sales volume column and filtered to show only the states with lower sales volume than the national average, making it easy to identify the problem areas. A geospatial color-coded chart (option A) could also be useful, but it may not be as intuitive for identifying the states with lower sales volume.

I think it is C, since with A you are not comparing the states against the national average

A "intuitive visualization"

Answer is A Data visualization depends on the story you want to tell. Maps are great at visualizing your geographic data by location. The data on a map is often displayed in a colored area map or a bubble map. If the location is not part of the story, a map could be messy. With a table, you can display a large number of precise measures and dimensions. You can quickly look up or compare individual values while also showing grand totals. However, given the amount of data, tables take longer to digest. Heat maps and pivot tables display data in a similar tabular fashion. Use a heat map if you want to identify trends and outliers because color makes these easier to spot. Use a pivot table if you're going to further analyze data on the visual, for example, by changing column sort order or applying aggregate functions across rows or columns.

A is more intuitive in this context

The question ask for " interactive and intuitive visualization". Both A and B works, but with a Pivot table it's hard to identify the states with the largest drop. You have to compare the numbers across the entire table. Not good

A is correct

The answer is A.

Selected Answer: A

They just want State names with low total sales. there is no need to show those on a map

I support C. drill-down meets the need for interactive; state-level sales volume data meets the need for display of which states achieved considerably lower sales volumes than the national average

I think both a Pivot Table and a geo-spatial chart would be nice in this case. However, because the geo-spatial chart would work because we have lat/lon coordinates, and because I feel like these are considered more comprehensible by the exam-makers, I will choose A.

A will only show the volume for each state and location of the state in the map. How does it compare against the national average? I think ans is D.

We only need to compare the sales volume for each state. So there is no need for pivot table here as no requirement for slice and dice of data. GeoSpatial graph will do the job nicely

I think it should be B. Using pivot table, we can display sales by city, and sum up with state level. We can use "collapse", "sort" to get an "interactive and comprehensive" display.