Visualization

Question 1

When do you use heatmaps?

Answer 1

1. Use heat maps to show a measure for the intersection of two dimensions, with color-coding.
2. Use when you need to identify trends and outliers in a tabular fashion

Question 2

When do you use pivot tables?

Answer 2

1. Use pivot tables to further drill down and analyze data in a visual in a tabular fashion
2. Use when aggregate functions is needed on columns/rows

Question 3

What does it mean to have a VPC Connection in QuickSight?

Answer 3

1. You connect QuickSight to a VPC by attaching an elastic network interface into that VPC

Question 4

What configuration is needed for a Quicksight VPC connection to a data source?

Answer 4

1. The DNS name of the VPC data source can be resolved from outside of your VPC.
2. The connection returns the private IP address of your instance. (Databases hosted by Amazon Redshift, Amazon RDS, and Aurora automatically meet this requirement.)
3. There is a clearly defined network path from the data source to QuickSight.
4. You registered the VPC with QuickSight by creating or using a VPC connection with the QuickSight console.

Question 5

When should you use the Combo Chart in Quicksight?

Answer 5

1. Use Combo Charts when you want to show 2 related but different types of data
2. AKA Line and Bar/Column chart
3. Shows trends and categories over time

Question 6

When should you use the Box Plot in Quicksight?

Answer 6

1. AKA box and whisker plots,
2. Display data pooled from multiple sources into one visual
3. Use a box plot to visualize how data is distributed across an axis or over time