4.3 · Data Exploration and Interpretation
[markdown] content available only on the platform
[markdown] content available only on the platform
Flashcards · Data Exploration and Interpretation
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.
[pdf] Lecture slides — 4.3 Sets, Groups, Bins and Clusters (PDF) — /api/lesson-media/pdfs/4d3653ff-a3ca-4f63-bf8e-bb93c553e599-1794927038629-0fe60f8d3532bf09.pdf
[markdown] content available only on the platform
