Exploring multivariate value distributions

With the multivariate value distributions function, you can visually explore value distributions and relationships between the columns of a table. For each field in the table, a chart is displayed that shows the distribution of the values in the chart. Additionally to the chart, a table shows simple statistics, for example, the number of NULL values or the number of different values.

Procedure

To explore the attributes of a table:

  1. In the Data Source Explorer, right-click a table and select Value Distributions > Multivariate.
  2. Accept the default options on the Input Data Selection dialog by clicking OK.

    The Multivariate Distributions view is displayed. It shows a table that includes statistics for each field of the database table being explored. Below the table, the appropriate value distribution charts are displayed.

    By selecting different fields in the table, the value distributions of the selected fields are displayed in the charts below the table.

  3. To view the chart of a different field, click another field name, for example, AGE.
  4. To view the relationship between several fields, follow these steps:
    1. In the statistics table, select the fields, for example, AGE, SEX, BLOOD_PRESSURE, and HEART_RATE.

      A graphical view of these fields is displayed in the Charts section.

    2. In the AGE chart, select the column that represents patients between 50 and 60 years. In the SEX chart, select the column that represents male patients (m).

      Selecting these columns in these charts shows that male patients in the age between 50 and 60 years have approximately the same blood pressure distribution though there is a tendency to slightly higher values.

    Depending on the data that you are analyzing, relationships like these can give you deep insight in your data.

Feedback