Data Dictionary

Data Dictionary

Working with Data Dictionary

The Data Dictionary helps to create new datasets using the existing datasets. It is a part of the Rubiscape product selection screen. It uses the feature of Data Joining to create new datasets. You can use any two types of datasets and perform join operations on them.
Using Data Dictionary functions, you can add a calculated field to the dataset, add enumeration for the values, and create a hierarchy of features in the dataset.
You can treat the data dictionary like any other dataset. You can perform all the operations that could be performed on a dataset. The data dictionary can be used in workbooks to create different models. It can also be used in other applications, such as RubiSight, to create data visualizations.

(info) Notes:

  • In a data dictionary, it is possible to join different types of datasets such as RDBMS, File, Social Media, Hadoop, and so on.
  • You can create a data dictionary with independent datasets without adding join condition.
  • When you use a data dictionary with independent datasets to plot widgets in RubiSight, you can use columns from same the dataset only to plot a widget.
  • You cannot use an existing data dictionary to create a new data dictionary.

    • Related Articles

    • Data Preparation

      Data preparation is the process of cleaning and transforming raw data into organized data so that it can be processed and analyzed further. In data preparation, data is reformatted, corrected, and combined to enrich the data. Data preparation is ...

    • Data Unpivot

      Data Unpivot Description Data Unpivot is a way of transforming data from a wide format to a linear format. The source data is rearranged to make it a part of a single column in the new dataset. Why to use To transform the column data into row data ...

    • Data Unpivot

      Data Unpivot Description Data Unpivot is a way of transforming data from a wide format to a linear format. The source data is rearranged to make it a part of a single column in the new dataset. Why to use To transform the column data into row data ...

    • Data Pivot

      Data Pivot Description Data Pivot is a way of transforming data from a tall format to a wide format. The source data is rearranged in a way that unique values are converted into columns. Why to use To transform the row data into column data When to ...

    • Data Pivot

      Data Pivot Description Data Pivot is a way of transforming data from a tall format to a wide format. The source data is rearranged in a way that unique values are converted into columns. Why to use To transform the row data into column data When to ...