AWS QuickSight Chart for Measuring Values Over Time
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.
The team is looking for a chart to measure values over period of time. Choose Correct Option.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
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 incorrect -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 correct -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.htmlBased on the requirement of measuring values over a period of time, the most suitable chart type would be a Line Chart.
A line chart is a visual representation of data points connected by straight line segments, and it is used to show trends and changes over a period of time. It is the ideal chart type for analyzing trends, as it can show how data points change over time and allow the viewer to easily identify patterns and correlations.
Tabular reports present data in a table format, which is useful for comparing values across multiple categories or dimensions, but it does not provide a visual representation of data over time.
Heat maps are used to display large volumes of data using color-coding, and they are often used to show patterns in data sets with multiple dimensions. However, they are not the ideal chart type for measuring values over a period of time.
Tree maps are used to display hierarchical data in a nested format, and they can be useful for visualizing data relationships. However, they are not well-suited for displaying time series data.
Therefore, the correct option for the team to use for measuring values over a period of time would be a Line Chart.
