Design and Develop Dashboards - 23%

Question 1

Ways to optimize dashboard performance

Answer 1

Minimize number of fields and record

Optimize extracts

Reduce marks used
Limit filters

Include over exclude filters

Use continuous date filters, boolean, numeric filters

Use parameters and action filters

Perform calcs in the database

Reduce number of nested calcs

Reduce granularity of LOD or table calcs in view

Blend low granularity dimensions

Minimize joined tables
Remove custom sql

Reduce dashboard score and unused worksheets/data sources

Question 2

Text table

Answer 2

Helps to see what data you are pulling in

Question 3

heat map

Answer 3

Similar to the text table but uses size and color as visual cues to describe the data. Allows us to easily tell a story about the data. It is an effective way to compare categories using color and size

Question 4

highlight table

Answer 4

Use color to highlight data and tell a story. Also similar to an Excel table but the cells are colored

Question 5

Bar Chart

Answer 5

quickly compare data across categories, highlight differences, show trends and outliers, and reveal historical highs and lows at a glance.

Bar charts are especially effective when you have data that can be split into multiple categories.

Question 6

Line Chart

Answer 6

Use line charts to view trends in data, usually over time

Question 7

Density Maps

Answer 7

reveal patterns or relative concentrations that might otherwise be hidden due to an overlapping mark on a map—helping you identify locations with greater or fewer numbers of data points.

Density maps are most effective when working with a data set containing many data points in a small geographic area.

Question 8

Scatter Plot

Answer 8

effective way to investigate the relationship between different variables, showing if one variable is a good predictor of another, or if they tend to change independently.

A scatter plot presents lots of distinct data points on a single chart.

Question 9

Gantt Chart

Answer 9

project schedule or show changes in activity over time.

A Gantt chart shows steps that need to be completed before others can begin, along with resource allocation

Question 10

Bubble Chart

Answer 10

using them as a technique adds detail to scatter plots or maps to show the relationship between three or more measures.

Varying the size and color of circles creates visually compelling charts that present large volumes of data at once

Question 11

Treemap

Answer 11

each rectangle in a treemap is subdivided into smaller rectangles, or sub-branches, based on its proportion to the whole.

They make efficient use of space to show percent total for each category.