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. The team is looking for a chart to show a measure for the intersection of two dimensions, with color-coding to easily differentiate where values fall in the range.
please help.
Select 1 option.
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: B.
Option A is incorrect -Use tabular reports to see a customized table view of your data.
To create a table visual, choose at least one field of any data type.
You can add as many columns as you need.
Plus, you can add calculated columns.
https://docs.aws.amazon.com/quicksight/latest/user/tabular.htmlOption B is correct -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.
https://docs.aws.amazon.com/quicksight/latest/user/heat-map.htmlOption C is incorrect -Use line charts to compare changes in measure values over period of time, for the following scenarios:
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.htmlOption D is incorrect -Use tree maps to visualize one or two measures for a dimension.
Each rectangle on the tree map represents one item in the dimension.
Rectangle size represents the proportion of the value for the selected measure that the item represents compared to the whole for the dimension.
You can optionally use rectangle color to represent another measure for the item.
Rectangle color represents where the value for the item falls in the range for the measure, with darker colors indicating higher values and lighter colors indicating lower ones.
https://docs.aws.amazon.com/quicksight/latest/user/tree-map.html.
The chart that can show a measure for the intersection of two dimensions, with color-coding to easily differentiate where values fall in the range, is called a Heat Map.
A Heat Map is a graphical representation of data where values are depicted using color codes. It is used to visualize data that is presented in a table or matrix format, where the rows and columns represent different dimensions, and the values represent the intersection of those dimensions.
In the case of MSP Bank, a Heat Map can be used to show a measure for the intersection of two dimensions. For example, if the two dimensions are "Loan Type" and "Region", a Heat Map can be used to show the distribution of loan amounts across different loan types and regions. The color-coding can be used to show where values fall in the range, making it easy to identify areas where there are high or low values.
Tabular Reports, Line Charts, and Tree Maps are not suitable for this requirement. Tabular reports are a simple way to display data in rows and columns, but they do not have any graphical representation of data. Line charts are used to show trends over time, but they are not suitable for comparing values across multiple dimensions. Tree maps are used to display hierarchical data, where each level is represented by a rectangle or square, and the size of the rectangle or square represents the value. However, they are not suitable for comparing values across two dimensions.