Sets allow developers to divide a dimension, on the basis of its own content or that of another column, into subsets and create new perspectives as a result. This allows isolation of data segments and consequent generation of new insights.
There are three different types of sets:
A data record can be found inside or outside the defined condition or allocation, i.e. a binary view is involved here.
The binary view and different types of sets can be illustrated by means of examples:
- Threshold - customer file at a store
A customer is to be considered regular as soon as they start buying there more than 5 times a month (threshold). A customer can therefore be either inside the segment of regular customers (> 5 purchases per month) or outside (< 5 purchases per month).
- Top-ranking of sales outlets
A company’s headquarters wants to ascertain the top 3 outlets based on sales. This classification is performed without any fixed turnover threshold.
- Manual selection - favourite customers
A craftsman decides to send a discount to his favourite customers. The group of favourite customers can only be created through manual assignment by a data-savvy developer.
Categorizations which cannot be represented by binary logic are not possible with sets.