Intersection Analysis on QuickSight
Question
MSP Bank, Limited is a leading Japanese monetary institution that provides a full range of financial products and services to both institutional and individual customers.
It is headquartered in Tokyo.
MSP Bank is hosting their existing infrastructure on AWS.
MSP bank has many segments internally and they are planning to launch a self-data discovery platform running out of AWS on QuickSight. Using QuickSight, multiple datasets are created and multiple analyses are generated respectively.
The Team is working on visuals and looking to measure for the intersection of two dimensions, with color- coding to easily differentiate where values fall in the range Pleaseselect 1 option.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
Option A is incorrect - A bar chart visual type is used to create a single-measure, multi-measure, or clustered bar chart.
A single-measurebar chart shows one measure for one dimension, for example average delay time by flight number.
A multi-measure bar chart shows two or more measures for one dimension, for example sales total and profit total by automobile mode.
A clustered bar chart shows values for a dimension grouped by a related dimension, for example sales totals by automobile model, grouped by car maker.
https://docs.aws.amazon.com/quicksight/latest/user/bar-charts.htmlOption B is incorrect -On the clustered bar combo chart, bars display for each child dimension, grouped by the parent dimension.
On the stacked bar combo chart, one bar displays per parent dimension.
https://docs.aws.amazon.com/quicksight/latest/user/combo-charts.htmlOption C is correct - heat maps to show a measure for the intersection of two dimensions, with color-coding to easily differentiate where values fall in the range.
https://docs.aws.amazon.com/quicksight/latest/user/heat-map.htmlOption D is incorrect -Use line charts to compare changes in measure values over period of time.
One measure over a period of time, for example gross sales by month.
Multiple measures over a period of time, for example gross sales and net sales by month.
One measure for a dimension over a period of time, for example number of flight delays per day by airline.
https://docs.aws.amazon.com/quicksight/latest/user/line-charts.htmlThe best visualization option for measuring the intersection of two dimensions with color-coding to differentiate values in the range is C. Heat Maps.
Heat Maps use color gradients to represent values in a dataset. It is an effective way to display large amounts of data and can quickly identify patterns and trends. Heat Maps are ideal for identifying the intersection of two dimensions with color-coding because it provides an easy way to compare values and detect patterns or trends. The colors used in Heat Maps can be customized to represent different values, making it easy to differentiate where values fall in a range.
Bar Charts are useful when comparing values across different categories. They are typically used to show the relationship between two variables. While they can be effective in displaying data, they are not ideal for identifying the intersection of two dimensions.
Combo Charts combine different types of charts, such as a bar chart and a line chart. They can be useful when displaying different types of data, but they are not ideal for identifying the intersection of two dimensions.
Line Charts are useful when showing trends over time or continuous data. They are typically used to show how one variable changes in relation to another over time. While they can be effective in displaying data, they are not ideal for identifying the intersection of two dimensions.
Therefore, based on the requirements stated in the question, Heat Maps is the best option for visualizing the intersection of two dimensions with color-coding to differentiate values in the range.
