Tableau Interview Questions for Exam 1

What are the 4 data relationships used when visualizing data?

1) Comparison 2) Composition - collect different types of info that make up a whole - ie how many visitor of your site where directed to you by way of search engine? 3) Distribution 4) Relationship

Charts for Relationship =

2 Variables = Scatter Chart 3 Variables = Bubble Chart

What is a histogram?

A Histogram visualizes the DISTRIBUTION of data over a continuous interval or certain time period. Each bar in a histogram represents the tabulated frequency at each interval/bin. The total area of the Histogram is equal to the number of data.

What is a line chart?

A Line Chart is the most popular type of the data visualization. As a rule, it is used to emphasize trends in data over equal time intervals, such as months, quarters, fiscal years, and so on.

How do you define a dashboard?

A dashboard is a visual display of information that helps us visually display, track and analyze key performance indicators (KPI) and metrics to monitor the health of a business

What is the data source page in Tableau?

A data source page is where you can set up your data source. The Data Source page generally consists of four main areas: left pane, join area, preview area, and metadata area.

What is a Scatter Plot?

A scatter plot can give us a general idea if a correlation exists and how strong it is. A scatter plot shows the relationship between two different values. This is particularly useful to identify outliers or to understand the correlation in the data. The data sets need to be in pairs with a dependent variable and an independent variable

Charts for Comparisons =

Comparison among items = Bar Charts Comparison over time = Column Chart Line Chart

Charts for Composition =

Composition Changing over time = Stacked Column Chart Stacked Area Chart Composition Static = Pie Chart Waterfall Chart

Charts for Distribution =

Distribution Single Variable = Histograms Dist. Multiple Variables = Scatter Chart

What are groups?

Group simplifies large numbers of dimension members by combining them into higher-level categories. You can create a group to combine related members in a field. For example, if you are working with a view that shows average test scores by major, you might want to group certain majors together to create major categories. English and History might be combined into a group called Liberal Arts Majors, while Biology and Physics might be grouped as Science Majors.

What are the differences between groups and sets?

Groups simplify large numbers of dimension members by combining them into higher-level categories. Sets create a custom field based on existing dimensions that can be used to encode the view with multiple dimension members across varying dimension levels.

What are sets?

Sets are custom fields that define a subset of data based on some conditions. A set can be based on a computed condition, for example, a set may contain customers with sales over a certain threshold. Computed sets update as your data changes. Alternatively, a set can be based on specific data point in your view

What is a slope graph?

Shows how ranks have changed over time or vary between categories A slope graph is a lot like a line graph, in that it plots change between points. However, a slope graph plots the change between only two points, without any kind of regard for the points in between

What is a bin?

Sometimes it's useful to convert a continuous measure (or a numeric dimension) into bins. Any discrete field in Tableau can be considered as a set of bins. For example, suppose you create a view with Profit on Rows and State on Columns. You could consider the State field as a set of bins -each profit value is sorted into a bin corresponding to the state from which the value was recorded. But if you want to see values for Profit assigned to bins without reference to a dimension, you can create a numeric bin, with each individual bin corresponding to a range of values

What is a waterfall chart?

The Waterfall Chart type is generally used to understand the influence of several positive and negative factors on the initial value. Points are utilized to display the process of the initial value change and can be in one of the three states: increase, decrease, or total (subtotal). The first and last columns in a Waterfall Chart usually represent totals. The intermediate ones stand for the changes

What is data visualizations primary goal?

is to communicate information clearly and efficiently via graphs and charts. in other words - Data visualization is the process of displaying data in graphical charts so that businesses can find insights quickly and easily to make better decisions for good outcomes