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

Answer is C https://docs.aws.amazon.com/quicksight/latest/user/heat-map.html Use a heat map if you want to identify trends and outliers, because the use of color makes these easier to spot.

Correct answer is C as Heat Map can help measure the intersection between two dimensions i.e cities and stores, with color-coding to easily differentiate the patterns. Use heat maps to show a measure for the intersection of two dimensions, with color-coding to easily differentiate where values fall in the range. Heat maps can also be used to show the count of values for the intersection of the two dimensions. Each rectangle on a heat map represents the value for the specified measure for the intersection of the selected dimensions. Rectangle color represents where the value falls in the range for the measure, with darker colors indicating higher values and lighter colors indicating lower ones. 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 the use of color makes these easier to spot. Use a pivot table if you want to further analyze data on the visual, for example by changing column sort order or applying aggregate functions across rows or columns.

C: I passed the test

Correct ans is C

C is the right answer. We have the requirements "easily identify revenue trends across cities and stores" and "identify outliers" A: first requirement not fulfilled, there are more stores than cities so it is possible that two stores have the sam postal code, which means they are not distinguishable with geospatial charts B - first requirement not fulfilled, a line chart with 15 lines is impossible to understand "easily" C - both requirements fulfilled, it's easy to tell apart stores / cities and outliers are easily visible, also you can view trends over time D - first requirement not fulfilled, it's not possible to see trends over time

Answer is B The best type of visualization for the sales team's requirements is a line chart. A line chart provides an easy way to identify revenue trends across cities and stores, as well as outliers that need to be examined with further analysis. It is also suited to compare multiple sets of data easily. With a line chart, users can simply follow the line to identify where the revenue for each city and store is trending up or down.

Use heat maps to show a measure for the intersection of two dimensions, with color-coding to easily differentiate where values fall in the range. Heat maps can also be used to show the count of values for the intersection of the two dimensions.

Option "C". Quote below from AWS :- "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 the use of color makes these easier to spot. Use a pivot table if you want to further analyze data on the visual, for example by changing column sort order or applying aggregate functions across rows or columns."

If the option is base on product or store (only) then I select heat map, but in here we have location information

B: All other options fail to show a trend over time. Outliers are also clearly visible in line chart.

I vote for C. "Use a heat map if you want to identify trends and outliers, because the use of color makes these easier to spot." https://docs.aws.amazon.com/quicksight/latest/user/heat-map.html I don't think A is the answer because a geospatial chart would display the total revenue in each city and would not be able to identify outliers at the store level.

Heat map - the rectangle gives - value (revenue range per city can be identified) , trend/outlier (darkness of the colour)

my vote for B

Answer is A

I suppose ans should be A. You can create two types of maps in Amazon QuickSight: point maps and filled maps. Point maps show the difference between data values for each location by size. Filled maps show the difference between data values for each location by varying shades of color. https://docs.aws.amazon.com/quicksight/latest/user/geospatial-charts.html

I think it should be A. The questions states that it wants to quickly identify patterns across locations, this is what a geospatial chart is for. I would use colors and circle size to quickly show the patterns.

It's B. I.e. line chart. You can display revenue patterns with each line representing each location. A is ruled out as you can't show any pattern using Geospacial. Also, there are multiple locations within each city so this type of chart won't make sense. C and D are ruled out as they can't show any pattern.