Visualization

Question 1

Your manager has asked you to prepare a visual on QuickSight to see trends in how money was spent on entertainment in the office in the past 12 months. What visual will you use?

Answer 1

Line chart (Line charts are appropriate for viewing trends in data over time.)

Question 2

You wish to publish a visual you’ve created illustrating trends of work coming into your company, for your employees to view. Which tool in QuickSight would be appropriate?

Answer 2

Dashboard (A dashboard is a way to publish a screen of data to a larger audience.)

Question 3

You want to build a visualization from the data-set you have imported, but you are unsure what visual to select for the best view. What can you do?

Answer 3

Select auto-graph (Auto-graph will automatically try to select the most appropriate visualization type for the data you have selected.)

Question 4

The source data you wish to analyze is not in a clean format. What can you do to ensure your visual in QuickSight looks good, with a minimum of effort?

Answer 4

Select edit / preview data before loading it into analysis, and edit it as needed.

Question 5

How can you point QuickSight to fetch from your database stored on the EC2 instance in your VPC ?

Answer 5

Add Amazon QuickSight IP range to the allowed IPs of the hosted DB

Question 6

True or False: To help you better visualize your data, Amazon QuickSight can select the most appropriate visualization style based on the properties of the data you select, such as cardinality and data type.

Answer 6

True

(QuickSight can create a visual for you. You select the fields you want to use, and use the AutoGraph feature to determine the most appropriate visual type. You can then modify it in a number of way to customize it to your needs.)

Question 7

A company has set revenue goals for each of their regional businesses across the world. The CEO needs a report showing revenue goals by region. She also needs a visual that uses rectangle sizes and colors to show which regions have the highest revenue goals. Which visual type would best suit her needs?

Answer 7

Tree Map

(The tree map visual type would be ideal for this scenario. 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. Further information: http://docs.aws.amazon.com/quicksight/latest/user/tree-map.html)

Question 8

Your client needs assistance with data visualization. The client’s developers are fluent in Python and tend to favor tools that integrate well with Python. Which open-source tool is likely to align with the developer needs?

• Hue
• Jupyter Notebook
• Apache Zeppelin
• D3.js

Answer 8

Jupyter Notebook

(While both Jupyter and Zeppelin both support Python, it is debatable in the Big Data community as to which notebook to use. Python developers tend to lean towards Jupyter as it is more mature. If you are only working in Python (for non-Spark use cases), Jupyter might be a better choice. If you are working with Spark, Zeppelin is a better choice for Python or Scala.)

Question 9

What is SPICE?

Answer 9

Super-fast, Parallel, In-memory Calculation Engine

(SPICE is QuickSight’s Super-fast, Parallel, In-memory Calculation Engine. SPICE performs advanced calculations and serves data. Data is imported into SPICE in order to speed up queries by taking advantage of SPICE’s storage and processing capacity. Data retrieval time from a data source is reduced when you make a change to an analysis or update a visual.)

Question 10

True or False: A Jupyter Notebook can contain live code.

Answer 10

True

(A Jupyter Notebook is an interactive computing environment that enables users to author notebook documents that include live code.)

Question 11

Which of the following are uses for D3.js? (Choose 2)

• Data storage
• To migrate data from documents to data stores
• To generate HTML tables, SVG bar charts, and other visualizations like real-time dashboards, as well as interactive graphs and charts that work in a browser
• To produce dynamic, interactive data visualizations in web browsers

Answer 11

• To generate HTML tables, SVG bar charts, and other visualizations like real-time dashboards, as well as interactive graphs and charts that work in a browser
• To produce dynamic, interactive data visualizations in web browsers

(D3.js JavaScript library for producing dynamic, interactive data visualizations in web browsers. D3.js can read in data from csv, tsv, or from JSON files. You can generate HTML tables, SVG bar charts, and other visualizations like real-time dashboards, interactive graphs, and charts that work in a browser. Further information: https://d3js.org/)

Question 12

True or False: A QuickSight Dashboard is a read-only view into the data.

Answer 12

True

(A QuickSight Dashboard is a read-only snapshot of an analysis. You can share it with other Quicksight users for reporting. The data in the dashboard reflects the data set that is used by the analysis. If you share a dashboard with users, they can then view and filter the dashboard data, but they cannot save any filters applied to the dashboard.)