MSP Bank Data Discovery Platform

Customized Table View for MSP Bank Data Discovery Platform 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.

They are looking for a customized table view of data.

Please help.

select 1 option.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer: A.

Option A is correct - 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.html

Option 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.html

Option C is incorrect -Use pie charts to compare values for items in a dimension.

Each wedge in a pie chart represents one item in the dimension.

Wedge size represents the proportion of the value for the selected measure that the item represents compared to the whole for the dimension.

Pie charts are best when precision isn't important and there are few items in the dimension.

https://docs.aws.amazon.com/quicksight/latest/user/pie-chart.html

Option 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 team at MSP Bank is looking for a customized table view of their data in the self-data discovery platform that they are planning to launch on QuickSight. Given this requirement, the most suitable option for them would be A. Tabular Reports.

Tabular Reports are a type of report that presents data in a table format, with rows and columns. This type of report is highly customizable, allowing users to add or remove columns, change the column headers, and adjust the layout of the table to fit their needs. In addition, tabular reports are highly effective for displaying large amounts of data in a concise and easy-to-read format.

Heat Maps are a type of data visualization that displays data in a matrix format using colors to represent the values of each data point. Heat maps are useful for quickly identifying patterns or trends in large datasets, but they are not well-suited for presenting data in a tabular format.

Pie Charts are a type of data visualization that displays data as a circle divided into slices, with each slice representing a different category or data point. Pie charts are useful for showing the relative proportions of different categories, but they are not well-suited for presenting data in a tabular format.

Tree Maps are a type of data visualization that displays data as a hierarchical set of nested rectangles, with each rectangle representing a different category or data point. Tree maps are useful for showing the relative proportions of different categories, but they are not well-suited for presenting data in a tabular format.

In summary, the best option for the MSP Bank team looking for a customized table view of their data in the self-data discovery platform on QuickSight would be A. Tabular Reports.