Tableau set 4

Waterfall Chart

Waterfall Chart can visualize the cumulative effect of a measure over dimension. It can show the contribution of growth or decline by each member in a dimension. For example, you can see the contribution of profit by each sub-category using a waterfall chart.

Measure name

consists of all the names of the measure present in a data set. It always presents at the end of dimension list. It consists of discrete values of all measure names.

Types of charts in Tableau

14 types of charts in tableau. Pareto chart, bullet chart, bar chart, line chart, text tables, heat map, waterfall chart, gantt chart, pie chart, scatter plot, area chart, dual axis chart, bubble chart, histogram

How many types of cases for measures

4, Case 1, Case 2, Case 3, Case 4

Gantt chart

A Gantt chart can show the comparison of data between categories. It can be used to identify the time taken for each process.

Line chart

A Line Chart should be used to compare the data over the different periods. A line chart is created by the series of dots. These dots represent the measured value in each period. The procedure to create line graph is shown below.

Pareto chart

A Pareto chart consists of both bar and line graph. The same measure is used to create the graphs but the measure values are manipulated differently. The purpose of using Pareto Chart in Tableau is to identify the contribution of members present in a field.

Case 3

Alias name can be created for measure names. It can be shown in the visualization for better identification. You can see the name change in Visualization.

Measure values

All the measure values present in a data set are kept together in the field called measure values. It always presents at the end of measure list. Consists of continuous values of all measures.

Case 2

Any measures can be removed from the visual by removing the measure from mark card.

Area Chart

Area chart can represent any quantitative (measure) data over different period of time. It is basically a line graph where the area between line and axis is generally filled with color.

Text Tables

Text tables are used to show the exact value of measures across the different dimension. A text table is also known as a Pivot Table. It groups the dimensions and measures by default.

Scatter Plot

The relationship between two measures can be visualized using scatter plot. A scatter plot is designed by adding measures in both x and y-axis. This can show the trend or relationship between the measures selected.

Measure Names and Measure Values

two fields in tableau that are created by default. Created when a data set is imported into tableau. Can go to data pane and view the fields

Tableau alternatives

Sisense, Oracle, SAS, Pentaho, QlikView, Dundas BI, BOARD, Profitbase BI, LongView, Birst, SAP Business Intelligence(BI)

Generated Fields

Tableau generates some fields which can be visible in the data pane. These fields are generated in addition to the fields present in the data set. The generated fields are given as follows. Measure Names Measure Values Number of Records Longitude Latitude

Bar Chart

A bar chart can compare the data across different categories. The height of the bars represents the measured value of each category. It can be represented as vertical and horizontal type bar charts. The procedure to create bar chart is given as follows.

Bubble Chart

A bubble chart visualizes the measures and dimensions in the form of bubbles. The sizes of the bubbles determine the size of measure value for effective visualization. The color of bubbles can be set to differentiate the members present in a dimension.

Bullet Chart

A bullet chart can be used as a gauge or indicator to show the performance of measures. Two measures can be compared to each other using the bullet graph.

Heat Map

A heat map can visualize the data in the form of size as well as color on different measures. Two different measures can be visualized simultaneously using heat map. One measure can be assigned to size whereas another measure can be assigned to the color of the heat map.

Histogram

A histogram can show the values present in a measure and its frequency. It shows the distribution of numerical data. As it shows both frequency and measure value by default, it can be useful in many cases.

Pie Chart

A pie chart can show the segment-wise data. It can show the contribution of measure over different members in a dimension. The angle of pie determines the measured value. Different colors can be assigned to pie to represent the members in a dimension.

Dual Axis Chart

Dual axis chart can be used to visualize two different measures in two different chart types. A date column and two measures are necessary to build a dual axis chart. The different scales used in the graph helps the user to understand both measures.

Case 4

If you want to analyze multiple measures in a single visual, it can be done by using measure names and measure values. It creates a filter on selected measures in the worksheet.

Longitude and Latitude

Longitude and Latitude (generated) fields are associated with the geographical detail present in the data. Dataset should consist of geographical details like City, Country or State. The longitude and latitude values are auto-generated in Tableau. These fields can be used to build maps in Tableau.

Case 1

Measure names and Measure values can be used to see the aggregation of all measure present in a data set. These fields can be shown as different types of visualization in Tableau. It creates a visual for all measures present in the data set. By default, Tableau creates a bar chart showing all the measure names and their values.

Number of Records

Number of records shows the count of records present in the data set. It is an auto-generated field in Tableau which assigns a value '1' for each record present in the data set. It can be used to verify the count of records when joining multiple tables.