Đại học Kinh tế Quốc dân – National Economics UniversityMICRO4ASIA
🏆 Arena
Sign inSign up
MICRO4ASIAThe six micro-credentials

Courses are delivered on the Limio learning platform. Limio

← Data Visualization in Business

You are viewing a public preview

Sign in to save your progress, do assignments, join discussions and get feedback.

Sign in
Module 4 — Building Advanced Charts and Analyzing Data in Tableau

4.3 · Data Exploration and Interpretation

Print / Save as PDF

In this lesson

Trend lines, correlation, forecasting, trend and seasonality analysis; clustering and customer segmentation; parameters and their use with calculated fields; filter, highlight and URL actions; identifying patterns, outliers and group differences, and interpreting business findings.

Learning outcomes

  • LO.5: Use Tableau Desktop and Tableau Public to connect data, organize fields and build visualizations.
  • LO.6: Select, build and refine charts that fit the analytical objective and the data.
  • LO.7: Apply calculations and analytical techniques to explore business data and interpret findings.
  • LO.9: Select and justify visualization methods and tools for a business problem.

The lecture slides for this lesson are below.

Practice for Module 4

Practise advanced charts, calculated fields, table calculations and LOD expressions on the practice data; explore trends, forecasts, clusters, parameters and interactive actions, and write a short interpretation of what you find. (About 24 hours of independent study.)

Study notes

By the end of this lesson you can:

  • Create sets, groups, bins and clusters and explain how each one divides data.
  • Add trend lines and forecasts and interpret trend, seasonality and uncertainty.
  • Create parameters and connect them to calculated fields, filters or sets.
  • Use filter, highlight and URL actions to make views interactive.
  • Interpret patterns, outliers and group differences without overstating them.

Key idea: Exploration tools help you find structure in data, but a pattern is only useful once you can explain it in business terms and know how certain it is.

Sets, groups, bins and clusters

ToolWhat it doesTypical use
SetA custom field defining a subset; every member is either In (True) or Out (False)Compare top customers with the rest
GroupCombines members of one dimension into a higher-level categoryMerge provinces into areas
BinsDivides a measure into equal-width intervals, creating a new dimensionHistogram of order values
ClusterGroups marks with similar values using k-meansCustomer segmentation

Sets are created by right-clicking a dimension (Create → Set). You can pick members manually, define a condition (for example SUM(Profit) > 0) or use the Top tab (top N by a measure). Condition and Top sets update when the data change. Put the set on Color to see In/Out, or use Show Members in Set.

Groups collect members with the same characteristics into a higher-level category within a single dimension (paperclip icon or Create → Group).

Bins are created from a measure (Create → Bins). Tableau suggests a bin size; you can change it. The result is a new dimension such as Sales (bin).

Clusters use the k-means algorithm to divide marks into k groups. Drag Cluster from the Analytics pane onto a view; Tableau uses the measures in the view as variables (you can add others), chooses the number of clusters automatically or uses the number you set, and you can drag the result to the Data pane to save it as a group. Describe Clusters summarises each cluster.

Trend lines, correlation and forecasting

  • Trend line (Analytics pane): fits a linear, logarithmic, exponential, polynomial or power model to a view with continuous axes. Describe Trend Line shows R-squared (how much variation the model explains) and a p-value (whether the fit is likely to be chance).
  • Correlation: a scatter plot with a trend line shows whether two measures move together. Correlation is not causation: a third factor (such as Category) may drive both.
  • Forecast (Analytics → Forecast): Tableau uses exponential smoothing on a time series. It detects trend (long-term direction) and seasonality (a pattern that repeats, for example every year) and shows a shaded prediction interval, by default 95%. Forecast Options sets the forecast length and model; Describe Forecast shows what was used.

Parameters

A parameter is a workbook variable (a number, date or string) whose value the viewer can change through a parameter control. A parameter does nothing on its own: it must be referenced by a calculated field, a filter (for example Top N by a parameter), a set, a reference line or a bin size. Show Parameter displays the control.

Actions

Actions (Worksheet → Actions or Dashboard → Actions) respond to a hover, a selection or a menu click:

  • Filter action: selecting marks in one view filters other views.
  • Highlight action: related marks are highlighted and the rest are dimmed.
  • Go to URL: opens a web page, which can include field values in the URL.
  • Further types include Go to Sheet, Change Parameter and Change Set Values.

Interpreting what you find

Look for patterns (trends, seasonality, clusters), outliers (marks far from the rest) and group differences (one segment behaves differently). For each, ask: Is it large enough to matter? Could a data issue explain it? Is there another factor behind it? Then state the finding with its limits and a business implication.

Worked example

The sales director wants one chart that can switch between Sales, Profit and Quantity by Region, so she can see whether the ranking of regions changes with the metric. Use the course data.

  1. Create the parameter. Create Parameter named Choose Measure, data type String, allowable values List: Sales, Profit, Quantity.
  2. Connect it to a calculation.
CASE [Choose Measure]
WHEN "Sales" THEN SUM([Sales])
WHEN "Profit" THEN SUM([Profit])
WHEN "Quantity" THEN SUM([Quantity])
END

Every branch is aggregated, so the calculation is valid. 3. Build the view. Region on Rows, the calculated field on Columns, sorted descending. Right-click the parameter and choose Show Parameter. 4. Dynamic title. Insert the parameter into the title: Regions ranked by <Choose Measure>. 5. Add context. Put Category on Color to see which category drives each region's bar. 6. Interpret. Switch the parameter. If a region ranks high on Sales but lower on Profit, its sales may depend on discounts or low-margin categories; that is a hypothesis to test next with Profit Ratio by Discount, not a conclusion.

Common mistakes

  • Creating a parameter and expecting the view to change. It must be used in a calculation, filter, set or reference line.
  • Reading a forecast as a promise. The prediction interval shows uncertainty; a wide band means a weak forecast.
  • Treating clusters as natural categories. k-means always returns k groups; check that each cluster has a sensible business description.
  • Correlation as causation. A trend line shows association only.

Summary

  • Sets split data into In/Out; groups combine members; bins slice a measure; clusters group similar marks with k-means.
  • Trend lines show direction and fit (R-squared, p-value); forecasts use exponential smoothing with trend and seasonality.
  • Parameters let viewers change values, but only through calculations, filters, sets or reference lines.
  • Filter, highlight and URL actions connect views and outside resources.
  • Interpret patterns, outliers and group differences with their limits and a business implication.

Flashcards · Data Exploration and Interpretation

10 words
WordMeaningExample
  • Set

    A custom field that defines a subset of data; each member is In (True) or Out (False).

    Top 10 customers by SUM(Sales).

  • Bins

    Equal-width intervals created from a measure, producing a new dimension.

    Quantity (bin) with bin size 1.

  • Cluster

    Groups of marks with similar values found with the k-means algorithm.

    Customers clustered on SUM(Sales) and SUM(Profit).

  • k-means

    An algorithm that splits data into k groups by minimising the distance of points to their group centre.

    Analytics pane → Cluster, k chosen automatically.

  • Trend line

    A fitted model (linear, exponential, etc.) showing the overall direction of data.

    Linear trend on monthly sales; check R-squared.

  • Forecast

    Projected future values from exponential smoothing, with trend, seasonality and a prediction interval.

    Analytics → Forecast for the next 6 months.

  • Seasonality

    A pattern that repeats over a fixed period, such as every year.

    Retail sales rise every year before Tet.

  • Parameter

    A workbook variable the viewer can change; it must be used in a calculation, filter, set or line.

    Choose Measure: Sales, Profit or Quantity.

  • Filter action

    An interaction where selecting marks in one view filters other views.

    Click a Province to filter the trend chart.

  • Highlight action

    An interaction that emphasises related marks and dims the rest.

    Select Technology to highlight it everywhere.

Practice in Tableau — Lab 4C: Explore and interpret

  1. Set: top customers. Create a set of the Top 10 customers by Sales. Show In/Out of set as a share of total sales. Check: the top 10 bring in about 18.2% of sales; the largest customer is Bui Thi Giang (59,561).
  2. Group. Group the provinces of the Central region into Central coast and Central highlands and north-central and compare them.
  3. Bins. Bin the order value (FIXED LOD from Lab 4B) into bands of 500 and describe the distribution.
  4. Discount and profit. Profit Ratio by Discount. Check: 19.9% with no discount, 0.9% at 20%, -16.7% at 30% and -52.4% at 40%. Write a recommendation for the sales team.
  5. Trend and forecast. Monthly sales with a trend line, then Analytics → Forecast for the next 6 months. Explain why the forecast shows seasonality.
  6. Clusters. Customer-level scatter of SUM(Sales) × SUM(Profit), detail = Customer Name; drag Cluster from the Analytics pane. Describe each cluster in business terms (for example large and profitable, large but discount-driven).
  7. Parameter. Create a parameter Top N (5 to 20) and use it in the Top customers set so viewers can choose N.